APPS.PAY_EVENTS_WRAPPER dependencies on PER_ALL_ASSIGNMENTS_F

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

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

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

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

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

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

Line 250: AND pdt.table_name = 'PER_ALL_ASSIGNMENTS_F'

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

Line 273: AND pdt.table_name = 'PER_ALL_ASSIGNMENTS_F'

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

Line 281: per_all_assignments_f paaf

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

Line 1069: per_all_assignments_f paf,

1065: --
1066: select /*+ ordered */ distinct pee.element_entry_id
1067: into l_dummy
1068: from pay_element_entries_f pee,
1069: per_all_assignments_f paf,
1070: per_pay_bases ppb,
1071: pay_element_entry_values_f peev
1072: where pee.element_entry_id = p_ee_id
1073: and pee.assignment_id = paf.assignment_id

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

1410: p_end_date));
1411: --
1412: END add_summary_refresh_record;
1413: --
1414: -- Add any date track corrections to supervisor ID on per_all_assignments_f
1415: -- if we've got that column in our event group
1416: PROCEDURE add_supervisor_corrections(
1417: p_summary_refresh IN OUT NOCOPY t_summary_refresh_tab_type,
1418: p_start_date IN DATE,