[Home] [Help]
319: CURSOR csr_asg IS
320: SELECT assignment_id,
321: effective_start_date,
322: effective_end_date,
323: per_mx_ssaffl_archive.derive_gre_from_loc_scl(
324: location_id,
325: business_group_id,
326: soft_coding_keyflex_id,
327: effective_end_date) gre_id
2423: FROM per_assignments_f paf
2424: WHERE paf.assignment_id = p_assignment_id
2425: AND cp_effective_date BETWEEN paf.effective_start_date
2426: AND paf.effective_end_date
2427: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
2428: paf.location_id
2429: ,paf.business_group_id
2430: ,paf.soft_coding_keyflex_id
2431: ,cp_effective_date) = p_gre_id;
2445: pst.per_system_status = 'ACTIVE_ASSIGN') OR
2446: (cp_effective_date > paf.effective_start_date AND
2447: cp_tran_type = '08'))
2448: AND paf.assignment_type = 'E'
2449: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
2450: paf.location_id
2451: ,paf.business_group_id
2452: ,paf.soft_coding_keyflex_id
2453: ,cp_effective_date) = p_gre_id
2637: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2638: ln_step := 6;
2639:
2640: ln_old_gre_id :=
2641: per_mx_ssaffl_archive.derive_gre_from_loc_scl(
2642: lv_old_value
2643: ,p_business_group_id
2644: ,ln_asg_scl_old
2645: ,p_asg_events(i).effective_date - 1);
2671:
2672: ln_step := 7;
2673:
2674: ln_new_gre_id :=
2675: per_mx_ssaffl_archive.derive_gre_from_loc_scl(
2676: lv_new_value
2677: ,p_business_group_id
2678: ,ln_asg_scl_new
2679: ,p_asg_events(i).effective_date);
2742: hr_utility.set_location(gv_package||lv_procedure_name,130);
2743: ln_step := 13;
2744:
2745: ln_old_gre_id := NVL(
2746: per_mx_ssaffl_archive.derive_gre_from_loc_scl(
2747: ln_asg_loc_old
2748: ,p_business_group_id
2749: ,lv_old_value
2750: ,p_asg_events(i).effective_date - 1), -9);
2790: hr_utility_trace('Value from the cursor c_get_asg_loc for new loc');
2791: hr_utility_trace('ln_asg_loc_new '||ln_asg_loc_new);
2792: hr_utility_trace('lv_asg_number '||lv_asg_number);
2793: ln_new_gre_id := NVL(
2794: per_mx_ssaffl_archive.derive_gre_from_loc_scl(
2795: ln_asg_loc_new
2796: ,p_business_group_id
2797: ,lv_new_value
2798: ,p_asg_events(i).effective_date), -9);
3268: ,paf.effective_start_date
3269: ,paf.effective_end_date
3270: FROM per_all_assignments_f paf
3271: WHERE paf.assignment_id = cp_assignment_id
3272: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
3273: paf.location_id
3274: ,paf.business_group_id
3275: ,paf.soft_coding_keyflex_id
3276: ,trunc(cp_end_date)) = cp_gre_id
3282: SELECT effective_end_date
3283: FROM per_assignments_f pa
3284: WHERE pa.assignment_id = p_assignment_id
3285: AND pa.effective_end_date = cp_effective_date
3286: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
3287: location_id
3288: ,business_group_id
3289: ,soft_coding_keyflex_id
3290: ,cp_effective_date) = p_gre_id
3600: FROM per_assignments_f paf_in
3601: WHERE paf_in.assignment_id =
3602: paf.assignment_id
3603: -- Bug 5908010
3604: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
3605: paf_in.location_id,
3606: paf_in.business_group_id,
3607: paf_in.soft_coding_keyflex_id,
3608: paf_in.effective_start_date) = p_gre_id);
4058: FROM per_assignments_f paf,
4059: pay_payroll_actions ppa
4060: WHERE ppa.payroll_action_id = :p_payroll_action_id
4061: AND paf.business_group_id = ppa.business_group_id
4062: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4063: paf.location_id
4064: ,paf.business_group_id
4065: ,paf.soft_coding_keyflex_id
4066: ,ppa.effective_date) = '||ln_gre_id|| ' '||
4076: FROM per_assignments_f paf
4077: ,pay_payroll_actions ppa
4078: WHERE ppa.payroll_action_id = :p_payroll_action_id
4079: AND paf.business_group_id = ppa.business_group_id
4080: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4081: paf.location_id
4082: ,paf.business_group_id
4083: ,paf.soft_coding_keyflex_id
4084: ,ppa.effective_date) = '||ln_gre_id|| ' '||
4107: ,pay_assignment_actions paa
4108: ,pay_payroll_actions ppa2
4109: WHERE ppa.payroll_action_id = '|| ln_pactid ||' '||
4110: 'AND paf.business_group_id = ppa.business_group_id
4111: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4112: paf.location_id
4113: ,paf.business_group_id
4114: ,paf.soft_coding_keyflex_id
4115: ,ppa.effective_date) = '||ln_gre_id|| ' '||
4196: AND ppa.business_group_id = cp_business_group_id
4197: AND paf.business_group_id = ppa.business_group_id
4198: AND paf.person_id BETWEEN cp_start_person_id
4199: AND cp_end_person_id
4200: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4201: paf.location_id
4202: ,paf.business_group_id
4203: ,paf.soft_coding_keyflex_id
4204: ,ppa.effective_date) = cp_gre_id
4217: WHERE ppa.payroll_action_id = cp_payroll_action_id
4218: AND paf.business_group_id = ppa.business_group_id
4219: AND paf.person_id BETWEEN cp_start_person_id
4220: AND cp_end_person_id
4221: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4222: paf.location_id
4223: ,paf.business_group_id
4224: ,paf.soft_coding_keyflex_id
4225: ,ppa.effective_date) = cp_gre_id
4280: WHERE ppa.payroll_action_id = cp_payroll_action_id
4281: AND ppr.payroll_action_id = ppa.payroll_action_id
4282: AND ppr.chunk_number = cp_chunk_number
4283: AND paf.person_id = ppr.person_id
4284: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4285: paf.location_id
4286: ,paf.business_group_id
4287: ,paf.soft_coding_keyflex_id
4288: ,ppa.effective_date) = cp_gre_id
4302: WHERE ppa.payroll_action_id = cp_payroll_action_id
4303: AND ppr.payroll_action_id = ppa.payroll_action_id
4304: AND ppr.chunk_number = cp_chunk_number
4305: AND paf.person_id = ppr.person_id
4306: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4307: paf.location_id
4308: ,paf.business_group_id
4309: ,paf.soft_coding_keyflex_id
4310: ,ppa.effective_date) = cp_gre_id