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

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

Line 139: per_people_f ppf,

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

Line 384: ,p_first_name per_people_f.first_name%TYPE

380: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
381: ,p_location_id per_assignments_f.location_id%TYPE
382: ,p_organization_id per_assignments_f.organization_id%TYPE
383: ,p_date_of_birth date
384: ,p_first_name per_people_f.first_name%TYPE
385: ,p_last_name per_people_f.last_name%TYPE
386: ,p_full_name per_people_f.full_name%TYPE
387: ,p_middle_names per_people_f.middle_names%TYPE
388: ,p_national_identifier per_people_f.national_identifier%TYPE

Line 385: ,p_last_name per_people_f.last_name%TYPE

381: ,p_location_id per_assignments_f.location_id%TYPE
382: ,p_organization_id per_assignments_f.organization_id%TYPE
383: ,p_date_of_birth date
384: ,p_first_name per_people_f.first_name%TYPE
385: ,p_last_name per_people_f.last_name%TYPE
386: ,p_full_name per_people_f.full_name%TYPE
387: ,p_middle_names per_people_f.middle_names%TYPE
388: ,p_national_identifier per_people_f.national_identifier%TYPE
389: --Bug # 9329643

Line 386: ,p_full_name per_people_f.full_name%TYPE

382: ,p_organization_id per_assignments_f.organization_id%TYPE
383: ,p_date_of_birth date
384: ,p_first_name per_people_f.first_name%TYPE
385: ,p_last_name per_people_f.last_name%TYPE
386: ,p_full_name per_people_f.full_name%TYPE
387: ,p_middle_names per_people_f.middle_names%TYPE
388: ,p_national_identifier per_people_f.national_identifier%TYPE
389: --Bug # 9329643
390: ,p_employee_number per_people_f.employee_number%TYPE

Line 387: ,p_middle_names per_people_f.middle_names%TYPE

383: ,p_date_of_birth date
384: ,p_first_name per_people_f.first_name%TYPE
385: ,p_last_name per_people_f.last_name%TYPE
386: ,p_full_name per_people_f.full_name%TYPE
387: ,p_middle_names per_people_f.middle_names%TYPE
388: ,p_national_identifier per_people_f.national_identifier%TYPE
389: --Bug # 9329643
390: ,p_employee_number per_people_f.employee_number%TYPE
391: ,p_personnel_office_id IN VARCHAR2

Line 388: ,p_national_identifier per_people_f.national_identifier%TYPE

384: ,p_first_name per_people_f.first_name%TYPE
385: ,p_last_name per_people_f.last_name%TYPE
386: ,p_full_name per_people_f.full_name%TYPE
387: ,p_middle_names per_people_f.middle_names%TYPE
388: ,p_national_identifier per_people_f.national_identifier%TYPE
389: --Bug # 9329643
390: ,p_employee_number per_people_f.employee_number%TYPE
391: ,p_personnel_office_id IN VARCHAR2
392: ,p_org_structure_id IN VARCHAR2

Line 390: ,p_employee_number per_people_f.employee_number%TYPE

386: ,p_full_name per_people_f.full_name%TYPE
387: ,p_middle_names per_people_f.middle_names%TYPE
388: ,p_national_identifier per_people_f.national_identifier%TYPE
389: --Bug # 9329643
390: ,p_employee_number per_people_f.employee_number%TYPE
391: ,p_personnel_office_id IN VARCHAR2
392: ,p_org_structure_id IN VARCHAR2
393: ,p_position_title IN VARCHAR2
394: ,p_position_number IN VARCHAR2

Line 2816: ,p_full_name IN per_people_f.full_name%TYPE

