DBA Data[Home] [Help]

APPS.GMS_PA_API dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1577: ap_invoice_distributions_all apd

1573: -- =============================================================================
1574: cursor c_get_award is
1575: select adl.award_id
1576: from gms_award_distributions adl,
1577: ap_invoice_distributions_all apd
1578: where apd.award_id = adl.award_set_id
1579: and adl.adl_line_num = 1
1580: and adl.adl_status = 'A'
1581: and apd.invoice_id = to_number(x_invoice_id)

Line 2299: ap_invoice_distributions_all apd

2295: /* BUG 14216205 : Commented the below code : Starts */
2296: /*select adl.award_id
2297: into l_award_id
2298: from gms_Award_distributions adl,
2299: ap_invoice_distributions_all apd
2300: where apd.invoice_id = l_system_reference2
2301: and apd.invoice_distribution_id = l_system_reference5
2302: and apd.invoice_id = adl.invoice_id
2303: and apd.invoice_distribution_id = adl.invoice_distribution_id

Line 2316: ap_invoice_distributions_all apd

2312: begin
2313: select adl.award_id
2314: into l_award_id
2315: from gms_Award_distributions adl,
2316: ap_invoice_distributions_all apd
2317: where apd.invoice_id = l_system_reference2
2318: and apd.invoice_distribution_id = l_system_reference5
2319: and apd.invoice_id = adl.invoice_id
2320: and apd.invoice_distribution_id = adl.invoice_distribution_id