DBA Data[Home] [Help]

APPS.PA_MASS_ADDITIONS_CREATE_PKG dependencies on PA_PROJECT_TYPES_ALL

Line 287: pa_project_types_all pt

283: --
284: -- bug:4778189 - cross charge projects related transactions didn't generate assets.
285: --
286: pa_projects_all p,
287: pa_project_types_all pt
288: where ei.expenditure_item_id = cdl.expenditure_item_id
289: and cdl.expenditure_item_id = eic.expenditure_item_id (+)
290: and cdl.line_num = eic.line_number (+)
291: and ei.transaction_source in ('AP INVOICE' , 'AP EXPENSE', 'AP NRTAX', 'AP VARIANCE', 'AP ERV', /* Bug 5284323 */

Line 942: pa_project_types_all pt

938: ap_alc_ledger_gt algt,
939: ap_acct_class_code_gt aagt,
940: gl_code_combinations glcc,
941: pa_projects_all p,
942: pa_project_types_all pt
943: where ei.expenditure_item_id = cdl.expenditure_item_id
944: and cdl.expenditure_item_id = eic.expenditure_item_id (+)
945: and cdl.line_num = eic.line_number (+)
946: and ei.transaction_source in ('AP DISCOUNTS')

Line 1630: pa_project_types_all pt

1626: ap_alc_ledger_gt algt,
1627: ap_acct_class_code_gt aagt,
1628: gl_code_combinations glcc,
1629: pa_projects_all p,
1630: pa_project_types_all pt
1631: where ei.expenditure_item_id = cdl.expenditure_item_id
1632: and cdl.expenditure_item_id = eic.expenditure_item_id (+)
1633: and cdl.line_num = eic.line_number (+)
1634: and ei.transaction_source in ('PO RECEIPT',