APPS.PA_TRX_IMPORT dependencies on AP_SELF_ASSESSED_TAX_DIST

Line 7544: from AP_SELF_ASSESSED_TAX_DIST_ALL apd

7540: /* Self Assessed Tax Changes*/
7541: cursor c_satdist is
7542: select parent_reversal_id
7543: into l_parent_dist_id
7544: from AP_SELF_ASSESSED_TAX_DIST_ALL apd
7545: where invoice_distribution_id = NVL(l_SysRef5Tab(p_indx),0)
7546: and nvl(reversal_flag,'N') = 'Y';
7547:
7548: cursor c_rcvtxn is

Line 10466: ap_self_assessed_tax_dist c,

10462: a.budget_line_id ,
10463: a.budget_version_id
10464: from pa_bc_packets a,
10465: pa_transaction_interface b,
10466: ap_self_assessed_tax_dist c,
10467: po_distributions d
10468: where a.txn_interface_id = b.txn_interface_id
10469: and a.document_header_id = d.po_header_id
10470: and a.document_distribution_id = d.po_distribution_id

Line 11042: FROM ap_self_assessed_tax_dist dist,

11038: nvl(dist.base_quantity_variance,0), --PA.M QV and AV
11039: NVL(dist.base_amount_variance,0),
11040: inv.invoice_type_lookup_code,
11041: dist.line_type_lookup_code
11042: FROM ap_self_assessed_tax_dist dist,
11043: ap_invoices inv
11044: WHERE dist.invoice_id = p_invoice_id
11045: AND dist.invoice_distribution_id = p_invoice_distribution_id
11046: AND inv.invoice_id = dist.invoice_id

Line 13055: FROM ap_self_assessed_tax_dist

13051: WHERE invoice_id = p_sys_ref2
13052: AND invoice_distribution_id = p_sys_ref5
13053: union /*Self Assessed Tax Changes*/
13054: SELECT po_distribution_id
13055: FROM ap_self_assessed_tax_dist
13056: WHERE invoice_id = p_sys_ref2
13057: AND invoice_distribution_id = p_sys_ref5;
13058:
13059: CURSOR c_get_po_LINE_id (p_po_dist_id NUMBER) IS

Line 13072: FROM ap_invoices_all A, ap_self_assessed_tax_dist_all aid

13068: AND A.invoice_id = p_sys_ref2
13069: AND aid.invoice_distribution_id = p_sys_ref5
13070: UNION /* Added for bug 13859614 */
13071: SELECT a.vendor_id
13072: FROM ap_invoices_all A, ap_self_assessed_tax_dist_all aid
13073: WHERE A.invoice_id = aid.invoice_id
13074: AND A.invoice_id = p_sys_ref2
13075: AND aid.invoice_distribution_id = p_sys_ref5;
13076:

Line 13986: FROM ap_invoices_all A, ap_self_assessed_tax_dist_all aid

13982: AND A.invoice_id = p_sys_ref2
13983: AND aid.invoice_distribution_id = p_sys_ref5
13984: UNION /* Added for bug 13859614 */
13985: SELECT a.vendor_id
13986: FROM ap_invoices_all A, ap_self_assessed_tax_dist_all aid
13987: WHERE A.invoice_id = aid.invoice_id
13988: AND A.invoice_id = p_sys_ref2
13989: AND aid.invoice_distribution_id = p_sys_ref5;
13990: