[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'
528:
529: -- Cursor to fetch amount on invoice distribution
530: CURSOR c_ap_amt IS
531: SELECT NVL(apdist.base_amount,apdist.amount)
532: FROM ap_invoice_distributions_all apdist
533: WHERE apdist.invoice_distribution_id = g_xface_rec.invoice_distribution_id
534: AND apdist.invoice_id = g_xface_rec.invoice_id ;
535:
536: -- Bug : 5414183
582: -- ====================================================================================
583: CURSOR c_get_disc_amount is
584: SELECT NVL(b.invoice_dist_base_amount , b.invoice_dist_amount) amount
585: from ap_payment_hist_dists b,
586: ap_invoice_distributions_all apd
587: where b.invoice_payment_id = g_xface_rec.cdl_system_reference4
588: and b.invoice_distribution_id = g_xface_rec.invoice_distribution_id
589: and b.pay_dist_lookup_code = 'DISCOUNT'
590: and apd.invoice_distribution_id = b.invoice_distribution_id
1032: ELSIF g_xface_rec.invoice_type_lookup_code = 'PREPAYMENT' THEN
1033:
1034: SELECT DECODE(po_distribution_id,NULL,'N','Y')
1035: INTO l_po_matched_flag
1036: FROM ap_invoice_distributions
1037: WHERE invoice_id = g_xface_rec.invoice_id
1038: AND invoice_distribution_id = g_xface_rec.invoice_distribution_id
1039: AND line_type_lookup_code = 'ITEM';
1040:
3344: v_login
3345: from pa_transaction_interface_all txn,
3346: pa_expenditure_items_all ei,
3347: pa_cost_distribution_lines_all cdl,
3348: ap_invoice_distributions_all apd,
3349: gms_award_distributions adl
3350: where txn.interface_id = p_xface_id
3351: and nvl(txn.transaction_status_code, 'Z') <> 'R'
3352: and txn.batch_name = p_batch