APPS.GHR_ELT_TO_BEN_PKG dependencies on PER_ASSIGNMENTS_F

Line 635: select business_group_id from per_assignments_f

631: l_req VARCHAR2 (25);
632: l_ssn per_all_people_f.national_identifier%TYPE;
633: l_program_name ghr_process_log.program_name%TYPE;
634: cursor cur_business_group is
635: select business_group_id from per_assignments_f
636: where assignment_id = l_assignment_id;
637:
638: Cursor cur_ssn is
639: SELECT ppf.national_identifier

Line 640: FROM per_assignments_f paf, per_people_f ppf

636: where assignment_id = l_assignment_id;
637:
638: Cursor cur_ssn is
639: SELECT ppf.national_identifier
640: FROM per_assignments_f paf, per_people_f ppf
641: WHERE ppf.person_id = paf.person_id
642: AND paf.primary_flag = 'Y'
643: AND paf.assignment_type <> 'B'
644: AND to_date('2009/01/04','YYYY/MM/DD') BETWEEN paf.effective_start_date

Line 662: l_business_group_id per_assignments_f.business_group_id%type;

658: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;
659: l_screen_entry_value_enrol pay_element_entry_values_f.screen_entry_value%type;
660: l_effective_start_date_enrol pay_element_entry_values_f.effective_start_date%type;
661: l_effective_end_date_enrol pay_element_entry_values_f.effective_end_date%type;
662: l_business_group_id per_assignments_f.business_group_id%type;
663: l_update_flag number := 0;
664: l_health_plan_mod number := 0;
665: l_datetrack_update_mode varchar2(25);
666: