APPS.PER_APR_BUS dependencies on PER_PEOPLE_F

Line 763: (p_person_id in per_people_f.person_id%TYPE

759: -- Internal Table Handler Use Only.
760:
761:
762: procedure chk_appraisee_appraiser
763: (p_person_id in per_people_f.person_id%TYPE
764: ,p_business_group_id in per_appraisals.business_group_id%TYPE
765: ,p_effective_date in date
766: ,p_person_type in varchar2
767: )

Line 1333: l_asn_grp_pers_sta_date per_people_f.start_date%TYPE;

1329: from per_all_people_f per
1330: where per.person_id = p_group_initiator_id
1331: group by business_group_id;
1332:
1333: l_asn_grp_pers_sta_date per_people_f.start_date%TYPE;
1334: l_asn_grp_pers_bg per_people_f.business_group_id%TYPE;
1335:
1336: lv_cross_business_group VARCHAR2(10); -- bug 1980440 fix
1337: begin

Line 1334: l_asn_grp_pers_bg per_people_f.business_group_id%TYPE;

1330: where per.person_id = p_group_initiator_id
1331: group by business_group_id;
1332:
1333: l_asn_grp_pers_sta_date per_people_f.start_date%TYPE;
1334: l_asn_grp_pers_bg per_people_f.business_group_id%TYPE;
1335:
1336: lv_cross_business_group VARCHAR2(10); -- bug 1980440 fix
1337: begin
1338: hr_utility.set_location('Entering:'|| l_proc, 1);