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 PER_MX_SSAFFL_ARCHIVE

Line 359: per_mx_ssaffl_archive.derive_gre_from_loc_scl(

355: CURSOR csr_asg IS
356: SELECT assignment_id,
357: effective_start_date,
358: effective_end_date,
359: per_mx_ssaffl_archive.derive_gre_from_loc_scl(
360: location_id,
361: business_group_id,
362: soft_coding_keyflex_id,
363: effective_end_date) gre_id

Line 2551: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

2547: FROM per_assignments_f paf
2548: WHERE paf.assignment_id = p_assignment_id
2549: AND cp_effective_date BETWEEN paf.effective_start_date
2550: AND paf.effective_end_date
2551: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
2552: paf.location_id
2553: ,paf.business_group_id
2554: ,paf.soft_coding_keyflex_id
2555: ,cp_effective_date) = p_gre_id;

Line 2573: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

2569: pst.per_system_status = 'ACTIVE_ASSIGN') OR
2570: (cp_effective_date > paf.effective_start_date AND
2571: cp_tran_type = '08'))
2572: AND paf.assignment_type = 'E'
2573: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
2574: paf.location_id
2575: ,paf.business_group_id
2576: ,paf.soft_coding_keyflex_id
2577: ,cp_effective_date) = p_gre_id

Line 2787: per_mx_ssaffl_archive.derive_gre_from_loc_scl(

2783: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2784: ln_step := 6;
2785:
2786: ln_old_gre_id :=
2787: per_mx_ssaffl_archive.derive_gre_from_loc_scl(
2788: lv_old_value
2789: ,p_business_group_id
2790: ,ln_asg_scl_old
2791: ,p_asg_events(i).effective_date - 1);

Line 2821: per_mx_ssaffl_archive.derive_gre_from_loc_scl(

2817:
2818: ln_step := 7;
2819:
2820: ln_new_gre_id :=
2821: per_mx_ssaffl_archive.derive_gre_from_loc_scl(
2822: lv_new_value
2823: ,p_business_group_id
2824: ,ln_asg_scl_new
2825: ,p_asg_events(i).effective_date);

Line 2892: per_mx_ssaffl_archive.derive_gre_from_loc_scl(

2888: hr_utility.set_location(gv_package||lv_procedure_name,130);
2889: ln_step := 13;
2890:
2891: ln_old_gre_id := NVL(
2892: per_mx_ssaffl_archive.derive_gre_from_loc_scl(
2893: ln_asg_loc_old
2894: ,p_business_group_id
2895: ,lv_old_value
2896: ,p_asg_events(i).effective_date - 1), -9);

Line 2940: per_mx_ssaffl_archive.derive_gre_from_loc_scl(

2936: hr_utility_trace('Value from the cursor c_get_asg_loc for new loc');
2937: hr_utility_trace('ln_asg_loc_new '||ln_asg_loc_new);
2938: hr_utility_trace('lv_asg_number '||lv_asg_number);
2939: ln_new_gre_id := NVL(
2940: per_mx_ssaffl_archive.derive_gre_from_loc_scl(
2941: ln_asg_loc_new
2942: ,p_business_group_id
2943: ,lv_new_value
2944: ,p_asg_events(i).effective_date), -9);

Line 3474: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

3470: ,paf.effective_start_date
3471: ,paf.effective_end_date
3472: FROM per_all_assignments_f paf
3473: WHERE paf.assignment_id = cp_assignment_id
3474: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
3475: paf.location_id
3476: ,paf.business_group_id
3477: ,paf.soft_coding_keyflex_id
3478: ,trunc(cp_end_date)) = cp_gre_id

Line 3488: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

3484: SELECT effective_end_date
3485: FROM per_assignments_f pa
3486: WHERE pa.assignment_id = p_assignment_id
3487: AND pa.effective_end_date = cp_effective_date
3488: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
3489: location_id
3490: ,business_group_id
3491: ,soft_coding_keyflex_id
3492: ,cp_effective_date) = p_gre_id

Line 3817: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

3813: FROM per_assignments_f paf_in
3814: WHERE paf_in.assignment_id =
3815: paf.assignment_id
3816: -- Bug 5908010
3817: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
3818: paf_in.location_id,
3819: paf_in.business_group_id,
3820: paf_in.soft_coding_keyflex_id,
3821: paf_in.effective_start_date) = p_gre_id);

