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.PAY_NO_SAL_STATISTICS_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 173: ,hr_organization_information hoi1

169: ,org.name
170: ,org.location_id
171: ,hoi1.org_information1
172: FROM hr_all_organization_units org
173: ,hr_organization_information hoi1
174: WHERE org.organization_id = p_legal_employer_id
175: AND hoi1.organization_id (+) = org.organization_id
176: AND hoi1.org_information_context (+) = 'NO_LEGAL_EMPLOYER_DETAILS';
177:

Line 181: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE )

177:
178: -- Cursor to pick up Local Unit Details
179:
180: CURSOR csr_all_local_unit_details (
181: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE )
182: IS
183: SELECT hoi_le.org_information1 local_unit_id,
184: hou_lu.NAME local_unit_name,
185: hoi_lu.org_information1,

Line 189: hr_organization_information hoi_le,

185: hoi_lu.org_information1,
186: hoi_lu.org_information3,
187: hou_lu.location_id
188: FROM hr_all_organization_units hou_le,
189: hr_organization_information hoi_le,
190: hr_all_organization_units hou_lu,
191: hr_organization_information hoi_lu
192: WHERE hoi_le.organization_id = hou_le.organization_id
193: AND hou_le.organization_id = csr_v_legal_employer_id

Line 191: hr_organization_information hoi_lu

187: hou_lu.location_id
188: FROM hr_all_organization_units hou_le,
189: hr_organization_information hoi_le,
190: hr_all_organization_units hou_lu,
191: hr_organization_information hoi_lu
192: WHERE hoi_le.organization_id = hou_le.organization_id
193: AND hou_le.organization_id = csr_v_legal_employer_id
194: AND hoi_le.org_information_context = 'NO_LOCAL_UNITS'
195: AND hou_lu.organization_id = hoi_le.org_information1

Line 205: ,hr_organization_information hoi1

201: ,org.name
202: ,org.location_id
203: ,hoi1.org_information1 sp_org_number
204: FROM hr_all_organization_units org
205: ,hr_organization_information hoi1
206: WHERE org.organization_id = p_sp_org_id
207: AND hoi1.organization_id (+) = org.organization_id
208: AND hoi1.org_information_context (+) = 'NO_STATEMENT_PROVIDER_DETAILS';
209:

Line 529: FROM hr_organization_information hoi,

525: org_information3 full_part_time,
526: org_information4 shift_work,
527: org_information5 payroll_period,
528: org_information6 agreed_working_hrs
529: FROM hr_organization_information hoi,
530: hr_organization_units hou
531: WHERE hou.organization_id=g_legal_employer_id
532: AND hoi.organization_id = hou.organization_id
533: AND hoi.org_information_context='NO_EMPLOYMENT_DEFAULTS';

Line 544: hr_organization_information hoi_le,

540: hou_lu.NAME local_unit_name,
541: hoi_lu.org_information1,
542: hou_lu.location_id
543: FROM hr_all_organization_units hou_le,
544: hr_organization_information hoi_le,
545: hr_all_organization_units hou_lu,
546: hr_organization_information hoi_lu
547: WHERE hoi_le.organization_id = hou_le.organization_id
548: AND hou_le.organization_id = g_legal_employer_id

Line 546: hr_organization_information hoi_lu

542: hou_lu.location_id
543: FROM hr_all_organization_units hou_le,
544: hr_organization_information hoi_le,
545: hr_all_organization_units hou_lu,
546: hr_organization_information hoi_lu
547: WHERE hoi_le.organization_id = hou_le.organization_id
548: AND hou_le.organization_id = g_legal_employer_id
549: AND hoi_le.org_information_context = 'NO_LOCAL_UNITS'
550: AND hou_lu.organization_id = hoi_le.org_information1