APPS.PQP_GB_TP_TYPE2_FUNCTIONS dependencies on HR_LOCATION_EXTRA_INFO

Line 675: l_location_id hr_location_extra_info.location_id%TYPE;

671: idx NUMBER;
672: idy NUMBER;
673: l_ext_emp_cat_cd VARCHAR2(10);
674: l_effective_start_date DATE;
675: l_location_id hr_location_extra_info.location_id%TYPE;
676: l_asg_emp_cat_cd per_all_assignments_f.employment_category%TYPE;
677: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
678:
679: --

Line 1121: l_location_id hr_location_extra_info.location_id%TYPE;

1117: l_first_time BOOLEAN := TRUE; --Flag to add sec asg details to primary asg
1118: -- if primary is not valid asg.
1119: l_business_group_id NUMBER;
1120: l_asg_cat_cd VARCHAR2(10);
1121: l_location_id hr_location_extra_info.location_id%TYPE;
1122: l_ext_emp_cat_cd VARCHAR2(10);
1123:
1124: --
1125: Begin