DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

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 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: