APPS.GHR_MASS_AWARDS_PKG dependencies on PER_PEOPLE_F

Line 67: from per_people_f ppf

63: -- Cursor to derive business group from person based on person_id.
64: -- -------------------------------------------------------------------------
65: cursor c_business_group is
66: select ppf.business_group_id
67: from per_people_f ppf
68: where ppf.person_id = p_person_id
69: and trunc(p_effective_date)
70: between nvl(trunc(ppf.effective_start_date),trunc(sysdate))
71: and nvl(trunc(ppf.effective_end_date),trunc(sysdate-1));

Line 115: p_person_id in per_people_f.person_id%TYPE,

111: --Bug#3804067 Added new parameter p_mass_action_comments
112: PROCEDURE get_pa_request_id_ovn (
113: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
114: p_effective_date in date,
115: p_person_id in per_people_f.person_id%TYPE,
116: p_pa_request_id out nocopy ghr_pa_requests.pa_request_id%TYPE,
117: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
118: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
119: p_mass_action_sel_flag out nocopy ghr_pa_requests.mass_action_select_flag%TYPE,

Line 704: p_person_id in per_people_f.person_id%TYPE,

700: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
701: p_action_type in VARCHAR2,
702: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
703: p_effective_date in date,
704: p_person_id in per_people_f.person_id%TYPE,
705: p_pa_request_rec in out nocopy ghr_pa_requests%rowtype ,
706: p_log_text out nocopy varchar2,
707: p_maxcheck out nocopy number
708: )

Line 1609: p_person_id in per_people_f.person_id%TYPE,

1605: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
1606: p_action_type in VARCHAR2,
1607: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
1608: p_effective_date in date,
1609: p_person_id in per_people_f.person_id%TYPE,
1610: p_assignment_id in per_assignments_f.assignment_id%TYPE,
1611: p_position_id in hr_positions_f.position_id%TYPE,
1612: p_grade_id in number,
1613: p_location_id in hr_locations.location_id%TYPE,

Line 1630: l_personnel_officer_name per_people_f.full_name%type;

1626: l_business_group_id number;
1627:
1628: l_pa_request_rec ghr_pa_requests%rowtype;
1629:
1630: l_personnel_officer_name per_people_f.full_name%type;
1631: l_approval_date date;
1632: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
1633: l_1_approval_status varchar2(10);
1634:

Line 2713: p_person_id in per_people_f.person_id%TYPE,

2709: (
2710: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
2711: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
2712: p_effective_date in date,
2713: p_person_id in per_people_f.person_id%TYPE,
2714: p_pa_request_id in ghr_pa_requests.pa_request_id%type
2715: )
2716:
2717: IS