DBA Data[Home] [Help]

APPS.IBY_VALIDATIONSETS_PUB dependencies on PER_ADDRESSES

Line 1895: * per_addresses (HR).

1891: * The payee address cannot be always assumed to be stored in
1892: * HZ_LOCATIONS table (TCA).
1893: *
1894: * For employee type payees, the address is stored in
1895: * per_addresses (HR).
1896: *
1897: * The 'address source' column on the document payable identifies
1898: * the source of the address information -
1899: * TCA = address is stored in HZ_LOCATIONS

Line 1900: * HR = address is stored in PER_ADDRESSES

1896: *
1897: * The 'address source' column on the document payable identifies
1898: * the source of the address information -
1899: * TCA = address is stored in HZ_LOCATIONS
1900: * HR = address is stored in PER_ADDRESSES
1901: *
1902: * Therefore, we need to dynamically pick up the payee address
1903: * fields from the correct table. The SELECT statement below is
1904: * used to dynamically form the address table based on the

Line 2432: PER_ADDRESSES per_addr,

2428: IBY_DOCS_PAYABLE_ALL doc,
2429:
2430: /* Employee address related */
2431: HR_LOCATIONS per_loc,
2432: PER_ADDRESSES per_addr,
2433: PER_ALL_ASSIGNMENTS_F per_assgn,
2434:
2435: /* Supplier address related */
2436: HZ_LOCATIONS payee_loc