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_MSL_PKG dependencies on PER_PEOPLE_F

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

21: p_mass_salary varchar2(32);
22:
23: --
24: --
25: -- Main Cursor which fetches from per_assignments_f and per_people_f
26: --
27: /***** Splitting the cursor into two for better performance
28: ***** 1. First eliminate the check of assignment_status_type_id in the cursor and have outside.
29: ***** 2. One cursor as organization as not null

Line 49: per_people_f ppf,

45: paf.location_id LOCATION_ID,
46: paf.organization_id ORGANIZATION_ID,
47: paf.business_group_id BUSINESS_GROUP_ID
48: from per_assignments_f paf,
49: per_people_f ppf,
50: per_person_types ppt,
51: per_assignment_status_types pas_t
52: where ppf.person_id = paf.person_id
53: and paf.primary_flag = 'Y'

Line 97: per_people_f ppf,

93: paf.organization_id ORGANIZATION_ID,
94: paf.business_group_id BUSINESS_GROUP_ID,
95: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
96: FROM per_assignments_f paf,
97: per_people_f ppf,
98: per_person_types ppt
99: WHERE ppf.person_id = paf.person_id
100: AND effective_date between ppf.effective_start_date and ppf.effective_end_date
101: AND effective_date between paf.effective_start_date and paf.effective_end_date

Line 135: per_people_f ppf,

131: paf.organization_id ORGANIZATION_ID,
132: paf.business_group_id BUSINESS_GROUP_ID,
133: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
134: FROM per_assignments_f paf,
135: per_people_f ppf,
136: per_person_types ppt,
137: hr_organization_units hou
138: WHERE ppf.person_id = paf.person_id
139: AND effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 380: ,p_first_name per_people_f.first_name%TYPE

376: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
377: ,p_location_id per_assignments_f.location_id%TYPE
378: ,p_organization_id per_assignments_f.organization_id%TYPE
379: ,p_date_of_birth date
380: ,p_first_name per_people_f.first_name%TYPE
381: ,p_last_name per_people_f.last_name%TYPE
382: ,p_full_name per_people_f.full_name%TYPE
383: ,p_middle_names per_people_f.middle_names%TYPE
384: ,p_national_identifier per_people_f.national_identifier%TYPE

Line 381: ,p_last_name per_people_f.last_name%TYPE

377: ,p_location_id per_assignments_f.location_id%TYPE
378: ,p_organization_id per_assignments_f.organization_id%TYPE
379: ,p_date_of_birth date
380: ,p_first_name per_people_f.first_name%TYPE
381: ,p_last_name per_people_f.last_name%TYPE
382: ,p_full_name per_people_f.full_name%TYPE
383: ,p_middle_names per_people_f.middle_names%TYPE
384: ,p_national_identifier per_people_f.national_identifier%TYPE
385: ,p_personnel_office_id IN VARCHAR2

Line 382: ,p_full_name per_people_f.full_name%TYPE

378: ,p_organization_id per_assignments_f.organization_id%TYPE
379: ,p_date_of_birth date
380: ,p_first_name per_people_f.first_name%TYPE
381: ,p_last_name per_people_f.last_name%TYPE
382: ,p_full_name per_people_f.full_name%TYPE
383: ,p_middle_names per_people_f.middle_names%TYPE
384: ,p_national_identifier per_people_f.national_identifier%TYPE
385: ,p_personnel_office_id IN VARCHAR2
386: ,p_org_structure_id IN VARCHAR2

Line 383: ,p_middle_names per_people_f.middle_names%TYPE

379: ,p_date_of_birth date
380: ,p_first_name per_people_f.first_name%TYPE
381: ,p_last_name per_people_f.last_name%TYPE
382: ,p_full_name per_people_f.full_name%TYPE
383: ,p_middle_names per_people_f.middle_names%TYPE
384: ,p_national_identifier per_people_f.national_identifier%TYPE
385: ,p_personnel_office_id IN VARCHAR2
386: ,p_org_structure_id IN VARCHAR2
387: ,p_position_title IN VARCHAR2

Line 384: ,p_national_identifier per_people_f.national_identifier%TYPE

380: ,p_first_name per_people_f.first_name%TYPE
381: ,p_last_name per_people_f.last_name%TYPE
382: ,p_full_name per_people_f.full_name%TYPE
383: ,p_middle_names per_people_f.middle_names%TYPE
384: ,p_national_identifier per_people_f.national_identifier%TYPE
385: ,p_personnel_office_id IN VARCHAR2
386: ,p_org_structure_id IN VARCHAR2
387: ,p_position_title IN VARCHAR2
388: ,p_position_number IN VARCHAR2

Line 2788: ,p_full_name IN per_people_f.full_name%TYPE

2784: PROCEDURE fetch_and_validate_emp(
2785: p_action IN VARCHAR2
2786: ,p_mass_salary_id IN NUMBER
2787: ,p_mass_salary_name IN VARCHAR2
2788: ,p_full_name IN per_people_f.full_name%TYPE
2789: ,p_national_identifier IN per_people_f.national_identifier%TYPE
2790: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
2791: ,p_person_id IN per_assignments_f.person_id%TYPE
2792: ,p_position_id IN per_assignments_f.position_id%TYPE

Line 2789: ,p_national_identifier IN per_people_f.national_identifier%TYPE

2785: p_action IN VARCHAR2
2786: ,p_mass_salary_id IN NUMBER
2787: ,p_mass_salary_name IN VARCHAR2
2788: ,p_full_name IN per_people_f.full_name%TYPE
2789: ,p_national_identifier IN per_people_f.national_identifier%TYPE
2790: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
2791: ,p_person_id IN per_assignments_f.person_id%TYPE
2792: ,p_position_id IN per_assignments_f.position_id%TYPE
2793: ,p_grade_id IN per_assignments_f.grade_id%TYPE

Line 3154: ,p_full_name IN per_people_f.full_name%TYPE

3150: PROCEDURE fetch_and_validate_emp_perc(
3151: p_action IN VARCHAR2
3152: ,p_mass_salary_id IN NUMBER
3153: ,p_mass_salary_name IN VARCHAR2
3154: ,p_full_name IN per_people_f.full_name%TYPE
3155: ,p_national_identifier IN per_people_f.national_identifier%TYPE
3156: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
3157: ,p_person_id IN per_assignments_f.person_id%TYPE
3158: ,p_position_id IN per_assignments_f.position_id%TYPE

Line 3155: ,p_national_identifier IN per_people_f.national_identifier%TYPE

3151: p_action IN VARCHAR2
3152: ,p_mass_salary_id IN NUMBER
3153: ,p_mass_salary_name IN VARCHAR2
3154: ,p_full_name IN per_people_f.full_name%TYPE
3155: ,p_national_identifier IN per_people_f.national_identifier%TYPE
3156: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
3157: ,p_person_id IN per_assignments_f.person_id%TYPE
3158: ,p_position_id IN per_assignments_f.position_id%TYPE
3159: ,p_grade_id IN per_assignments_f.grade_id%TYPE

Line 3681: l_name per_people_f.full_name%type;

3677: p_days in number default 350
3678: )
3679: return boolean is
3680: --
3681: l_name per_people_f.full_name%type;
3682: -- Bug#3718167 Added l_ssn
3683: l_ssn per_people_f.national_identifier%TYPE;
3684: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3685:

Line 3683: l_ssn per_people_f.national_identifier%TYPE;

3679: return boolean is
3680: --
3681: l_name per_people_f.full_name%type;
3682: -- Bug#3718167 Added l_ssn
3683: l_ssn per_people_f.national_identifier%TYPE;
3684: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3685:
3686: cursor csr_action_taken is
3687: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id

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

4917: p_mass_salary varchar2(32);
4918:
4919: --
4920: --
4921: -- Main Cursor which fetches from per_assignments_f and per_people_f
4922: --
4923: --
4924: --1. Cursor with organization.
4925: ---

Line 4945: per_people_f ppf,

4941: paf.organization_id ORGANIZATION_ID,
4942: paf.business_group_id BUSINESS_GROUP_ID,
4943: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
4944: from per_assignments_f paf,
4945: per_people_f ppf,
4946: per_person_types ppt
4947: where ppf.person_id = paf.person_id
4948: and effective_date between ppf.effective_start_date and ppf.effective_end_date
4949: and effective_date between paf.effective_start_date and paf.effective_end_date

Line 4982: per_people_f ppf,

4978: paf.organization_id ORGANIZATION_ID,
4979: paf.business_group_id BUSINESS_GROUP_ID,
4980: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
4981: from per_assignments_f paf,
4982: per_people_f ppf,
4983: per_person_types ppt,
4984: hr_organization_units hou
4985: where ppf.person_id = paf.person_id
4986: and effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 5225: ,p_first_name per_people_f.first_name%TYPE

5221: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
5222: ,p_location_id per_assignments_f.location_id%TYPE
5223: ,p_organization_id per_assignments_f.organization_id%TYPE
5224: ,p_date_of_birth date
5225: ,p_first_name per_people_f.first_name%TYPE
5226: ,p_last_name per_people_f.last_name%TYPE
5227: ,p_full_name per_people_f.full_name%TYPE
5228: ,p_middle_names per_people_f.middle_names%TYPE
5229: ,p_national_identifier per_people_f.national_identifier%TYPE

Line 5226: ,p_last_name per_people_f.last_name%TYPE

5222: ,p_location_id per_assignments_f.location_id%TYPE
5223: ,p_organization_id per_assignments_f.organization_id%TYPE
5224: ,p_date_of_birth date
5225: ,p_first_name per_people_f.first_name%TYPE
5226: ,p_last_name per_people_f.last_name%TYPE
5227: ,p_full_name per_people_f.full_name%TYPE
5228: ,p_middle_names per_people_f.middle_names%TYPE
5229: ,p_national_identifier per_people_f.national_identifier%TYPE
5230: ,p_personnel_office_id IN VARCHAR2

Line 5227: ,p_full_name per_people_f.full_name%TYPE

5223: ,p_organization_id per_assignments_f.organization_id%TYPE
5224: ,p_date_of_birth date
5225: ,p_first_name per_people_f.first_name%TYPE
5226: ,p_last_name per_people_f.last_name%TYPE
5227: ,p_full_name per_people_f.full_name%TYPE
5228: ,p_middle_names per_people_f.middle_names%TYPE
5229: ,p_national_identifier per_people_f.national_identifier%TYPE
5230: ,p_personnel_office_id IN VARCHAR2
5231: ,p_org_structure_id IN VARCHAR2

Line 5228: ,p_middle_names per_people_f.middle_names%TYPE

5224: ,p_date_of_birth date
5225: ,p_first_name per_people_f.first_name%TYPE
5226: ,p_last_name per_people_f.last_name%TYPE
5227: ,p_full_name per_people_f.full_name%TYPE
5228: ,p_middle_names per_people_f.middle_names%TYPE
5229: ,p_national_identifier per_people_f.national_identifier%TYPE
5230: ,p_personnel_office_id IN VARCHAR2
5231: ,p_org_structure_id IN VARCHAR2
5232: ,p_position_title IN VARCHAR2

Line 5229: ,p_national_identifier per_people_f.national_identifier%TYPE

5225: ,p_first_name per_people_f.first_name%TYPE
5226: ,p_last_name per_people_f.last_name%TYPE
5227: ,p_full_name per_people_f.full_name%TYPE
5228: ,p_middle_names per_people_f.middle_names%TYPE
5229: ,p_national_identifier per_people_f.national_identifier%TYPE
5230: ,p_personnel_office_id IN VARCHAR2
5231: ,p_org_structure_id IN VARCHAR2
5232: ,p_position_title IN VARCHAR2
5233: ,p_position_number IN VARCHAR2

Line 6574: ,p_full_name IN per_people_f.full_name%TYPE

6570: PROCEDURE fetch_and_validate_emp_ses(
6571: p_action IN VARCHAR2
6572: ,p_mass_salary_id IN NUMBER
6573: ,p_mass_salary_name IN VARCHAR2
6574: ,p_full_name IN per_people_f.full_name%TYPE
6575: ,p_national_identifier IN per_people_f.national_identifier%TYPE
6576: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
6577: ,p_person_id IN per_assignments_f.person_id%TYPE
6578: ,p_position_id IN per_assignments_f.position_id%TYPE

Line 6575: ,p_national_identifier IN per_people_f.national_identifier%TYPE

6571: p_action IN VARCHAR2
6572: ,p_mass_salary_id IN NUMBER
6573: ,p_mass_salary_name IN VARCHAR2
6574: ,p_full_name IN per_people_f.full_name%TYPE
6575: ,p_national_identifier IN per_people_f.national_identifier%TYPE
6576: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
6577: ,p_person_id IN per_assignments_f.person_id%TYPE
6578: ,p_position_id IN per_assignments_f.position_id%TYPE
6579: ,p_grade_id IN per_assignments_f.grade_id%TYPE

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

6972: p_mass_salary varchar2(32);
6973:
6974: --
6975: --
6976: -- Main Cursor which fetches from per_assignments_f and per_people_f
6977: --
6978: --
6979: --1. Cursor with organization.
6980: ---

Line 6998: per_people_f ppf,

6994: paf.organization_id ORGANIZATION_ID,
6995: paf.business_group_id BUSINESS_GROUP_ID,
6996: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
6997: from per_assignments_f paf,
6998: per_people_f ppf,
6999: per_person_types ppt
7000: where ppf.person_id = paf.person_id
7001: and effective_date between ppf.effective_start_date and ppf.effective_end_date
7002: and effective_date between paf.effective_start_date and paf.effective_end_date

Line 7032: per_people_f ppf,

7028: paf.organization_id ORGANIZATION_ID,
7029: paf.business_group_id BUSINESS_GROUP_ID,
7030: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
7031: from per_assignments_f paf,
7032: per_people_f ppf,
7033: per_person_types ppt,
7034: hr_organization_units hou
7035: where ppf.person_id = paf.person_id
7036: and effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 7273: ,p_first_name per_people_f.first_name%TYPE

7269: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
7270: ,p_location_id per_assignments_f.location_id%TYPE
7271: ,p_organization_id per_assignments_f.organization_id%TYPE
7272: ,p_date_of_birth date
7273: ,p_first_name per_people_f.first_name%TYPE
7274: ,p_last_name per_people_f.last_name%TYPE
7275: ,p_full_name per_people_f.full_name%TYPE
7276: ,p_middle_names per_people_f.middle_names%TYPE
7277: ,p_national_identifier per_people_f.national_identifier%TYPE

Line 7274: ,p_last_name per_people_f.last_name%TYPE

7270: ,p_location_id per_assignments_f.location_id%TYPE
7271: ,p_organization_id per_assignments_f.organization_id%TYPE
7272: ,p_date_of_birth date
7273: ,p_first_name per_people_f.first_name%TYPE
7274: ,p_last_name per_people_f.last_name%TYPE
7275: ,p_full_name per_people_f.full_name%TYPE
7276: ,p_middle_names per_people_f.middle_names%TYPE
7277: ,p_national_identifier per_people_f.national_identifier%TYPE
7278: ,p_personnel_office_id IN VARCHAR2

Line 7275: ,p_full_name per_people_f.full_name%TYPE

7271: ,p_organization_id per_assignments_f.organization_id%TYPE
7272: ,p_date_of_birth date
7273: ,p_first_name per_people_f.first_name%TYPE
7274: ,p_last_name per_people_f.last_name%TYPE
7275: ,p_full_name per_people_f.full_name%TYPE
7276: ,p_middle_names per_people_f.middle_names%TYPE
7277: ,p_national_identifier per_people_f.national_identifier%TYPE
7278: ,p_personnel_office_id IN VARCHAR2
7279: ,p_org_structure_id IN VARCHAR2

Line 7276: ,p_middle_names per_people_f.middle_names%TYPE

7272: ,p_date_of_birth date
7273: ,p_first_name per_people_f.first_name%TYPE
7274: ,p_last_name per_people_f.last_name%TYPE
7275: ,p_full_name per_people_f.full_name%TYPE
7276: ,p_middle_names per_people_f.middle_names%TYPE
7277: ,p_national_identifier per_people_f.national_identifier%TYPE
7278: ,p_personnel_office_id IN VARCHAR2
7279: ,p_org_structure_id IN VARCHAR2
7280: ,p_position_title IN VARCHAR2

Line 7277: ,p_national_identifier per_people_f.national_identifier%TYPE

7273: ,p_first_name per_people_f.first_name%TYPE
7274: ,p_last_name per_people_f.last_name%TYPE
7275: ,p_full_name per_people_f.full_name%TYPE
7276: ,p_middle_names per_people_f.middle_names%TYPE
7277: ,p_national_identifier per_people_f.national_identifier%TYPE
7278: ,p_personnel_office_id IN VARCHAR2
7279: ,p_org_structure_id IN VARCHAR2
7280: ,p_position_title IN VARCHAR2
7281: ,p_position_number IN VARCHAR2