APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_PROCESS_EVENTS

Line 121: pay_process_events.

117: gv_variable_idw is 'Y'.
118: sdahiya 17-Apr-2006 115.26 5005254 Archiver should archive
119: termination date instead of a day
120: prior to the date stamped in
121: pay_process_events.
122: sdahiya 19-Apr-2006 115.27 Calculate IDW on
123: LEAST(assignment's end date,
124: process end date)
125: sdahiya 11-May-2006 115.28 5033056 Modified cursor c_person_detail

Line 1124: FROM pay_process_events ppe

1120: ,p_eff_end_date IN DATE ) IS
1121:
1122: CURSOR c_IDW_events IS
1123: SELECT ppe.effective_date
1124: FROM pay_process_events ppe
1125: ,pay_event_updates peu
1126: ,pay_dated_tables pdt
1127: ,pay_element_entry_values_f peev
1128: ,pay_input_values_f piv

Line 1153: FROM pay_process_events ppe

1149: AND pet.effective_end_date
1150: UNION
1151: -- Bug 5002283
1152: SELECT ppe.effective_date
1153: FROM pay_process_events ppe
1154: ,pay_event_updates peu
1155: ,pay_dated_tables pdt
1156: ,pay_element_entries_f pee
1157: ,pay_element_types_f pet

Line 1191: FROM pay_process_events ppe

1187: ,ppe.description change_values
1188: ,ppe.surrogate_key element_entry_id
1189: ,ppe.calculation_date
1190: ,peu.event_type
1191: FROM pay_process_events ppe
1192: ,pay_event_updates peu
1193: ,pay_dated_tables pdt
1194: WHERE ppe.business_group_id = cp_business_group_id
1195: AND ppe.assignment_id = cp_assignment_id

Line 1444: FROM pay_process_events ppe ,

1440:
1441: CURSOR c_first_sal_date IS
1442:
1443: SELECT max(ppe.effective_date)
1444: FROM pay_process_events ppe ,
1445: pay_event_updates peu ,
1446: pay_dated_tables pdt
1447: WHERE ppe.business_group_id = p_business_group_id
1448: AND ppe.assignment_id = p_assignment_id

Line 4086: 'SELECT 1 FROM pay_process_events ppe '||

4082: ,paf.business_group_id
4083: ,paf.soft_coding_keyflex_id
4084: ,ppa.effective_date) = '||ln_gre_id|| ' '||
4085: 'AND (EXISTS ( '||
4086: 'SELECT 1 FROM pay_process_events ppe '||
4087: 'WHERE ppe.assignment_id = paf.assignment_id '||
4088: 'AND ppe.creation_date BETWEEN '||
4089: ' fnd_date.canonical_to_date(''' ||lv_start_date||''') AND'||
4090: ' fnd_date.canonical_to_date('''||lv_end_date||''') )';

Line 4543: FROM pay_process_events

4539: ELSE
4540:
4541: SELECT count(*)
4542: INTO ln_events_found
4543: FROM pay_process_events
4544: WHERE assignment_id = ln_assignment_id
4545: AND last_update_date
4546: BETWEEN fnd_date.canonical_to_date(lv_start_date)
4547: AND fnd_date.canonical_to_date(lv_end_date);