eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_MLC_PKG dependencies on PER_PEOPLE_F

Line 21: -- Main Cursor which fetches from per_assignments_f and per_people_f

17: p_mass_salary varchar2(32);
18: l_p_locality_area_code ghr_mass_salaries.locality_pay_area_code%type;
19:
20: --
21: -- Main Cursor which fetches from per_assignments_f and per_people_f
22: --
23: -- Bug 4377361 included EMP_APL for person type condition
24:
25: cursor cur_people (effective_date date, p_org_id number) is

Line 41: per_people_f ppf,

37: paf.location_id LOCATION_ID,
38: paf.organization_id ORGANIZATION_ID,
39: paf.business_group_id BUSINESS_GROUP_ID
40: from per_assignments_f paf,
41: per_people_f ppf,
42: per_person_types ppt,
43: per_assignment_status_types pas_t,
44: hr_location_extra_info hlei,
45: ghr_duty_stations_f gdsf,

Line 1111: -- Main Cursor which fetches from per_assignments_f and per_people_f

1107: p_action IN varchar2) is
1108:
1109: p_mass_salary varchar2(32);
1110: --
1111: -- Main Cursor which fetches from per_assignments_f and per_people_f
1112: --
1113: -- 1. Cursor with organization.
1114: --
1115: cursor cur_people_org (effective_date date, p_org_id number) is

Line 1132: per_people_f ppf,

1128: paf.organization_id ORGANIZATION_ID,
1129: paf.business_group_id BUSINESS_GROUP_ID,
1130: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
1131: from per_assignments_f paf,
1132: per_people_f ppf,
1133: per_person_types ppt
1134: where ppf.person_id = paf.person_id
1135: and effective_date between ppf.effective_start_date and ppf.effective_end_date
1136: and effective_date between paf.effective_start_date and paf.effective_end_date

Line 1166: per_people_f ppf,

1162: paf.organization_id ORGANIZATION_ID,
1163: paf.business_group_id BUSINESS_GROUP_ID,
1164: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
1165: from per_assignments_f paf,
1166: per_people_f ppf,
1167: per_person_types ppt
1168: where ppf.person_id = paf.person_id
1169: and effective_date between ppf.effective_start_date and ppf.effective_end_date
1170: and effective_date between paf.effective_start_date and paf.effective_end_date

Line 1249: FROM per_people_f p, per_assignments_f a

1245: and pop.organization_id = nvl(p_org_pos_id,pop.organization_id)
1246: and not exists
1247: (
1248: SELECT 'X'
1249: FROM per_people_f p, per_assignments_f a
1250: WHERE trunc(effective_DATE) between a.effective_start_DATE and a.effective_END_DATE
1251: AND a.primary_flag = 'Y'
1252: AND a.assignment_type <> 'B'
1253: AND p.current_employee_flag = 'Y'

Line 1478: ,p_first_name per_people_f.first_name%TYPE

1474: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
1475: ,p_location_id per_assignments_f.location_id%TYPE
1476: ,p_organization_id per_assignments_f.organization_id%TYPE
1477: ,p_date_of_birth date
1478: ,p_first_name per_people_f.first_name%TYPE
1479: ,p_last_name per_people_f.last_name%TYPE
1480: ,p_full_name per_people_f.full_name%TYPE
1481: ,p_middle_names per_people_f.middle_names%TYPE
1482: ,p_national_identifier per_people_f.national_identifier%TYPE

Line 1479: ,p_last_name per_people_f.last_name%TYPE

1475: ,p_location_id per_assignments_f.location_id%TYPE
1476: ,p_organization_id per_assignments_f.organization_id%TYPE
1477: ,p_date_of_birth date
1478: ,p_first_name per_people_f.first_name%TYPE
1479: ,p_last_name per_people_f.last_name%TYPE
1480: ,p_full_name per_people_f.full_name%TYPE
1481: ,p_middle_names per_people_f.middle_names%TYPE
1482: ,p_national_identifier per_people_f.national_identifier%TYPE
1483: ) IS

Line 1480: ,p_full_name per_people_f.full_name%TYPE

1476: ,p_organization_id per_assignments_f.organization_id%TYPE
1477: ,p_date_of_birth date
1478: ,p_first_name per_people_f.first_name%TYPE
1479: ,p_last_name per_people_f.last_name%TYPE
1480: ,p_full_name per_people_f.full_name%TYPE
1481: ,p_middle_names per_people_f.middle_names%TYPE
1482: ,p_national_identifier per_people_f.national_identifier%TYPE
1483: ) IS
1484:

Line 1481: ,p_middle_names per_people_f.middle_names%TYPE

1477: ,p_date_of_birth date
1478: ,p_first_name per_people_f.first_name%TYPE
1479: ,p_last_name per_people_f.last_name%TYPE
1480: ,p_full_name per_people_f.full_name%TYPE
1481: ,p_middle_names per_people_f.middle_names%TYPE
1482: ,p_national_identifier per_people_f.national_identifier%TYPE
1483: ) IS
1484:
1485: BEGIN

Line 1482: ,p_national_identifier per_people_f.national_identifier%TYPE

1478: ,p_first_name per_people_f.first_name%TYPE
1479: ,p_last_name per_people_f.last_name%TYPE
1480: ,p_full_name per_people_f.full_name%TYPE
1481: ,p_middle_names per_people_f.middle_names%TYPE
1482: ,p_national_identifier per_people_f.national_identifier%TYPE
1483: ) IS
1484:
1485: BEGIN
1486: savepoint execute_msl_pay_sp;

Line 3520: l_name per_people_f.full_name%type;

3516: p_days in number default 350
3517: )
3518: return boolean is
3519: --
3520: l_name per_people_f.full_name%type;
3521: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3522:
3523: cursor csr_action_taken is
3524: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id

Line 3696: l_name per_people_f.full_name%type;

3692: p_days in number default 350
3693: )
3694: return boolean is
3695: --
3696: l_name per_people_f.full_name%type;
3697: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3698:
3699: cursor csr_action_taken is
3700: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id