DBA Data[Home] [Help]

APPS.PAAPIMP_PKG dependencies on PA_EXPENDITURE_TYPES

Line 1352: from pa_expenditure_types

1348: WHERE dist.pa_addition_flag IN ('N', 'S', 'A', 'B', 'C', 'D', 'I', 'J', 'K', 'M', 'P', 'V', 'X', 'W')
1349: AND dist.posted_flag||'' = 'Y'
1350: AND dist.project_id = G_PROJECT_ID
1351: AND 'N' = (select cost_rate_flag
1352: from pa_expenditure_types
1353: where expenditure_type = dist.expenditure_type)
1354: AND EXISTS (SELECT invoice_id
1355: FROM AP_INVOICES inv
1356: WHERE inv.invoice_id = DIST.invoice_id

Line 1409: from pa_expenditure_types

1405: WHERE dist.pa_addition_flag IN ('N', 'S', 'A', 'B', 'C', 'D', 'I', 'J', 'K', 'M', 'P', 'V', 'X', 'W')
1406: AND dist.posted_flag||'' = 'Y'
1407: AND dist.project_id > 0
1408: AND 'N' = (select cost_rate_flag
1409: from pa_expenditure_types
1410: where expenditure_type = dist.expenditure_type)
1411: AND EXISTS (SELECT invoice_id
1412: FROM AP_INVOICES inv
1413: WHERE inv.invoice_id = DIST.invoice_id