DBA Data[Home] [Help]

APPS.GMS_PA_API dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 1591: AP_SELF_ASSESSED_TAX_DIST_ALL apsat

1587: and apd.invoice_distribution_id = NVL ( adl.invoice_distribution_id, 0)
1588: union /* BUG 14216205 : Added the union for SAT */
1589: select adl.award_id
1590: from GMS_AWARD_DISTRIBUTIONS ADL,
1591: AP_SELF_ASSESSED_TAX_DIST_ALL apsat
1592: where apsat.award_id = adl.award_set_id
1593: and adl.adl_line_num = 1
1594: and adl.adl_status = 'A'
1595: and apsat.invoice_id = to_number(x_invoice_id)

Line 2331: AP_SELF_ASSESSED_TAX_DIST_ALL APSAT

2327: when NO_DATA_FOUND THEN
2328: select ADL.AWARD_ID
2329: into l_award_id
2330: from GMS_AWARD_DISTRIBUTIONS ADL,
2331: AP_SELF_ASSESSED_TAX_DIST_ALL APSAT
2332: where APSAT.INVOICE_ID = l_system_reference2
2333: and apsat.invoice_distribution_id = l_system_reference5
2334: and apsat.invoice_id = adl.invoice_id
2335: and apsat.invoice_distribution_id = adl.invoice_distribution_id