APPS.GHR_MRE_PKG dependencies on PER_PEOPLE_F

Line 100: per_people_f ppf,

96: paf.organization_id ORGANIZATION_ID,
97: paf.business_group_id BUSINESS_GROUP_ID,
98: punits.name ORGANIZATION_NAME
99: from per_assignments_f paf,
100: per_people_f ppf,
101: per_person_types ppt,
102: per_organization_units punits
103: -- VSM added nvl( .. to the start... clause
104: -- enhancement in SELECTion criteria as org_id can be be null [Masscrit.doc]

Line 140: per_people_f ppf,

136: paf.organization_id ORGANIZATION_ID,
137: paf.business_group_id BUSINESS_GROUP_ID,
138: punits.name ORGANIZATION_NAME
139: from per_assignments_f paf,
140: per_people_f ppf,
141: per_person_types ppt,
142: per_organization_units punits
143: WHERE (paf.position_id = nvl(p_org_pos_id,paf.position_id)
144: and

Line 194: FROM per_people_f p, per_assignments_f a

190: pop.position_id = nvl(p_org_pos_id,pop.position_id) and org_pos_fl = 'P')
191: and not exists
192: (
193: SELECT 'X'
194: FROM per_people_f p, per_assignments_f a
195: WHERE trunc(effective_DATE) between a.effective_start_DATE and a.effective_END_DATE
196: AND a.primary_flag = 'Y'
197: AND a.assignment_type <> 'B'
198: AND p.current_employee_flag = 'Y'

Line 237: from per_people_f p, per_assignments_f a

233: between effective_start_DATE and effective_END_DATE
234: and business_group_id = g_business_group_id
235: MINUS
236: SELECT a.position_id
237: from per_people_f p, per_assignments_f a
238: WHERE (a.organization_id = nvl(p_org_pos_id,organization_id) and org_pos_fl = 'O'
239: or
240: a.position_id = nvl(p_org_pos_id,a.position_id) and org_pos_fl = 'P')
241: and trunc(effective_DATE) between a.effective_start_DATE

Line 1296: l_personnel_officer_name per_people_f.full_name%type;

1292: l_position_org_line5 VARCHAR2(40);
1293: l_position_org_line6 VARCHAR2(40);
1294: l_par_object_version_NUMBER NUMBER := l_sf52_rec.object_version_NUMBER;
1295: l_dummy NUMBER;
1296: l_personnel_officer_name per_people_f.full_name%type;
1297: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
1298: BEGIN
1299: ghr_pa_requests_pkg.get_rei_org_lines(
1300: p_pa_request_id => l_sf52_rec.pa_request_id,

Line 2700: l_name per_people_f.full_name%type;

2696: p_first_noa_code in VARCHAR2
2697: )
2698: return BOOLEAN is
2699: --
2700: l_name per_people_f.full_name%type;
2701: -- Bug#3718167 Added l_ssn
2702: l_ssn per_people_f.national_identifier%TYPE;
2703: l_code_action VARCHAR2(65);
2704: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

Line 2702: l_ssn per_people_f.national_identifier%TYPE;

2698: return BOOLEAN is
2699: --
2700: l_name per_people_f.full_name%type;
2701: -- Bug#3718167 Added l_ssn
2702: l_ssn per_people_f.national_identifier%TYPE;
2703: l_code_action VARCHAR2(65);
2704: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
2705: --Bug # 9329643
2706: l_employee_number per_people_f.employee_number%type;

Line 2706: l_employee_number per_people_f.employee_number%type;

2702: l_ssn per_people_f.national_identifier%TYPE;
2703: l_code_action VARCHAR2(65);
2704: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
2705: --Bug # 9329643
2706: l_employee_number per_people_f.employee_number%type;
2707:
2708:
2709: cursor csr_action_taken is
2710: SELECT pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id