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 HR_ORGANIZATION_UNITS

Line 117: --- This SQL is tuned by joining the hr_organization_units to avoid the FTS of PAF.

113: ---
114: --- Bug 3539816 Order by added to prevent snapshot old error
115: --- 2. Cursor with no organization.
116: ---
117: --- This SQL is tuned by joining the hr_organization_units to avoid the FTS of PAF.
118: --- Bug 6152582
119: ---
120: CURSOR cur_people (effective_date date) IS
121: SELECT ppf.person_id PERSON_ID,

Line 141: hr_organization_units hou

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
144: AND effective_date between paf.effective_start_date and paf.effective_end_date
145: AND paf.primary_flag = 'Y'

Line 342: l_org_name hr_organization_units.name%type;

338: WHERE substr(user_table_name,1,4) = 'ESSL'
339: AND user_table_id = l_user_table_id;
340:
341: l_essl_table BOOLEAN := FALSE;
342: l_org_name hr_organization_units.name%type;
343:
344: -- Bug 3315432 Madhuri
345: --
346: CURSOR cur_pp_prd(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)

Line 5022: --- This SQL is tuned by joining the hr_organization_units to avoid the FTS of PAF.

5018: ---
5019: --- Bug 3539816 Order by added to prevent snapshot old error
5020: --- 2. Cursor with no organization.
5021: ---
5022: --- This SQL is tuned by joining the hr_organization_units to avoid the FTS of PAF.
5023: --- Bug 6152582
5024: ---
5025: cursor cur_people (effective_date date) is
5026: select ppf.person_id PERSON_ID,

Line 5046: hr_organization_units hou

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
5049: and effective_date between paf.effective_start_date and paf.effective_end_date
5050: and paf.primary_flag = 'Y'

Line 5236: l_org_name hr_organization_units.name%type;

5232: where substr(user_table_name,1,4) = 'ESSL'
5233: and user_table_id = l_user_table_id;
5234:
5235: l_essl_table BOOLEAN := FALSE;
5236: l_org_name hr_organization_units.name%type;
5237:
5238: -- Bug 3315432 Madhuri
5239: --
5240: CURSOR cur_pp_prd_per_gr(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)

Line 7180: hr_organization_units hou

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
7183: and effective_date between paf.effective_start_date and paf.effective_end_date
7184: and paf.primary_flag = 'Y'

Line 7383: l_org_name hr_organization_units.name%type;

7379: where substr(user_table_name,1,4) = 'ESSL'
7380: and user_table_id = l_user_table_id;
7381:
7382: l_essl_table BOOLEAN := FALSE;
7383: l_org_name hr_organization_units.name%type;
7384:
7385: CURSOR cur_pp_prd(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)
7386: IS
7387: SELECT pay_plan ,pay_rate_determinant prd