[Home] [Help]
88: c_end_person_id in per_all_people_f.person_id%type) is
89: select distinct a.assignment_id,
90: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
91: ppac.assignment_action_id
92: from per_assignments_f a,
93: per_people_f p,
94: pay_payroll_actions pa,
95: pay_payroll_actions ppa,
96: pay_assignment_actions ppac
152: SELECT DISTINCT a.assignment_id
153: ,pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id
154: ,ppac.assignment_action_id
155: ,pmaa.assignment_action_id datafile_action_id
156: FROM per_assignments_f a
157: ,per_people_f p
158: ,pay_payroll_actions pa
159: ,pay_payroll_actions ppa
160: ,pay_assignment_actions ppac
562: ---
563: -- Bug 4726357 Added to check whether Self Service Option is enabled for the employee
564: ---
565:
566: function ss_pref(p_assignemnt_id per_assignments_f.assignment_id%type) return varchar2
567: is
568:
569: l_bg_id number;
570: l_loc_id number;
574:
575: /* Cursor to get the business group id, location id, organization id and person id */
576: cursor asg_info is
577: select paf.business_group_id, paf.location_id, paf.organization_id,paf.person_id
578: from per_assignments_f paf
579: where paf.assignment_id = p_assignemnt_id
580: and paf.effective_start_date =
581: (select max(effective_start_date)
582: from per_assignments_f paf2
578: from per_assignments_f paf
579: where paf.assignment_id = p_assignemnt_id
580: and paf.effective_start_date =
581: (select max(effective_start_date)
582: from per_assignments_f paf2
583: where paf2.assignment_id = paf.assignment_id
584: );
585:
586: /* Cursor to get the option sets at different level i.e Person level, Location Level, Organization Level and