APPS.PQP_GB_TP_TYPE2_FUNCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 125: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

121: )
122: IS
123:
124: l_extract_attributes pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes%ROWTYPE;
125: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
126:
127: BEGIN
128:
129: debug(':g_nested_level:'||g_nested_level,000);

Line 676: l_asg_emp_cat_cd per_all_assignments_f.employment_category%TYPE;

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: --
680: Begin

Line 677: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

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: --
680: Begin
681:

Line 1120: l_curr_sec_asg_id per_all_assignments_f.assignment_id%TYPE;

1116: l_is_a_teacher varchar2(1) := 'Y';
1117: l_person_id per_all_people_f.person_id%TYPE;
1118: l_start_date DATE;
1119: l_proc_name varchar2(61) := g_proc_name || 'chk_teacher_qual_for_tp2';
1120: l_curr_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
1121: l_prev_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
1122: idx NUMBER;
1123: l_first_time BOOLEAN := TRUE; --Flag to add sec asg details to primary asg
1124: -- if primary is not valid asg.

Line 1121: l_prev_sec_asg_id per_all_assignments_f.assignment_id%TYPE;

1117: l_person_id per_all_people_f.person_id%TYPE;
1118: l_start_date DATE;
1119: l_proc_name varchar2(61) := g_proc_name || 'chk_teacher_qual_for_tp2';
1120: l_curr_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
1121: l_prev_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
1122: idx NUMBER;
1123: l_first_time BOOLEAN := TRUE; --Flag to add sec asg details to primary asg
1124: -- if primary is not valid asg.
1125: l_business_group_id NUMBER;