APPS.IGI_STP_CREATE_PCK_PKG dependencies on IGI_STP_CANDIDATES_ALL

Line 33: FROM igi_stp_candidates_all

29: --org_id added as part of MOAC uptake
30: CURSOR get_candidate_packages IS
31: SELECT distinct package_id,
32: netting_trx_type_id
33: FROM igi_stp_candidates_all
34: WHERE batch_id =p_batch_id
35: AND org_id = p_org_id;
36:
37: -- get_ap_amount : to calculate the sum of the invoice

Line 51: FROM igi_stp_candidates_ALL

47: -- get_ar_amount : to calculate the sum of the invoice
48: -- amounts selected for a package and netting transaction
49: CURSOR get_ar_amount IS
50: SELECT sum(amount) ar_amount
51: FROM igi_stp_candidates_ALL
52: WHERE batch_id = p_batch_id
53: AND application = 'AR'
54: AND ORG_ID = P_ORG_ID
55: AND netting_trx_type_id = p_netting_trx_type_id

Line 151: FROM igi_stp_candidates_all cand,

147: currency_code,
148: exchange_rate,
149: exchange_rate_type,
150: exchange_date
151: FROM igi_stp_candidates_all cand,
152: igi_stp_net_type_alloc_all net
153: WHERE cand.batch_id = p_batch_id
154: AND cand.package_id = p_package_id
155: AND cand.netting_trx_type_id = p_netting_trx_type_id

Line 711: igi_stp_candidates_all candidates

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
715: AND candidates.batch_id = p_batch_id