DBA Data[Home] [Help]

APPS.PQP_GB_TP_TYPE2_FUNCTIONS dependencies on PER_ALL_PEOPLE_F

Line 1111: l_person_id per_all_people_f.person_id%TYPE;

1107: --
1108: l_inclusion_flag varchar2(20) := 'N';
1109: l_sec_assignments pqp_gb_t1_pension_extracts.t_sec_asgs_type;
1110: l_is_a_teacher varchar2(1) := 'Y';
1111: l_person_id per_all_people_f.person_id%TYPE;
1112: l_start_date DATE;
1113: l_proc_name varchar2(61) := g_proc_name || 'chk_teacher_qual_for_tp2';
1114: l_curr_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
1115: l_prev_sec_asg_id per_all_assignments_f.assignment_id%TYPE;