APPS.IBY_PYO_TRANSACTION dependencies on IBY_PYO_INVOICE_GT

Line 67: SELECT COUNT(*) into l_doc_count FROM IBY_PYO_INVOICE_GT;

63: insert_into_gt(p_payment_instruction_id);
64:
65:
66: select count(*) into l_pmt_count FROM IBY_PYO_PAYMENT_GT;
67: SELECT COUNT(*) into l_doc_count FROM IBY_PYO_INVOICE_GT;
68:
69: IF (l_pmt_count = 0 OR l_doc_count = 0) THEN
70: fnd_file.put_line(fnd_file.log, 'Number of Payments Selected:'||l_pmt_count);
71: fnd_file.put_line(fnd_file.log, 'Number of Documents Selected:'||l_doc_count);

Line 783: INSERT INTO IBY_PYO_INVOICE_GT(PAYMENT_ID,

779: ec_debug.pl (3, 'Finished fetching Payment data');
780: ec_debug.pl (3, 'Fetching Invoice data');
781: fnd_file.put_line(fnd_file.log, 'Finished fetching Payment Data ::'||systimestamp);
782:
783: INSERT INTO IBY_PYO_INVOICE_GT(PAYMENT_ID,
784: PAYMENT_INSTRUCTION_ID,
785: PAY_SELECTED_CHECK_ID,
786: VENDOR_NUM,
787: CUSTOMER_NUM,

Line 965: delete from IBY_PYO_INVOICE_GT;

961: BEGIN
962: ec_debug.push('ECE_AP_TRANSACTION.delete_from_gt');
963: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: START ::'||systimestamp);
964: delete from IBY_PYO_PAYMENT_GT;
965: delete from IBY_PYO_INVOICE_GT;
966: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: END ::'||systimestamp);
967: ec_debug.pop ( 'ECE_AP_TRANSACTION.delete_from_gt');
968: END delete_from_gt;
969: