APPS.IBY_PAYGROUP_PUB dependencies on PER_ADDRESSES

Line 11911: * PER_ADDRESSES or HR_LOCATIONS.

11907: /*
11908: * Fix for bug 5928084:
11909: *
11910: * Derive address of employee type payees using
11911: * PER_ADDRESSES or HR_LOCATIONS.
11912: *
11913: * The select statement below dynamically creates the payee
11914: * address table. The dynamically created table is named
11915: * as payee_add. Columns from this table are referenced in the

Line 11934: * - PER_ADDRESSES (home addresses)

11930: * Supplier addresses are present in TCA and are located using
11931: * remit to location id column on the payment.
11932: *
11933: * Employee addresses can be in either
11934: * - PER_ADDRESSES (home addresses)
11935: * - HR_LOCATIONS (office addresses)
11936: * We use the 'employee address code' field on the payment to
11937: * decide which table to use.
11938: *

Line 11956: * -- get the address field from PER_ADDRESSES --

11952: * {
11953: * -- this is an employee address --
11954: * if (pmt.employee_address_code = 'HOME')
11955: * {
11956: * -- get the address field from PER_ADDRESSES --
11957: *
11958: * The select logic for this has been lifted from
11959: * AP's expense report import program.
11960: * }

Line 12578: PER_ADDRESSES per_addr,

12574: IBY_PAYMENTS_ALL pmt,
12575:
12576: /* Employee address related */
12577: HR_LOCATIONS per_loc,
12578: PER_ADDRESSES per_addr,
12579: PER_ALL_ASSIGNMENTS_F per_assgn,
12580: PER_ADDRESSES per_addr_prov,
12581:
12582: /* Supplier address related */

Line 12580: PER_ADDRESSES per_addr_prov,

12576: /* Employee address related */
12577: HR_LOCATIONS per_loc,
12578: PER_ADDRESSES per_addr,
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

Line 13056: * PER_ADDRESSES or HR_LOCATIONS.

13052: /*
13053: * Fix for bug 5928084:
13054: *
13055: * Derive address of employee type payees using
13056: * PER_ADDRESSES or HR_LOCATIONS.
13057: *
13058: * The select statement below dynamically creates the payee
13059: * address table. The dynamically created table is named
13060: * as payee_add. Columns from this table are referenced in the

Line 13079: * - PER_ADDRESSES (home addresses)

13075: * Supplier addresses are present in TCA and are located using
13076: * remit to location id column on the payment.
13077: *
13078: * Employee addresses can be in either
13079: * - PER_ADDRESSES (home addresses)
13080: * - HR_LOCATIONS (office addresses)
13081: * We use the 'employee address code' field on the payment to
13082: * decide which table to use.
13083: *

Line 13101: * -- get the address field from PER_ADDRESSES --

13097: * {
13098: * -- this is an employee address --
13099: * if (pmt.employee_address_code = 'HOME')
13100: * {
13101: * -- get the address field from PER_ADDRESSES --
13102: *
13103: * The select logic for this has been lifted from
13104: * AP's expense report import program.
13105: * }

Line 13723: PER_ADDRESSES per_addr,

13719: IBY_PAYMENTS_ALL pmt,
13720:
13721: /* Employee address related */
13722: HR_LOCATIONS per_loc,
13723: PER_ADDRESSES per_addr,
13724: PER_ALL_ASSIGNMENTS_F per_assgn,
13725: PER_ADDRESSES per_addr_prov,
13726:
13727: /* Supplier address related */

Line 13725: PER_ADDRESSES per_addr_prov,

13721: /* Employee address related */
13722: HR_LOCATIONS per_loc,
13723: PER_ADDRESSES per_addr,
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