2812: PROCEDURE fetch_and_validate_emp(
2813: p_action IN VARCHAR2
2814: ,p_mass_salary_id IN NUMBER
2815: ,p_mass_salary_name IN VARCHAR2
2816: ,p_full_name IN per_people_f.full_name%TYPE
2817: ,p_national_identifier IN per_people_f.national_identifier%TYPE
2818: --Bug # 9329643
2819: ,p_employee_number IN per_people_f.employee_number%TYPE
2820: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE

Line 2817: ,p_national_identifier IN per_people_f.national_identifier%TYPE

2813: p_action IN VARCHAR2
2814: ,p_mass_salary_id IN NUMBER
2815: ,p_mass_salary_name IN VARCHAR2
2816: ,p_full_name IN per_people_f.full_name%TYPE
2817: ,p_national_identifier IN per_people_f.national_identifier%TYPE
2818: --Bug # 9329643
2819: ,p_employee_number IN per_people_f.employee_number%TYPE
2820: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
2821: ,p_person_id IN per_assignments_f.person_id%TYPE

Line 2819: ,p_employee_number IN per_people_f.employee_number%TYPE

2815: ,p_mass_salary_name IN VARCHAR2
2816: ,p_full_name IN per_people_f.full_name%TYPE
2817: ,p_national_identifier IN per_people_f.national_identifier%TYPE
2818: --Bug # 9329643
2819: ,p_employee_number IN per_people_f.employee_number%TYPE
2820: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
2821: ,p_person_id IN per_assignments_f.person_id%TYPE
2822: ,p_position_id IN per_assignments_f.position_id%TYPE
2823: ,p_grade_id IN per_assignments_f.grade_id%TYPE

Line 3185: ,p_full_name IN per_people_f.full_name%TYPE

3181: PROCEDURE fetch_and_validate_emp_perc(
3182: p_action IN VARCHAR2
3183: ,p_mass_salary_id IN NUMBER
3184: ,p_mass_salary_name IN VARCHAR2
3185: ,p_full_name IN per_people_f.full_name%TYPE
3186: ,p_national_identifier IN per_people_f.national_identifier%TYPE
3187: --Bug # 9329643
3188: ,p_employee_number IN per_people_f.employee_number%TYPE
3189: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE

Line 3186: ,p_national_identifier IN per_people_f.national_identifier%TYPE

3182: p_action IN VARCHAR2
3183: ,p_mass_salary_id IN NUMBER
3184: ,p_mass_salary_name IN VARCHAR2
3185: ,p_full_name IN per_people_f.full_name%TYPE
3186: ,p_national_identifier IN per_people_f.national_identifier%TYPE
3187: --Bug # 9329643
3188: ,p_employee_number IN per_people_f.employee_number%TYPE
3189: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
3190: ,p_person_id IN per_assignments_f.person_id%TYPE

Line 3188: ,p_employee_number IN per_people_f.employee_number%TYPE

3184: ,p_mass_salary_name IN VARCHAR2
3185: ,p_full_name IN per_people_f.full_name%TYPE
3186: ,p_national_identifier IN per_people_f.national_identifier%TYPE
3187: --Bug # 9329643
3188: ,p_employee_number IN per_people_f.employee_number%TYPE
3189: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
3190: ,p_person_id IN per_assignments_f.person_id%TYPE
3191: ,p_position_id IN per_assignments_f.position_id%TYPE
3192: ,p_grade_id IN per_assignments_f.grade_id%TYPE

Line 3715: l_name per_people_f.full_name%type;

3711: p_days in number default 350
3712: )
3713: return boolean is
3714: --
3715: l_name per_people_f.full_name%type;
3716: -- Bug#3718167 Added l_ssn
3717: l_ssn per_people_f.national_identifier%TYPE;
3718: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3719: --Bug # 9329643

Line 3717: l_ssn per_people_f.national_identifier%TYPE;

3713: return boolean is
3714: --
3715: l_name per_people_f.full_name%type;
3716: -- Bug#3718167 Added l_ssn
3717: l_ssn per_people_f.national_identifier%TYPE;
3718: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3719: --Bug # 9329643
3720: l_employee_number per_people_f.employee_number%type;
3721:

Line 3720: l_employee_number per_people_f.employee_number%type;

3716: -- Bug#3718167 Added l_ssn
3717: l_ssn per_people_f.national_identifier%TYPE;
3718: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3719: --Bug # 9329643
3720: l_employee_number per_people_f.employee_number%type;
3721:
3722: cursor csr_action_taken is
3723: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3724: from ghr_pa_requests pr, ghr_pa_routing_history prh

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

4975: p_mass_salary varchar2(32);
4976:
4977: --
4978: --
4979: -- Main Cursor which fetches from per_assignments_f and per_people_f
4980: --
4981: --
4982: --1. Cursor with organization.
4983: ---

Line 5005: per_people_f ppf,

5001: paf.organization_id ORGANIZATION_ID,
5002: paf.business_group_id BUSINESS_GROUP_ID,
5003: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
5004: from per_assignments_f paf,
5005: per_people_f ppf,
5006: per_person_types ppt
5007: where ppf.person_id = paf.person_id
5008: and effective_date between ppf.effective_start_date and ppf.effective_end_date
5009: and effective_date between paf.effective_start_date and paf.effective_end_date

Line 5044: per_people_f ppf,

5040: paf.organization_id ORGANIZATION_ID,
5041: paf.business_group_id BUSINESS_GROUP_ID,
5042: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
5043: from per_assignments_f paf,
5044: per_people_f ppf,
5045: per_person_types ppt,
5046: hr_organization_units hou
5047: where ppf.person_id = paf.person_id
5048: and effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 5287: ,p_first_name per_people_f.first_name%TYPE

5283: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
5284: ,p_location_id per_assignments_f.location_id%TYPE
5285: ,p_organization_id per_assignments_f.organization_id%TYPE
5286: ,p_date_of_birth date
5287: ,p_first_name per_people_f.first_name%TYPE
5288: ,p_last_name per_people_f.last_name%TYPE
5289: ,p_full_name per_people_f.full_name%TYPE
5290: ,p_middle_names per_people_f.middle_names%TYPE
5291: ,p_national_identifier per_people_f.national_identifier%TYPE

Line 5288: ,p_last_name per_people_f.last_name%TYPE

5284: ,p_location_id per_assignments_f.location_id%TYPE
5285: ,p_organization_id per_assignments_f.organization_id%TYPE
5286: ,p_date_of_birth date
5287: ,p_first_name per_people_f.first_name%TYPE
5288: ,p_last_name per_people_f.last_name%TYPE
5289: ,p_full_name per_people_f.full_name%TYPE
5290: ,p_middle_names per_people_f.middle_names%TYPE
5291: ,p_national_identifier per_people_f.national_identifier%TYPE
5292: --Bug # 9329643

Line 5289: ,p_full_name per_people_f.full_name%TYPE

5285: ,p_organization_id per_assignments_f.organization_id%TYPE
5286: ,p_date_of_birth date
5287: ,p_first_name per_people_f.first_name%TYPE
5288: ,p_last_name per_people_f.last_name%TYPE
5289: ,p_full_name per_people_f.full_name%TYPE
5290: ,p_middle_names per_people_f.middle_names%TYPE
5291: ,p_national_identifier per_people_f.national_identifier%TYPE
5292: --Bug # 9329643
5293: ,p_employee_number per_people_f.employee_number%TYPE

Line 5290: ,p_middle_names per_people_f.middle_names%TYPE

5286: ,p_date_of_birth date
5287: ,p_first_name per_people_f.first_name%TYPE
5288: ,p_last_name per_people_f.last_name%TYPE
5289: ,p_full_name per_people_f.full_name%TYPE
5290: ,p_middle_names per_people_f.middle_names%TYPE
5291: ,p_national_identifier per_people_f.national_identifier%TYPE
5292: --Bug # 9329643
5293: ,p_employee_number per_people_f.employee_number%TYPE
5294: ,p_personnel_office_id IN VARCHAR2

Line 5291: ,p_national_identifier per_people_f.national_identifier%TYPE

5287: ,p_first_name per_people_f.first_name%TYPE
5288: ,p_last_name per_people_f.last_name%TYPE
5289: ,p_full_name per_people_f.full_name%TYPE
5290: ,p_middle_names per_people_f.middle_names%TYPE
5291: ,p_national_identifier per_people_f.national_identifier%TYPE
5292: --Bug # 9329643
5293: ,p_employee_number per_people_f.employee_number%TYPE
5294: ,p_personnel_office_id IN VARCHAR2
5295: ,p_org_structure_id IN VARCHAR2

Line 5293: ,p_employee_number per_people_f.employee_number%TYPE

5289: ,p_full_name per_people_f.full_name%TYPE
5290: ,p_middle_names per_people_f.middle_names%TYPE
5291: ,p_national_identifier per_people_f.national_identifier%TYPE
5292: --Bug # 9329643
5293: ,p_employee_number per_people_f.employee_number%TYPE
5294: ,p_personnel_office_id IN VARCHAR2
5295: ,p_org_structure_id IN VARCHAR2
5296: ,p_position_title IN VARCHAR2
5297: ,p_position_number IN VARCHAR2

Line 6714: ,p_full_name IN per_people_f.full_name%TYPE

6710: PROCEDURE fetch_and_validate_emp_ses(
6711: p_action IN VARCHAR2
6712: ,p_mass_salary_id IN NUMBER
6713: ,p_mass_salary_name IN VARCHAR2
6714: ,p_full_name IN per_people_f.full_name%TYPE
6715: ,p_national_identifier IN per_people_f.national_identifier%TYPE
6716: ,p_employee_number IN per_people_f.employee_number%TYPE
6717: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
6718: ,p_person_id IN per_assignments_f.person_id%TYPE

Line 6715: ,p_national_identifier IN per_people_f.national_identifier%TYPE

6711: p_action IN VARCHAR2
6712: ,p_mass_salary_id IN NUMBER
6713: ,p_mass_salary_name IN VARCHAR2
6714: ,p_full_name IN per_people_f.full_name%TYPE
6715: ,p_national_identifier IN per_people_f.national_identifier%TYPE
6716: ,p_employee_number IN per_people_f.employee_number%TYPE
6717: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
6718: ,p_person_id IN per_assignments_f.person_id%TYPE
6719: ,p_position_id IN per_assignments_f.position_id%TYPE

Line 6716: ,p_employee_number IN per_people_f.employee_number%TYPE

6712: ,p_mass_salary_id IN NUMBER
6713: ,p_mass_salary_name IN VARCHAR2
6714: ,p_full_name IN per_people_f.full_name%TYPE
6715: ,p_national_identifier IN per_people_f.national_identifier%TYPE
6716: ,p_employee_number IN per_people_f.employee_number%TYPE
6717: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
6718: ,p_person_id IN per_assignments_f.person_id%TYPE
6719: ,p_position_id IN per_assignments_f.position_id%TYPE
6720: ,p_grade_id IN per_assignments_f.grade_id%TYPE

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

7114: p_mass_salary varchar2(32);
7115:
7116: --
7117: --
7118: -- Main Cursor which fetches from per_assignments_f and per_people_f
7119: --
7120: --
7121: --1. Cursor with organization.
7122: ---

Line 7142: per_people_f ppf,

7138: paf.organization_id ORGANIZATION_ID,
7139: paf.business_group_id BUSINESS_GROUP_ID,
7140: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
7141: from per_assignments_f paf,
7142: per_people_f ppf,
7143: per_person_types ppt
7144: where ppf.person_id = paf.person_id
7145: and effective_date between ppf.effective_start_date and ppf.effective_end_date
7146: and effective_date between paf.effective_start_date and paf.effective_end_date

Line 7178: per_people_f ppf,

7174: paf.organization_id ORGANIZATION_ID,
7175: paf.business_group_id BUSINESS_GROUP_ID,
7176: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
7177: from per_assignments_f paf,
7178: per_people_f ppf,
7179: per_person_types ppt,
7180: hr_organization_units hou
7181: where ppf.person_id = paf.person_id
7182: and effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 7419: ,p_first_name per_people_f.first_name%TYPE

7415: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
7416: ,p_location_id per_assignments_f.location_id%TYPE
7417: ,p_organization_id per_assignments_f.organization_id%TYPE
7418: ,p_date_of_birth date
7419: ,p_first_name per_people_f.first_name%TYPE
7420: ,p_last_name per_people_f.last_name%TYPE
7421: ,p_full_name per_people_f.full_name%TYPE
7422: ,p_middle_names per_people_f.middle_names%TYPE
7423: ,p_national_identifier per_people_f.national_identifier%TYPE

Line 7420: ,p_last_name per_people_f.last_name%TYPE

7416: ,p_location_id per_assignments_f.location_id%TYPE
7417: ,p_organization_id per_assignments_f.organization_id%TYPE
7418: ,p_date_of_birth date
7419: ,p_first_name per_people_f.first_name%TYPE
7420: ,p_last_name per_people_f.last_name%TYPE
7421: ,p_full_name per_people_f.full_name%TYPE
7422: ,p_middle_names per_people_f.middle_names%TYPE
7423: ,p_national_identifier per_people_f.national_identifier%TYPE
7424: --Bug # 9329643

Line 7421: ,p_full_name per_people_f.full_name%TYPE

7417: ,p_organization_id per_assignments_f.organization_id%TYPE
7418: ,p_date_of_birth date
7419: ,p_first_name per_people_f.first_name%TYPE
7420: ,p_last_name per_people_f.last_name%TYPE
7421: ,p_full_name per_people_f.full_name%TYPE
7422: ,p_middle_names per_people_f.middle_names%TYPE
7423: ,p_national_identifier per_people_f.national_identifier%TYPE
7424: --Bug # 9329643
7425: ,p_employee_number per_people_f.employee_number%TYPE

Line 7422: ,p_middle_names per_people_f.middle_names%TYPE

7418: ,p_date_of_birth date
7419: ,p_first_name per_people_f.first_name%TYPE
7420: ,p_last_name per_people_f.last_name%TYPE
7421: ,p_full_name per_people_f.full_name%TYPE
7422: ,p_middle_names per_people_f.middle_names%TYPE
7423: ,p_national_identifier per_people_f.national_identifier%TYPE
7424: --Bug # 9329643
7425: ,p_employee_number per_people_f.employee_number%TYPE
7426: ,p_personnel_office_id IN VARCHAR2

Line 7423: ,p_national_identifier per_people_f.national_identifier%TYPE

7419: ,p_first_name per_people_f.first_name%TYPE
7420: ,p_last_name per_people_f.last_name%TYPE
7421: ,p_full_name per_people_f.full_name%TYPE
7422: ,p_middle_names per_people_f.middle_names%TYPE
7423: ,p_national_identifier per_people_f.national_identifier%TYPE
7424: --Bug # 9329643
7425: ,p_employee_number per_people_f.employee_number%TYPE
7426: ,p_personnel_office_id IN VARCHAR2
7427: ,p_org_structure_id IN VARCHAR2

Line 7425: ,p_employee_number per_people_f.employee_number%TYPE

7421: ,p_full_name per_people_f.full_name%TYPE
7422: ,p_middle_names per_people_f.middle_names%TYPE
7423: ,p_national_identifier per_people_f.national_identifier%TYPE
7424: --Bug # 9329643
7425: ,p_employee_number per_people_f.employee_number%TYPE
7426: ,p_personnel_office_id IN VARCHAR2
7427: ,p_org_structure_id IN VARCHAR2
7428: ,p_position_title IN VARCHAR2
7429: ,p_position_number IN VARCHAR2