eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1199: FROM pay_process_events ppe

1195: ,p_exc_end_date IN VARCHAR2) IS
1196:
1197: CURSOR c_IDW_events IS
1198: SELECT ppe.effective_date
1199: FROM pay_process_events ppe
1200: ,pay_event_updates peu
1201: ,pay_dated_tables pdt
1202: ,pay_element_entry_values_f peev
1203: ,pay_input_values_f piv

Line 1228: FROM pay_process_events ppe

1224: AND pet.effective_end_date
1225: UNION
1226: -- Bug 5002283
1227: SELECT ppe.effective_date
1228: FROM pay_process_events ppe
1229: ,pay_event_updates peu
1230: ,pay_dated_tables pdt
1231: ,pay_element_entries_f pee
1232: ,pay_element_types_f pet

Line 1266: FROM pay_process_events ppe

1262: ,ppe.description change_values
1263: ,ppe.surrogate_key element_entry_id
1264: ,ppe.calculation_date
1265: ,peu.event_type
1266: FROM pay_process_events ppe
1267: ,pay_event_updates peu
1268: ,pay_dated_tables pdt
1269: WHERE ppe.business_group_id = cp_business_group_id
1270: AND ppe.assignment_id = cp_assignment_id

Line 1529: FROM pay_process_events ppe ,

1525:
1526: CURSOR c_first_sal_date IS
1527:
1528: SELECT max(ppe.effective_date)
1529: FROM pay_process_events ppe ,
1530: pay_event_updates peu ,
1531: pay_dated_tables pdt
1532: WHERE ppe.business_group_id = p_business_group_id
1533: AND ppe.assignment_id = p_assignment_id

Line 4228: CURSOR c_chk_pay_process_events IS

4224: lv_procedure_name VARCHAR2(100);
4225: ln_step NUMBER;
4226: lv_error_message VARCHAR2(2000);
4227:
4228: CURSOR c_chk_pay_process_events IS
4229: SELECT 'Y'
4230: FROM pay_process_events ppe
4231: WHERE ppe.assignment_id = p_assignment_id
4232: AND ppe.creation_date BETWEEN p_start_date AND p_end_date

Line 4230: FROM pay_process_events ppe

4226: lv_error_message VARCHAR2(2000);
4227:
4228: CURSOR c_chk_pay_process_events IS
4229: SELECT 'Y'
4230: FROM pay_process_events ppe
4231: WHERE ppe.assignment_id = p_assignment_id
4232: AND ppe.creation_date BETWEEN p_start_date AND p_end_date
4233: AND rownum = 1;
4234:

Line 4288: OPEN c_chk_pay_process_events;

4284: ln_step := 1;
4285: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4286:
4287: IF (p_vidw_check = 'N') THEN
4288: OPEN c_chk_pay_process_events;
4289: FETCH c_chk_pay_process_events INTO lv_exists;
4290: IF c_chk_pay_process_events%FOUND THEN
4291: CLOSE c_chk_pay_process_events;
4292: RETURN lv_exists;

Line 4289: FETCH c_chk_pay_process_events INTO lv_exists;

4285: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4286:
4287: IF (p_vidw_check = 'N') THEN
4288: OPEN c_chk_pay_process_events;
4289: FETCH c_chk_pay_process_events INTO lv_exists;
4290: IF c_chk_pay_process_events%FOUND THEN
4291: CLOSE c_chk_pay_process_events;
4292: RETURN lv_exists;
4293: END IF;

Line 4290: IF c_chk_pay_process_events%FOUND THEN

4286:
4287: IF (p_vidw_check = 'N') THEN
4288: OPEN c_chk_pay_process_events;
4289: FETCH c_chk_pay_process_events INTO lv_exists;
4290: IF c_chk_pay_process_events%FOUND THEN
4291: CLOSE c_chk_pay_process_events;
4292: RETURN lv_exists;
4293: END IF;
4294: CLOSE c_chk_pay_process_events;

Line 4291: CLOSE c_chk_pay_process_events;

4287: IF (p_vidw_check = 'N') THEN
4288: OPEN c_chk_pay_process_events;
4289: FETCH c_chk_pay_process_events INTO lv_exists;
4290: IF c_chk_pay_process_events%FOUND THEN
4291: CLOSE c_chk_pay_process_events;
4292: RETURN lv_exists;
4293: END IF;
4294: CLOSE c_chk_pay_process_events;
4295: hr_utility.set_location(gv_package || lv_procedure_name, 20);

Line 4294: CLOSE c_chk_pay_process_events;

4290: IF c_chk_pay_process_events%FOUND THEN
4291: CLOSE c_chk_pay_process_events;
4292: RETURN lv_exists;
4293: END IF;
4294: CLOSE c_chk_pay_process_events;
4295: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4296:
4297: IF gv_IDW_calc_method = 'B' THEN
4298: lv_exists := pay_mx_soc_sec_archive.seniority_changed (p_person_id,

Line 5010: FROM pay_process_events

5006: ELSE
5007:
5008: SELECT count(*)
5009: INTO ln_events_found
5010: FROM pay_process_events
5011: WHERE assignment_id = ln_assignment_id
5012: AND last_update_date
5013: BETWEEN fnd_date.canonical_to_date(lv_start_date)
5014: AND fnd_date.canonical_to_date(lv_end_date);