DBA Data[Home] [Help]

APPS.PQP_GB_TP_TYPE2_FUNCTIONS dependencies on PER_ALL_PEOPLE_F

Line 1117: l_person_id per_all_people_f.person_id%TYPE;

1113: --
1114: l_inclusion_flag varchar2(20) := 'N';
1115: l_sec_assignments pqp_gb_t1_pension_extracts.t_sec_asgs_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;