APPS.IBY_PAYGROUP_PUB dependencies on PER_ADDRESSES

Line 24703: PER_ADDRESSES per_addr_prov

24699: || per_addr_prov.postal_code)
24700: add_concat
24701: FROM
24702: /* Employee address related */
24703: PER_ADDRESSES per_addr_prov
24704: WHERE
24705: IBY_PAYGROUP_PUB.pmtTable.employee_person_id(l_trx_index) = per_addr_prov.person_id
24706: AND per_addr_prov.address_type = 'M'
24707: AND SYSDATE BETWEEN

Line 24893: PER_ADDRESSES per_addr

24889: || per_addr.postal_code) add_concat
24890:
24891: FROM
24892: /* Employee address related */
24893: PER_ADDRESSES per_addr
24894: WHERE
24895: IBY_PAYGROUP_PUB.pmtTable.employee_person_id(l_trx_index) = per_addr.person_id
24896: AND per_addr.primary_flag = 'Y'
24897: AND SYSDATE BETWEEN per_addr.date_from AND NVL(per_addr.date_to, SYSDATE+1);

Line 25104: PER_ADDRESSES per_addr,

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
25108: IBY_PAYGROUP_PUB.pmtTable.employee_person_id(l_trx_index) = per_addr.person_id(+)