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: PA_XLA_UPG_CTRL ctrl,
267: HR_ORGANIZATION_INFORMATION hoi
268: WHERE cdl.expenditure_item_id between l_start_eiid and l_end_eiid

Line 335: PA_EXPENDITURE_ITEMS_ALL ei,

331: 'Cross Charge Credit' CR_REFERENCE_3,
332: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
333: to_char(cdl.cr_code_combination_id) CR_REFERENCE_2
334: FROM PA_CC_DIST_LINES_ALL cdl,
335: PA_EXPENDITURE_ITEMS_ALL ei,
336: PA_IMPLEMENTATIONS_ALL imp,
337: PA_XLA_UPG_CTRL ctrl,
338: HR_ORGANIZATION_INFORMATION hoi
339: WHERE cdl.expenditure_item_id between l_start_eiid and l_end_eiid

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

873:
874: -----------------------------------------------------
875: -- Ad parallelization variables
876: -----------------------------------------------------
877: l_table_name varchar2(30) := 'PA_EXPENDITURE_ITEMS_ALL';
878: l_rows_processed number;
879: l_start_eiid number;
880: l_end_eiid number;
881: l_any_rows_to_process boolean;

Line 1100: PA_EXPENDITURE_ITEMS_ALL ei,

1096: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
1097: to_char('-99') CR_REFERENCE_2
1098: from PA_MC_COST_DIST_LINES_ALL mc,
1099: PA_COST_DISTRIBUTION_LINES_ALL cdl,
1100: PA_EXPENDITURE_ITEMS_ALL ei,
1101: PA_IMPLEMENTATIONS_ALL imp,
1102: XLA_EVENTS evt,
1103: HR_ORGANIZATION_INFORMATION hoi
1104: where mc.expenditure_item_id = cdl.expenditure_item_id

Line 1151: PA_EXPENDITURE_ITEMS_ALL ei,

1147: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
1148: to_char(cdl.cr_code_combination_id) CR_REFERENCE_2
1149: from PA_MC_CC_DIST_LINES_ALL mc,
1150: PA_CC_DIST_LINES_ALL cdl,
1151: PA_EXPENDITURE_ITEMS_ALL ei,
1152: PA_IMPLEMENTATIONS_ALL imp,
1153: XLA_EVENTS evt,
1154: HR_ORGANIZATION_INFORMATION hoi
1155: where mc.expenditure_item_id = cdl.expenditure_item_id

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

1721: end if;
1722:
1723:
1724: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)
1725: VALUES ('PA_EXPENDITURE_ITEMS_ALL', l_min_eiid, l_max_eiid, '', p_batch_id, 'P');
1726:
1727:
1728:
1729: ---------------------------------------------------------------------------------------------------