DBA Data[Home] [Help]

APPS.IBY_FD_POST_PICP_PROGS_PVT dependencies on IBY_DOCS_PAYABLE_ALL

Line 1110: FROM iby_docs_payable_all doc, iby_payments_all pmt,

1106: IS
1107:
1108: CURSOR l_doc_csr (p_payment_instruction_id IN NUMBER) IS
1109: SELECT document_payable_id
1110: FROM iby_docs_payable_all doc, iby_payments_all pmt,
1111: iby_pay_instructions_all ins
1112: WHERE ins.payment_instruction_id = p_payment_instruction_id
1113: AND ins.payment_instruction_id = pmt.payment_instruction_id
1114: AND doc.straight_through_flag = 'Y'

Line 1131: iby_docs_payable_all

1127:
1128: FOR l_doc IN l_doc_csr(p_payment_instruction_id) LOOP
1129:
1130: UPDATE
1131: iby_docs_payable_all
1132: SET
1133: straight_through_flag = 'N',
1134: object_version_number = object_version_number + 1,
1135: last_updated_by = fnd_global.user_id,