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 115: --- This SQL is tuned by joining the hr_organization_units to avoid the FTS of PAF.

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

Line 137: hr_organization_units hou

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

Line 338: l_org_name hr_organization_units.name%type;

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

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

4958: ---
4959: --- Bug 3539816 Order by added to prevent snapshot old error
4960: --- 2. Cursor with no organization.
4961: ---
4962: --- This SQL is tuned by joining the hr_organization_units to avoid the FTS of PAF.
4963: --- Bug 6152582
4964: ---
4965: cursor cur_people (effective_date date) is
4966: select ppf.person_id PERSON_ID,

Line 4984: hr_organization_units hou

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

Line 5174: l_org_name hr_organization_units.name%type;

5170: where substr(user_table_name,1,4) = 'ESSL'
5171: and user_table_id = l_user_table_id;
5172:
5173: l_essl_table BOOLEAN := FALSE;
5174: l_org_name hr_organization_units.name%type;
5175:
5176: -- Bug 3315432 Madhuri
5177: --
5178: CURSOR cur_pp_prd_per_gr(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)

Line 7034: hr_organization_units hou

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

Line 7237: l_org_name hr_organization_units.name%type;

7233: where substr(user_table_name,1,4) = 'ESSL'
7234: and user_table_id = l_user_table_id;
7235:
7236: l_essl_table BOOLEAN := FALSE;
7237: l_org_name hr_organization_units.name%type;
7238:
7239: CURSOR cur_pp_prd(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)
7240: IS
7241: SELECT pay_plan ,pay_rate_determinant prd