APPS.PA_TRX_IMPORT dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 7536: from ap_invoice_distributions_all apd

7532:
7533: cursor c_invdist is
7534: select parent_reversal_id
7535: into l_parent_dist_id
7536: from ap_invoice_distributions_all apd
7537: where invoice_distribution_id = NVL(l_SysRef5Tab(p_indx),0)
7538: and nvl(reversal_flag,'N') = 'Y';
7539:
7540: /* Self Assessed Tax Changes*/

Line 10927: from ap_invoice_distributions_all inv, pa_transaction_interface_all pti

10923: (select po_header_id, po_distribution_id
10924: from po_distributions_all
10925: where po_distribution_id in
10926: (select po_distribution_id
10927: from ap_invoice_distributions_all inv, pa_transaction_interface_all pti
10928: where inv.invoice_id = pti.cdl_system_reference2
10929: and inv.invoice_distribution_id = pti.cdl_system_reference5 /*REL12 : AP Lines Uptake changes*/
10930: and pti.transaction_source = p_calling_mode
10931: and pti.transaction_status_code = 'R'

Line 11019: l_line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE;

11015: l_base_qv NUMBER;
11016: l_base_av NUMBER;
11017: l_period_year pa_bc_packets.period_year%type; --REL12
11018: l_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
11019: l_line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE;
11020:
11021: -- R12 AP lines uptake : Prepayment changes :Cursor to fetch AP related details.
11022: CURSOR C_ap_details (p_invoice_id NUMBER,
11023: p_invoice_distribution_id NUMBER) IS

Line 12638: ap_invoice_distributions_all apd

12634: -- ====================================================================================
12635: CURSOR c_get_disc_amount is
12636: SELECT NVL(b.invoice_dist_base_amount , b.invoice_dist_amount) amount
12637: from ap_payment_hist_dists b,
12638: ap_invoice_distributions_all apd
12639: where b.invoice_payment_id = p_sys_ref4
12640: and b.invoice_distribution_id = p_sys_ref5
12641: and b.pay_dist_lookup_code = 'DISCOUNT'
12642: and apd.invoice_distribution_id = b.invoice_distribution_id

Line 13066: FROM ap_invoices_all A, ap_invoice_distributions_all aid

13062: WHERE po_distribution_id = p_po_dist_id;
13063:
13064: CURSOR c_get_vendor_id IS
13065: SELECT a.vendor_id
13066: FROM ap_invoices_all A, ap_invoice_distributions_all aid
13067: WHERE A.invoice_id = aid.invoice_id
13068: AND A.invoice_id = p_sys_ref2
13069: AND aid.invoice_distribution_id = p_sys_ref5
13070: UNION /* Added for bug 13859614 */

Line 13980: FROM ap_invoices_all A, ap_invoice_distributions_all aid

13976:
13977: /*bug 13601768*/
13978: CURSOR c_get_vendor_id IS
13979: SELECT a.vendor_id
13980: FROM ap_invoices_all A, ap_invoice_distributions_all aid
13981: WHERE A.invoice_id = aid.invoice_id
13982: AND A.invoice_id = p_sys_ref2
13983: AND aid.invoice_distribution_id = p_sys_ref5
13984: UNION /* Added for bug 13859614 */