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 2285: ap_invoice_distributions_all apd

2281: --
2282: select adl.award_id
2283: into l_award_id
2284: from gms_Award_distributions adl,
2285: ap_invoice_distributions_all apd
2286: where apd.invoice_id = l_system_reference2
2287: and apd.invoice_distribution_id = l_system_reference5
2288: and apd.invoice_id = adl.invoice_id
2289: and apd.invoice_distribution_id = adl.invoice_distribution_id