DBA Data[Home] [Help]

APPS.IBY_PAYGROUP_PUB dependencies on HR_LOCATIONS

Line 24796: HR_LOCATIONS per_loc,

24792: || per_loc.postal_code) add_concat
24793:
24794: FROM
24795: /* Employee address related */
24796: HR_LOCATIONS per_loc,
24797: PER_ALL_ASSIGNMENTS_F per_assgn
24798: WHERE
24799: IBY_PAYGROUP_PUB.pmtTable.employee_person_id(l_trx_index) = per_assgn.person_id
24800: AND per_assgn.location_id = per_loc.location_id

Line 25103: HR_LOCATIONS per_loc,

25099: )
25100: add_concat
25101:
25102: FROM
25103: HR_LOCATIONS per_loc,
25104: PER_ADDRESSES per_addr,
25105: PER_ALL_ASSIGNMENTS_F per_assgn
25106:
25107: WHERE