APPS.GHR_ELT_TO_BEN_PKG dependencies on PER_ASSIGNMENTS_F

Line 655: FROM per_assignments_f paf, per_people_f ppf

651:
652: --Bug # 9329643 added employee number
653: Cursor cur_ssn is
654: SELECT ppf.last_name,ppf.first_name, ppf.middle_names, ppf.employee_number --bug# 10419074
655: FROM per_assignments_f paf, per_people_f ppf
656: WHERE ppf.person_id = paf.person_id
657: AND paf.primary_flag = 'Y'
658: AND paf.assignment_type <> 'B'
659: AND to_date('2013/01/13','YYYY/MM/DD') BETWEEN paf.effective_start_date

Line 677: l_business_group_id per_assignments_f.business_group_id%type;

673: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;
674: l_screen_entry_value_enrol pay_element_entry_values_f.screen_entry_value%type;
675: l_effective_start_date_enrol pay_element_entry_values_f.effective_start_date%type;
676: l_effective_end_date_enrol pay_element_entry_values_f.effective_end_date%type;
677: l_business_group_id per_assignments_f.business_group_id%type;
678: l_update_flag number := 0;
679: l_health_plan_mod number := 0;
680: l_datetrack_update_mode varchar2(25);
681:

Line 2088: l_business_group_id per_assignments_f.business_group_id%type;

2084: l_elmnt_effective_end_date pay_element_entries_f.effective_end_date%type;
2085: l_element_entry_id pay_element_entries_f.element_entry_id%type;
2086: l_object_version_number pay_element_entries_f.object_version_number%type;
2087: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;
2088: l_business_group_id per_assignments_f.business_group_id%type;
2089: l_update_flag number := 0;
2090: l_cotrib_update_flag number := 0;
2091: l_elig_date_flag number := 0;
2092: l_datetrack_update_mode varchar2(25);