[Home] [Help]
2603: * simple and quick that targets the basic errors on the
2604: * document.
2605: *
2606: * We will continue to pick up the payee address from
2607: * HZ_LOCATIONS. In the case of employee type payees
2608: * the payee address fields will be null. This is
2609: * fine. The offline validation will catch these
2610: * errors anyway.
2611: */
2629: IBY_DOCS_PAYABLE_GT docs,
2630: IBY_PP_FIRST_PARTY_V payer,
2631: HZ_PARTIES payee,
2632: HZ_PARTY_SITES payeesite,
2633: HZ_LOCATIONS payee_loc,
2634: CE_BANK_ACCOUNTS iba,
2635: CE_BANK_BRANCHES_V iba_bnk_branch,
2636: IBY_EXT_BANK_ACCOUNTS_INT_V eba,
2637: CE_BANK_BRANCHES_V eba_bank_branch,
3009: CE_BANK_ACCOUNTS iba,
3010: CE_BANK_BRANCHES_V iba_bnk_branch,
3011: /* Payee */
3012: HZ_PARTIES payee,
3013: HZ_LOCATIONS payee_loc,
3014: /* Payee bank */
3015: IBY_EXT_BANK_ACCOUNTS_V eba
3016: WHERE
3017: /* document related */
6985: /*
6986: * Fix for bug 5997016:
6987: *
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: *
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
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
7617: PER_ADDRESSES per_addr_prov,
7618: PER_ALL_ASSIGNMENTS_F per_assgn,
7619:
7620: /* Supplier address related */
7621: HZ_LOCATIONS payee_loc
7622: WHERE
7623: doc.payment_service_request_id = p_pay_service_request_id
7624: AND doc.employee_person_id = per_addr.person_id(+)
7625: AND per_addr.primary_flag(+) = 'Y'