APPS.PAY_EVENTS_WRAPPER dependencies on PER_ALL_ASSIGNMENTS_F

Line 134: c_ASSIGNMENTS_TABLE CONSTANT VARCHAR2(30) := 'per_all_assignments_f';

130: -- < PRIVATE CONSTANTS > -------------------------------------------------
131: --
132: -- The event model processing mode and other animals
133: c_PROCESS_MODE CONSTANT VARCHAR2(30) := 'ASG_CREATION';
134: c_ASSIGNMENTS_TABLE CONSTANT VARCHAR2(30) := 'per_all_assignments_f';
135: c_OUTPUT_BUFFER CONSTANT NUMBER := 2000000;
136: c_OUTPUT_LINE_LENGTH CONSTANT NUMBER := 255;
137: --
138: -- < PRIVATE GLOBALS > ---------------------------------------------------

Line 215: AND NOT (pdt.table_name = 'PER_ALL_ASSIGNMENTS_F' AND pde.column_name = 'SUPERVISOR_ID')

211: WHERE pde.event_group_id = p_evt
212: AND pde.dated_table_id = peu.dated_table_id
213: AND pdt.dated_table_id = pde.dated_table_id
214: AND pde.column_name = peu.column_name
215: AND NOT (pdt.table_name = 'PER_ALL_ASSIGNMENTS_F' AND pde.column_name = 'SUPERVISOR_ID')
216: AND pde.update_type = 'C'
217: )
218: GROUP BY ppe.assignment_id,peu.dated_table_id,ppe.surrogate_key;
219: --

Line 222: -- per_all_assignments_f, and only if that column is one of the ones

218: GROUP BY ppe.assignment_id,peu.dated_table_id,ppe.surrogate_key;
219: --
220: -- Decode the description column of pay_process_events to obtain the
221: -- before and after values, just for the supervisor ID column on
222: -- per_all_assignments_f, and only if that column is one of the ones
223: -- we're tracking via our event group. Group by supervisor ID and
224: -- optionally location ID and return the earliest and latest effective
225: -- dates that were affected by the change
226: -- 2984406: Changes for performance

Line 254: AND pdt.table_name = 'PER_ALL_ASSIGNMENTS_F'

250: WHERE INSTR(ppe.description,' -> ') > 0
251: AND SUBSTR(ppe.description,1,6) <> ''
252: AND peu.event_update_id = ppe.event_update_id
253: AND peu.dated_table_id = pdt.dated_table_id
254: AND pdt.table_name = 'PER_ALL_ASSIGNMENTS_F'
255: AND peu.column_name = 'SUPERVISOR_ID'
256: AND pde.update_type = 'C'
257: AND pde.column_name = peu.column_name
258: AND ppe.creation_date BETWEEN cp_st AND cp_en

Line 277: AND pdt.table_name = 'PER_ALL_ASSIGNMENTS_F'

273: WHERE INSTR(ppe.description,' -> ') > 0
274: AND SUBSTR(ppe.description,length(ppe.description)-5) <> ''
275: AND peu.event_update_id = ppe.event_update_id
276: AND peu.dated_table_id = pdt.dated_table_id
277: AND pdt.table_name = 'PER_ALL_ASSIGNMENTS_F'
278: AND peu.column_name = 'SUPERVISOR_ID'
279: AND pde.update_type = 'C'
280: AND pde.column_name = peu.column_name
281: AND ppe.creation_date BETWEEN cp_st AND cp_en

Line 285: per_all_assignments_f paaf

281: AND ppe.creation_date BETWEEN cp_st AND cp_en
282: AND cp_evt = pde.event_group_id
283: AND pde.dated_table_id = pdt.dated_table_id
284: ) sic,
285: per_all_assignments_f paaf
286: -- Join to the assignment at the effective date of the change to get the location
287: WHERE sic.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
288: AND paaf.assignment_id = sic.assignment_id
289: GROUP BY

Line 1087: per_all_assignments_f paf,

1083: --
1084: select /*+ ordered */ distinct pee.element_entry_id
1085: into l_dummy
1086: from pay_element_entries_f pee,
1087: per_all_assignments_f paf,
1088: per_pay_bases ppb,
1089: pay_element_entry_values_f peev
1090: where pee.element_entry_id = p_ee_id
1091: and pee.assignment_id = paf.assignment_id

Line 1432: -- Add any date track corrections to supervisor ID on per_all_assignments_f

1428: p_end_date));
1429: --
1430: END add_summary_refresh_record;
1431: --
1432: -- Add any date track corrections to supervisor ID on per_all_assignments_f
1433: -- if we've got that column in our event group
1434: PROCEDURE add_supervisor_corrections(
1435: p_summary_refresh IN OUT NOCOPY t_summary_refresh_tab_type,
1436: p_start_date IN DATE,