APPS.PA_XLA_UPGRADE dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 19: l_table_name varchar2(30) := 'PA_EXPENDITURE_ITEMS_ALL';

15:
16: -----------------------------------------------------
17: -- Ad parallelization variables
18: -----------------------------------------------------
19: l_table_name varchar2(30) := 'PA_EXPENDITURE_ITEMS_ALL';
20: l_rows_processed number;
21: l_start_eiid number;
22: l_end_eiid number;
23: l_any_rows_to_process boolean;

Line 264: PA_EXPENDITURE_ITEMS_ALL ei,

260: 'Liability' CR_REFERENCE_3,
261: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
262: to_char('-99') CR_REFERENCE_2
263: FROM PA_COST_DISTRIBUTION_LINES_ALL cdl,
264: PA_EXPENDITURE_ITEMS_ALL ei,
265: PA_IMPLEMENTATIONS_ALL imp,
266: (select ledger_id,min(min_value) min_value, max(max_value) max_value from
267: PA_XLA_UPG_CTRL
268: where reference = 'GL_PERIOD_STATUSES'

Line 340: PA_EXPENDITURE_ITEMS_ALL ei,

336: 'Cross Charge Credit' CR_REFERENCE_3,
337: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
338: to_char(cdl.cr_code_combination_id) CR_REFERENCE_2
339: FROM PA_CC_DIST_LINES_ALL cdl,
340: PA_EXPENDITURE_ITEMS_ALL ei,
341: PA_IMPLEMENTATIONS_ALL imp,
342: (select ledger_id,min(min_value) min_value, max(max_value) max_value from
343: PA_XLA_UPG_CTRL
344: where reference = 'GL_PERIOD_STATUSES'

Line 888: l_table_name varchar2(30) := 'PA_EXPENDITURE_ITEMS_ALL';

884:
885: -----------------------------------------------------
886: -- Ad parallelization variables
887: -----------------------------------------------------
888: l_table_name varchar2(30) := 'PA_EXPENDITURE_ITEMS_ALL';
889: l_rows_processed number;
890: l_start_eiid number;
891: l_end_eiid number;
892: l_any_rows_to_process boolean;

Line 1111: PA_EXPENDITURE_ITEMS_ALL ei,

1107: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
1108: to_char('-99') CR_REFERENCE_2
1109: from PA_MC_COST_DIST_LINES_ALL mc,
1110: PA_COST_DISTRIBUTION_LINES_ALL cdl,
1111: PA_EXPENDITURE_ITEMS_ALL ei,
1112: PA_IMPLEMENTATIONS_ALL imp,
1113: XLA_EVENTS evt,
1114: HR_ORGANIZATION_INFORMATION hoi
1115: where mc.expenditure_item_id = cdl.expenditure_item_id

Line 1162: PA_EXPENDITURE_ITEMS_ALL ei,

1158: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
1159: to_char(cdl.cr_code_combination_id) CR_REFERENCE_2
1160: from PA_MC_CC_DIST_LINES_ALL mc,
1161: PA_CC_DIST_LINES_ALL cdl,
1162: PA_EXPENDITURE_ITEMS_ALL ei,
1163: PA_IMPLEMENTATIONS_ALL imp,
1164: XLA_EVENTS evt,
1165: HR_ORGANIZATION_INFORMATION hoi
1166: where mc.expenditure_item_id = cdl.expenditure_item_id

Line 1755: VALUES ('PA_EXPENDITURE_ITEMS_ALL', l_min_eiid, l_max_eiid, '', p_batch_id, 'P');

1751: end if;
1752:
1753:
1754: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)
1755: VALUES ('PA_EXPENDITURE_ITEMS_ALL', l_min_eiid, l_max_eiid, '', p_batch_id, 'P');
1756:
1757:
1758:
1759: ---------------------------------------------------------------------------------------------------