[Home] [Help]
505: -- to which payment is being interfaced
506:
507: CURSOR C_ap_amt_brc IS
508: SELECT nvl(adl.burdenable_raw_cost,0),NVL(adl.payment_status_flag,'N')
509: FROM ap_invoice_distributions APD,
510: gms_award_distributions ADL
511: where adl.invoice_distribution_id = APD.invoice_distribution_id
512: and adl.adl_status = 'A'
513: and adl.document_type = 'AP'
538:
539: -- Cursor to fetch amount on invoice distribution
540: CURSOR c_ap_amt IS
541: SELECT NVL(apdist.base_amount,apdist.amount)
542: FROM ap_invoice_distributions_all apdist
543: WHERE apdist.invoice_distribution_id = g_xface_rec.invoice_distribution_id
544: AND apdist.invoice_id = g_xface_rec.invoice_id
545: union /* BUG 14216205 : Added the union for SAT */
546: select NVL(APSAT.BASE_AMOUNT,APSAT.AMOUNT)
597: -- ====================================================================================
598: CURSOR c_get_disc_amount is
599: SELECT NVL(b.invoice_dist_base_amount , b.invoice_dist_amount) amount
600: from ap_payment_hist_dists b,
601: ap_invoice_distributions_all apd
602: where b.invoice_payment_id = g_xface_rec.cdl_system_reference4
603: and b.invoice_distribution_id = g_xface_rec.invoice_distribution_id
604: and b.pay_dist_lookup_code = 'DISCOUNT'
605: and apd.invoice_distribution_id = b.invoice_distribution_id
1063: ELSIF g_xface_rec.invoice_type_lookup_code = 'PREPAYMENT' THEN
1064:
1065: SELECT DECODE(po_distribution_id,NULL,'N','Y')
1066: INTO l_po_matched_flag
1067: FROM ap_invoice_distributions
1068: WHERE invoice_id = g_xface_rec.invoice_id
1069: AND invoice_distribution_id = g_xface_rec.invoice_distribution_id
1070: AND line_type_lookup_code = 'ITEM';
1071:
3427: v_login
3428: from pa_transaction_interface_all txn,
3429: pa_expenditure_items_all ei,
3430: pa_cost_distribution_lines_all cdl,
3431: ap_invoice_distributions_all apd,
3432: gms_award_distributions adl
3433: where txn.interface_id = p_xface_id
3434: and nvl(txn.transaction_status_code, 'Z') <> 'R'
3435: and txn.batch_name = p_batch