Line 4451: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

4447: FROM per_assignments_f paf,
4448: pay_payroll_actions ppa
4449: WHERE ppa.payroll_action_id = :p_payroll_action_id
4450: AND paf.business_group_id = ppa.business_group_id
4451: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4452: paf.location_id
4453: ,paf.business_group_id
4454: ,paf.soft_coding_keyflex_id
4455: ,ppa.effective_date) = '||ln_gre_id|| ' '||

Line 4470: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

4466: FROM per_assignments_f paf
4467: ,pay_payroll_actions ppa
4468: WHERE ppa.payroll_action_id = :p_payroll_action_id
4469: AND paf.business_group_id = ppa.business_group_id
4470: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4471: paf.location_id
4472: ,paf.business_group_id
4473: ,paf.soft_coding_keyflex_id
4474: ,ppa.effective_date) = '||ln_gre_id|| ') '||

Line 4531: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

4527: AND ppa.business_group_id = cp_business_group_id
4528: AND paf.business_group_id = ppa.business_group_id
4529: AND paf.person_id BETWEEN cp_start_person_id
4530: AND cp_end_person_id
4531: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4532: paf.location_id
4533: ,paf.business_group_id
4534: ,paf.soft_coding_keyflex_id
4535: ,ppa.effective_date) = cp_gre_id

Line 4552: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

4548: WHERE ppa.payroll_action_id = cp_payroll_action_id
4549: AND paf.business_group_id = ppa.business_group_id
4550: AND paf.person_id BETWEEN cp_start_person_id
4551: AND cp_end_person_id
4552: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4553: paf.location_id
4554: ,paf.business_group_id
4555: ,paf.soft_coding_keyflex_id
4556: ,ppa.effective_date) = cp_gre_id

Line 4615: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

4611: WHERE ppa.payroll_action_id = cp_payroll_action_id
4612: AND ppr.payroll_action_id = ppa.payroll_action_id
4613: AND ppr.chunk_number = cp_chunk_number
4614: AND paf.person_id = ppr.person_id
4615: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4616: paf.location_id
4617: ,paf.business_group_id
4618: ,paf.soft_coding_keyflex_id
4619: ,ppa.effective_date) = cp_gre_id

Line 4637: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

4633: WHERE ppa.payroll_action_id = cp_payroll_action_id
4634: AND ppr.payroll_action_id = ppa.payroll_action_id
4635: AND ppr.chunk_number = cp_chunk_number
4636: AND paf.person_id = ppr.person_id
4637: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4638: paf.location_id
4639: ,paf.business_group_id
4640: ,paf.soft_coding_keyflex_id
4641: ,ppa.effective_date) = cp_gre_id

Line 4700: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

4696: AND ppa.business_group_id = cp_business_group_id
4697: AND paf.business_group_id = ppa.business_group_id
4698: AND paf.person_id BETWEEN cp_start_person_id
4699: AND cp_end_person_id
4700: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4701: paf.location_id
4702: ,paf.business_group_id
4703: ,paf.soft_coding_keyflex_id
4704: ,ppa.effective_date) = cp_gre_id

Line 4728: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

4724: AND paf.business_group_id = ppa.business_group_id
4725: AND paf.person_id BETWEEN cp_start_person_id
4726: AND cp_end_person_id
4727: AND gv_mode = 'P'
4728: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4729: paf.location_id
4730: ,paf.business_group_id
4731: ,paf.soft_coding_keyflex_id
4732: ,ppa.effective_date) = cp_gre_id

Line 4766: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

4762: WHERE ppa.payroll_action_id = cp_payroll_action_id
4763: AND ppr.payroll_action_id = ppa.payroll_action_id
4764: AND ppr.chunk_number = cp_chunk_number
4765: AND paf.person_id = ppr.person_id
4766: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4767: paf.location_id
4768: ,paf.business_group_id
4769: ,paf.soft_coding_keyflex_id
4770: ,ppa.effective_date) = cp_gre_id

Line 4795: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

4791: AND ppr.payroll_action_id = ppa.payroll_action_id
4792: AND ppr.chunk_number = cp_chunk_number
4793: AND paf.person_id = ppr.person_id
4794: AND gv_mode = 'P'
4795: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4796: paf.location_id
4797: ,paf.business_group_id
4798: ,paf.soft_coding_keyflex_id
4799: ,ppa.effective_date) = cp_gre_id