APPS.PAY_US_DEF_COMP_457 dependencies on PER_PEOPLE_F

Line 46: l_full_name per_people_f.full_name%TYPE;

42: p_person_id IN NUMBER ,
43: p_gre_id IN NUMBER )
44: IS
45: l_proc VARCHAR2(72) := g_package || 'Business_Rule_Proc';
46: l_full_name per_people_f.full_name%TYPE;
47: l_person_id NUMBER;
48: l_business_group_id NUMBER;
49: l_max_contr_allowed NUMBER;
50: l_amt_contr NUMBER;

Line 147: FROM per_people_f ppf,

143: EXIT WHEN Business_Rule_Proc_cur%NOTFOUND;
144: -- EE
145: SELECT full_name
146: INTO l_full_name
147: FROM per_people_f ppf,
148: per_person_types ppt
149: WHERE ppf.person_id = l_person_id
150: AND ppf.effective_start_date =
151: (SELECT MAX(a.effective_start_date)

Line 152: FROM per_people_f a,

148: per_person_types ppt
149: WHERE ppf.person_id = l_person_id
150: AND ppf.effective_start_date =
151: (SELECT MAX(a.effective_start_date)
152: FROM per_people_f a,
153: per_person_types b
154: WHERE TO_NUMBER(TO_CHAR(a.effective_start_date,'YYYY'))
155: <= p_year
156: AND TO_NUMBER(TO_CHAR(a.effective_end_date,'YYYY'))