APPS.PA_CC_GL_TRANS_CCDS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 29: SELECT expenditure_item_id from pa_expenditure_items_all where expenditure_item_id in

25: ERRBUF IN OUT NOCOPY VARCHAR2)
26: IS
27:
28: Cursor Exp_Items is
29: SELECT expenditure_item_id from pa_expenditure_items_all where expenditure_item_id in
30: (SELECT ei.expenditure_item_id
31: FROM pa_cc_dist_lines ccd,
32: Pa_expenditure_items ei,
33: Pa_expenditures exp

Line 50: SELECT expenditure_item_id from pa_expenditure_items_all where expenditure_item_id in

46: AND exp.expenditure_id = ei.expenditure_id
47: AND exp.expenditure_group = p_EXPENDITURE_BATCH)
48: AND p_EXPENDITURE_BATCH is NOT NULL
49: UNION ALL
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

Line 79: SELECT expenditure_item_id from pa_expenditure_items_all where expenditure_item_id in

75: and proj.SEGMENT1 <= p_TO_PROJECT_NUMBER)))
76: AND (p_FROM_PROJECT_NUMBER is NOT NULL or p_TO_PROJECT_NUMBER is NOT NULL)
77: AND p_EXPENDITURE_BATCH is NULL
78: UNION ALL
79: SELECT expenditure_item_id from pa_expenditure_items_all where expenditure_item_id in
80: (SELECT ccd.expenditure_item_id
81: FROM pa_cc_dist_lines ccd
82: WHERE ccd.transfer_status_code in ('P','R')
83: AND (p_gl_category is null OR ccd.line_type = p_gl_category)