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 43: per_people_f ppf,

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

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

1127: p_action IN varchar2) is
1128:
1129: p_mass_salary varchar2(32);
1130: --
1131: -- Main Cursor which fetches from per_assignments_f and per_people_f
1132: --
1133: -- 1. Cursor with organization.
1134: --
1135: cursor cur_people_org (effective_date date, p_org_id number) is

Line 1154: per_people_f ppf,

1150: paf.organization_id ORGANIZATION_ID,
1151: paf.business_group_id BUSINESS_GROUP_ID,
1152: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
1153: from per_assignments_f paf,
1154: per_people_f ppf,
1155: per_person_types ppt
1156: where ppf.person_id = paf.person_id
1157: and effective_date between ppf.effective_start_date and ppf.effective_end_date
1158: and effective_date between paf.effective_start_date and paf.effective_end_date

Line 1190: per_people_f ppf,

1186: paf.organization_id ORGANIZATION_ID,
1187: paf.business_group_id BUSINESS_GROUP_ID,
1188: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
1189: from per_assignments_f paf,
1190: per_people_f ppf,
1191: per_person_types ppt
1192: where ppf.person_id = paf.person_id
1193: and effective_date between ppf.effective_start_date and ppf.effective_end_date
1194: and effective_date between paf.effective_start_date and paf.effective_end_date

Line 1275: FROM per_people_f p, per_assignments_f a

1271: and pop.organization_id = nvl(p_org_pos_id,pop.organization_id)
1272: and not exists
1273: (
1274: SELECT 'X'
1275: FROM per_people_f p, per_assignments_f a
1276: WHERE trunc(effective_DATE) between a.effective_start_DATE and a.effective_END_DATE
1277: AND a.primary_flag = 'Y'
1278: AND a.assignment_type <> 'B'
1279: AND p.current_employee_flag = 'Y'

Line 1504: ,p_first_name per_people_f.first_name%TYPE

1500: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
1501: ,p_location_id per_assignments_f.location_id%TYPE
1502: ,p_organization_id per_assignments_f.organization_id%TYPE
1503: ,p_date_of_birth date
1504: ,p_first_name per_people_f.first_name%TYPE
1505: ,p_last_name per_people_f.last_name%TYPE
1506: ,p_full_name per_people_f.full_name%TYPE
1507: ,p_middle_names per_people_f.middle_names%TYPE
1508: ,p_national_identifier per_people_f.national_identifier%TYPE

Line 1505: ,p_last_name per_people_f.last_name%TYPE

1501: ,p_location_id per_assignments_f.location_id%TYPE
1502: ,p_organization_id per_assignments_f.organization_id%TYPE
1503: ,p_date_of_birth date
1504: ,p_first_name per_people_f.first_name%TYPE
1505: ,p_last_name per_people_f.last_name%TYPE
1506: ,p_full_name per_people_f.full_name%TYPE
1507: ,p_middle_names per_people_f.middle_names%TYPE
1508: ,p_national_identifier per_people_f.national_identifier%TYPE
1509: --Bug # 9329643

Line 1506: ,p_full_name per_people_f.full_name%TYPE

1502: ,p_organization_id per_assignments_f.organization_id%TYPE
1503: ,p_date_of_birth date
1504: ,p_first_name per_people_f.first_name%TYPE
1505: ,p_last_name per_people_f.last_name%TYPE
1506: ,p_full_name per_people_f.full_name%TYPE
1507: ,p_middle_names per_people_f.middle_names%TYPE
1508: ,p_national_identifier per_people_f.national_identifier%TYPE
1509: --Bug # 9329643
1510: ,p_employee_number per_people_f.employee_number%TYPE

Line 1507: ,p_middle_names per_people_f.middle_names%TYPE

1503: ,p_date_of_birth date
1504: ,p_first_name per_people_f.first_name%TYPE
1505: ,p_last_name per_people_f.last_name%TYPE
1506: ,p_full_name per_people_f.full_name%TYPE
1507: ,p_middle_names per_people_f.middle_names%TYPE
1508: ,p_national_identifier per_people_f.national_identifier%TYPE
1509: --Bug # 9329643
1510: ,p_employee_number per_people_f.employee_number%TYPE
1511: ) IS

Line 1508: ,p_national_identifier per_people_f.national_identifier%TYPE

1504: ,p_first_name per_people_f.first_name%TYPE
1505: ,p_last_name per_people_f.last_name%TYPE
1506: ,p_full_name per_people_f.full_name%TYPE
1507: ,p_middle_names per_people_f.middle_names%TYPE
1508: ,p_national_identifier per_people_f.national_identifier%TYPE
1509: --Bug # 9329643
1510: ,p_employee_number per_people_f.employee_number%TYPE
1511: ) IS
1512:

Line 1510: ,p_employee_number per_people_f.employee_number%TYPE

1506: ,p_full_name per_people_f.full_name%TYPE
1507: ,p_middle_names per_people_f.middle_names%TYPE
1508: ,p_national_identifier per_people_f.national_identifier%TYPE
1509: --Bug # 9329643
1510: ,p_employee_number per_people_f.employee_number%TYPE
1511: ) IS
1512:
1513: BEGIN
1514: savepoint execute_msl_pay_sp;

Line 3566: l_name per_people_f.full_name%type;

3562: p_days in number default 350
3563: )
3564: return boolean is
3565: --
3566: l_name per_people_f.full_name%type;
3567: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3568:
3569: cursor csr_action_taken is
3570: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id

Line 3742: l_name per_people_f.full_name%type;

3738: p_days in number default 350
3739: )
3740: return boolean is
3741: --
3742: l_name per_people_f.full_name%type;
3743: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3744:
3745: cursor csr_action_taken is
3746: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id

Line 5510: l_name per_people_f.full_name%type;

5506: p_action in varchar2
5507: )
5508: return boolean is
5509: --
5510: l_name per_people_f.full_name%type;
5511: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
5512:
5513: cursor csr_action_taken is
5514: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id