Why does the Cash Advance "Add" view require EMPLID to already be present on a cash advance?
I was having some issues using the Cash Advance Add pages (Employee and T&E), and dug into it a little.
Employee SS component is TE_ADVANCE and search record EX_ADV_ADD_VW
SELECT c.authorized_oprid
, a.advance_id
, a.advance_name
, b.name
, a.emplid
, a.adv_status
, a.creation_dt
FROM ps_ex_adv_hdr a
, ps_personal_data b
, ps_ex_ee_auth_tbl c
WHERE a.adv_status = 'PND'
AND b.emplid = a.emplid
AND c.emplid = a.emplid
AND c.ee_auth_level <> 'V'
T&E component is TE_ADVANCE2 and Search record EX_ADV2_ADD_VW