DBA Data[Home] [Help]

APPS.PA_CC_GL_TRANS_CCDS dependencies on PA_PROJECTS_ALL

Line 54: pa_projects_all proj

50: SELECT expenditure_item_id from pa_expenditure_items_all where expenditure_item_id in
51: (SELECT ei.expenditure_item_id
52: FROM pa_cc_dist_lines ccd,
53: pa_expenditure_items ei,
54: pa_projects_all proj
55: WHERE ccd.transfer_status_code in ('P','R')
56: AND (p_gl_category is null OR ccd.line_type = p_gl_category)
57: AND (ccd.line_type = 'BL' OR
58: (Ccd.line_type = 'PC' AND EXISTS (SELECT 'X'