APPS.PER_APR_BUS dependencies on PER_PEOPLE_F

Line 81: p_appraisee_person_id IN per_people_f.person_id%TYPE,

77: -- |----------------------< chk_future_termination_exist >------------------------|
78: -- --------------------------------------------------------------------------+
79:
80: PROCEDURE chk_future_termination_exist (
81: p_appraisee_person_id IN per_people_f.person_id%TYPE,
82: p_appraisal_template_id IN per_appraisals.appraisal_template_id%TYPE
83: )
84: IS
85: --

Line 879: (p_person_id in per_people_f.person_id%TYPE

875: -- Internal Table Handler Use Only.
876:
877:
878: procedure chk_appraisee_appraiser
879: (p_person_id in per_people_f.person_id%TYPE
880: ,p_business_group_id in per_appraisals.business_group_id%TYPE
881: ,p_effective_date in date
882: ,p_person_type in varchar2
883: )

Line 1455: l_asn_grp_pers_sta_date per_people_f.start_date%TYPE;

1451: from per_all_people_f per
1452: where per.person_id = p_group_initiator_id
1453: group by business_group_id;
1454:
1455: l_asn_grp_pers_sta_date per_people_f.start_date%TYPE;
1456: l_asn_grp_pers_bg per_people_f.business_group_id%TYPE;
1457:
1458: lv_cross_business_group VARCHAR2(10); -- bug 1980440 fix
1459: begin

Line 1456: l_asn_grp_pers_bg per_people_f.business_group_id%TYPE;

1452: where per.person_id = p_group_initiator_id
1453: group by business_group_id;
1454:
1455: l_asn_grp_pers_sta_date per_people_f.start_date%TYPE;
1456: l_asn_grp_pers_bg per_people_f.business_group_id%TYPE;
1457:
1458: lv_cross_business_group VARCHAR2(10); -- bug 1980440 fix
1459: begin
1460: hr_utility.set_location('Entering:'|| l_proc, 1);