APPS.PA_CC_GL_TRANS_CCDS dependencies on PA_CC_DIST_LINES

Line 31: FROM pa_cc_dist_lines ccd,

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

Line 52: FROM pa_cc_dist_lines ccd,

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

Line 81: FROM pa_cc_dist_lines ccd

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)
84: AND (ccd.line_type = 'BL' OR
85: (ccd.line_type = 'PC' AND EXISTS (SELECT 'X'

Line 149: UPDATE pa_cc_dist_lines ccd

145:
146: log_message('40 : EI locked with '||sql%rowcount ||' records');
147:
148: FORALL i IN 1..EiidTab.count
149: UPDATE pa_cc_dist_lines ccd
150: SET ccd.transfer_status_code = 'X',
151: ccd.transfer_rejection_code = NULL,
152: ccd.request_id = G_conc_request_id
153: WHERE ccd.expenditure_item_id = EiidTab (i)