DBA Data[Home] [Help]

APPS.IBY_VALIDATIONSETS_PUB dependencies on PER_ADDRESSES

Line 6992: * per_addresses (HR).

6988: * The payee address cannot be always assumed to be stored in
6989: * HZ_LOCATIONS table (TCA).
6990: *
6991: * For employee type payees, the address is stored in
6992: * per_addresses (HR).
6993: *
6994: * The 'address source' column on the document payable identifies
6995: * the source of the address information -
6996: * TCA = address is stored in HZ_LOCATIONS

Line 6997: * HR = address is stored in PER_ADDRESSES

6993: *
6994: * The 'address source' column on the document payable identifies
6995: * the source of the address information -
6996: * TCA = address is stored in HZ_LOCATIONS
6997: * HR = address is stored in PER_ADDRESSES
6998: *
6999: * Therefore, we need to dynamically pick up the payee address
7000: * fields from the correct table. The SELECT statement below is
7001: * used to dynamically form the address table based on the

Line 7616: PER_ADDRESSES per_addr,

7612: IBY_DOCS_PAYABLE_ALL doc,
7613:
7614: /* Employee address related */
7615: HR_LOCATIONS per_loc,
7616: PER_ADDRESSES per_addr,
7617: PER_ADDRESSES per_addr_prov,
7618: PER_ALL_ASSIGNMENTS_F per_assgn,
7619:
7620: /* Supplier address related */

Line 7617: PER_ADDRESSES per_addr_prov,

7613:
7614: /* Employee address related */
7615: HR_LOCATIONS per_loc,
7616: PER_ADDRESSES per_addr,
7617: PER_ADDRESSES per_addr_prov,
7618: PER_ALL_ASSIGNMENTS_F per_assgn,
7619:
7620: /* Supplier address related */
7621: HZ_LOCATIONS payee_loc