APPS.IGI_STP_CREATE_PCK_PKG dependencies on AP_INVOICES

Line 248: from ap_invoices

244: if l_application = 'AP'
245: then
246: select invoice_currency_code
247: into l_currency_code
248: from ap_invoices
249: where invoice_num = l_trx_number;
250:
251: else
252: select invoice_currency_code

Line 546: FROM ap_invoices api,

542: l_message := 'Getting the liability account';
543: IF l_liability_ccid is null THEN
544: SELECT api.accts_pay_code_combination_id
545: INTO l_liability_ccid
546: FROM ap_invoices api,
547: igi_stp_candidates candidates
548: WHERE api.invoice_id = candidates.trx_id
549: AND candidates.package_id = p_package_id
550: AND candidates.netting_trx_type_id = p_netting_trx_type_id

Line 710: FROM ap_invoices_all api,

706: IF l_liability_ccid is null
707: THEN
708: SELECT api.accts_pay_code_combination_id
709: INTO l_liability_ccid
710: FROM ap_invoices_all api,
711: igi_stp_candidates_all candidates
712: WHERE api.invoice_id = candidates.trx_id
713: AND candidates.package_id = p_package_id
714: AND candidates.netting_trx_type_id = p_netting_trx_type_id

Line 1184: FROM ap_invoices api,

1180: l_message := 'Getting the liability account';
1181: IF l_liability_ccid is null THEN
1182: SELECT api.accts_pay_code_combination_id
1183: INTO l_liability_ccid
1184: FROM ap_invoices api,
1185: igi_stp_candidates candidates
1186: WHERE api.invoice_id = candidates.trx_id
1187: AND candidates.package_id = p_package_id
1188: AND candidates.netting_trx_type_id = p_netting_trx_type_id