APPS.PA_CC_GL_TRANS_CCDS dependencies on PA_EXPENDITURE_ITEMS

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 32: Pa_expenditure_items ei,

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
34: WHERE ccd.transfer_status_code in ('P','R')
35: AND (p_gl_category is null OR ccd.line_type = p_gl_category)
36: AND (ccd.line_type = 'BL' OR

Line 52: SELECT expenditure_item_id from pa_expenditure_items_all where expenditure_item_id in

48: AND exp.expenditure_id = ei.expenditure_id
49: AND exp.expenditure_group = p_EXPENDITURE_BATCH)
50: AND p_EXPENDITURE_BATCH is NOT NULL
51: UNION ALL
52: SELECT expenditure_item_id from pa_expenditure_items_all where expenditure_item_id in
53: (SELECT ei.expenditure_item_id
54: FROM pa_cc_dist_lines ccd,
55: pa_expenditure_items ei,
56: pa_projects_all proj

Line 55: pa_expenditure_items ei,

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

Line 82: SELECT expenditure_item_id from pa_expenditure_items_all where expenditure_item_id in

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

Line 146: UPDATE pa_expenditure_items

142:
143: IF EiidTab.count > 0 Then
144:
145: FORALL i IN 1..EiidTab.count
146: UPDATE pa_expenditure_items
147: SET last_updated_by = last_updated_by
148: WHERE expenditure_item_id = EiidTab (i);
149:
150: log_message('40 : EI locked with '||sql%rowcount ||' records');