[Home] [Help]
261: CURSOR c_gre_id
262: IS
263: SELECT 1
264: FROM per_all_assignments_f asg
265: ,hr_soft_coding_keyflex scl
266: WHERE asg.assignment_id = p_assignment_id
267: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
268: AND scl.segment1 = TO_CHAR(g_gre_id)
269: AND g_end_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
275: CURSOR c_gre_count
276: IS
277: SELECT COUNT(DISTINCT scl.segment1)
278: FROM per_all_assignments_f asg
279: ,hr_soft_coding_keyflex scl
280: WHERE asg.assignment_id = p_assignment_id
281: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
282: AND ( asg.effective_start_date BETWEEN g_start_date AND g_end_date
283: OR
289: CURSOR c_gre_employee
290: IS
291: SELECT 1
292: FROM per_all_assignments_f asg
293: ,hr_soft_coding_keyflex scl
294: WHERE asg.assignment_id = p_assignment_id
295: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
296: AND scl.segment1 = TO_CHAR(g_gre_id)
297: AND (asg.effective_start_date BETWEEN g_start_date AND g_end_date
576: ,fnd_date.date_to_canonical(pep.date_of_birth) dob
577: ,pep.sex gender
578: ,pep.per_information7 residential_status
579: FROM per_all_assignments_f asg
580: ,hr_soft_coding_keyflex scl
581: ,per_all_people_f pep
582: WHERE asg.assignment_id = p_assignment_id
583: AND pep.person_id = asg.person_id
584: AND pep.business_group_id = g_bg_id
2642: SELECT GREATEST(asg.effective_start_date,g_start_date) start_date
2643: ,LEAST(asg.effective_end_date,g_end_date) end_date
2644: ,scl.segment1
2645: FROM per_all_assignments_f asg
2646: ,hr_soft_coding_keyflex scl
2647: ,pay_assignment_actions paa
2648: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2649: AND paa.assignment_action_id = p_assignment_action_id
2650: AND asg.assignment_id = paa.assignment_id