DBA Data[Home] [Help]

APPS.IBY_FD_POST_PICP_PROGS_PVT dependencies on IBY_DOCS_PAYABLE_ALL

Line 1319: FROM iby_docs_payable_all doc, iby_payments_all pmt,

1315: IS
1316:
1317: CURSOR l_doc_csr (p_payment_instruction_id IN NUMBER) IS
1318: SELECT document_payable_id
1319: FROM iby_docs_payable_all doc, iby_payments_all pmt,
1320: iby_pay_instructions_all ins
1321: WHERE ins.payment_instruction_id = p_payment_instruction_id
1322: AND ins.payment_instruction_id = pmt.payment_instruction_id
1323: AND doc.straight_through_flag = 'Y'

Line 1340: iby_docs_payable_all

1336:
1337: FOR l_doc IN l_doc_csr(p_payment_instruction_id) LOOP
1338:
1339: UPDATE
1340: iby_docs_payable_all
1341: SET
1342: straight_through_flag = 'N',
1343: object_version_number = object_version_number + 1,
1344: last_updated_by = fnd_global.user_id,