APPS.IBY_PAYGROUP_PUB dependencies on HZ_LOCATIONS

Line 11949: * -- get the address field from HZ_LOCATIONS --

11945: *
11946: * for each add field:
11947: * if (pmt.address_source = 'TCA')
11948: * {
11949: * -- get the address field from HZ_LOCATIONS --
11950: * }
11951: * else
11952: * {
11953: * -- this is an employee address --

Line 12583: HZ_LOCATIONS payee_loc

12579: PER_ALL_ASSIGNMENTS_F per_assgn,
12580: PER_ADDRESSES per_addr_prov,
12581:
12582: /* Supplier address related */
12583: HZ_LOCATIONS payee_loc
12584: WHERE
12585: pmt.payment_id = p_payment_id
12586: AND pmt.employee_person_id = per_addr.person_id(+)
12587: AND per_addr.primary_flag(+) = 'Y'

Line 13094: * -- get the address field from HZ_LOCATIONS --

13090: *
13091: * for each add field:
13092: * if (pmt.address_source = 'TCA')
13093: * {
13094: * -- get the address field from HZ_LOCATIONS --
13095: * }
13096: * else
13097: * {
13098: * -- this is an employee address --

Line 13728: HZ_LOCATIONS payee_loc

13724: PER_ALL_ASSIGNMENTS_F per_assgn,
13725: PER_ADDRESSES per_addr_prov,
13726:
13727: /* Supplier address related */
13728: HZ_LOCATIONS payee_loc
13729: WHERE
13730: pmt.payment_id = p_payment_id
13731: AND pmt.employee_person_id = per_addr.person_id(+)
13732: AND per_addr.primary_flag(+) = 'Y'