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_SE_SALARY_STRUCTURE_STATS dependencies on HR_ORGANIZATION_INFORMATION

Line 190: CURSOR csr_local_unit_details (csr_v_local_unit_id hr_organization_information.organization_id%TYPE)

186: )
187: IS
188:
189: /* Local Unit Details */
190: CURSOR csr_local_unit_details (csr_v_local_unit_id hr_organization_information.organization_id%TYPE)
191: IS
192: SELECT --o1.NAME local_unit_name,
193: hoi2.org_information2 cfar_number
194: FROM hr_organization_units o1

Line 195: , hr_organization_information hoi1

191: IS
192: SELECT --o1.NAME local_unit_name,
193: hoi2.org_information2 cfar_number
194: FROM hr_organization_units o1
195: , hr_organization_information hoi1
196: , hr_organization_information hoi2
197: WHERE o1.business_group_id = g_business_group_id
198: AND hoi1.organization_id = o1.organization_id
199: AND hoi1.organization_id = csr_v_local_unit_id

Line 196: , hr_organization_information hoi2

192: SELECT --o1.NAME local_unit_name,
193: hoi2.org_information2 cfar_number
194: FROM hr_organization_units o1
195: , hr_organization_information hoi1
196: , hr_organization_information hoi2
197: WHERE o1.business_group_id = g_business_group_id
198: AND hoi1.organization_id = o1.organization_id
199: AND hoi1.organization_id = csr_v_local_unit_id
200: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 214: , hr_organization_information hoi1

210: hoi2.org_information2 Association_Number,
211: hl.meaning Agreement_Code,
212: hoi2.org_information4 Weekend_duty_pay
213: FROM hr_organization_units o1
214: , hr_organization_information hoi1
215: , hr_organization_information hoi2
216: ,hr_lookups hl
217: WHERE o1.business_group_id =csr_v_business_group_id --3133 --l_business_group_id
218: AND hoi1.organization_id = o1.organization_id

Line 215: , hr_organization_information hoi2

211: hl.meaning Agreement_Code,
212: hoi2.org_information4 Weekend_duty_pay
213: FROM hr_organization_units o1
214: , hr_organization_information hoi1
215: , hr_organization_information hoi2
216: ,hr_lookups hl
217: WHERE o1.business_group_id =csr_v_business_group_id --3133 --l_business_group_id
218: AND hoi1.organization_id = o1.organization_id
219: AND hoi1.organization_id = csr_v_legal_employer_id --3134 --csr_v_legal_unit_id

Line 232: , hr_organization_information hoi1

228: CURSOR csr_legal_employer(csr_v_business_group_id hr_organization_units.business_group_id%TYPE)
229: IS
230: SELECT o1.organization_id legal_employer_id
231: FROM hr_organization_units o1
232: , hr_organization_information hoi1
233: WHERE o1.business_group_id =csr_v_business_group_id --3133
234: AND hoi1.organization_id = o1.organization_id
235: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
236: AND hoi1.org_information_context = 'CLASS';

Line 246: , hr_organization_information hoi1

242: SELECT o1.name legal_employer,
243: hoi2.org_information2 Organization_Id,
244: hoi2.org_information9 Membership_Number
245: FROM hr_organization_units o1
246: , hr_organization_information hoi1
247: , hr_organization_information hoi2
248: WHERE o1.business_group_id =csr_v_business_group_id --3133 --l_business_group_id
249: AND hoi1.organization_id = o1.organization_id
250: AND hoi1.organization_id = csr_v_legal_employer_id --3134 --csr_v_legal_unit_id

Line 247: , hr_organization_information hoi2

243: hoi2.org_information2 Organization_Id,
244: hoi2.org_information9 Membership_Number
245: FROM hr_organization_units o1
246: , hr_organization_information hoi1
247: , hr_organization_information hoi2
248: WHERE o1.business_group_id =csr_v_business_group_id --3133 --l_business_group_id
249: AND hoi1.organization_id = o1.organization_id
250: AND hoi1.organization_id = csr_v_legal_employer_id --3134 --csr_v_legal_unit_id
251: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 263: , hr_organization_information hoi1

259: csr_v_legal_employer_id hr_organization_units.organization_id%TYPE)
260: IS
261: SELECT hoi2.ORG_INFORMATION1 local_unit
262: FROM hr_organization_units o1
263: , hr_organization_information hoi1
264: , hr_organization_information hoi2
265: WHERE o1.business_group_id =csr_v_business_group_id --3133 --l_business_group_id
266: AND hoi1.organization_id = o1.organization_id
267: AND hoi1.organization_id = csr_v_legal_employer_id --3134 --csr_v_legal_unit_id

Line 264: , hr_organization_information hoi2

260: IS
261: SELECT hoi2.ORG_INFORMATION1 local_unit
262: FROM hr_organization_units o1
263: , hr_organization_information hoi1
264: , hr_organization_information hoi2
265: WHERE o1.business_group_id =csr_v_business_group_id --3133 --l_business_group_id
266: AND hoi1.organization_id = o1.organization_id
267: AND hoi1.organization_id = csr_v_legal_employer_id --3134 --csr_v_legal_unit_id
268: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 564: , hr_organization_information hoi1

560: hr_organization_units.organization_id%TYPE)
561: IS
562: SELECT hoi2.ORG_INFORMATION1 local_unit_id
563: FROM hr_organization_units o1
564: , hr_organization_information hoi1
565: , hr_organization_information hoi2
566: WHERE o1.business_group_id =g_business_group_id
567: AND hoi1.organization_id = o1.organization_id
568: AND hoi1.organization_id = csr_v_legal_unit_id

Line 565: , hr_organization_information hoi2

561: IS
562: SELECT hoi2.ORG_INFORMATION1 local_unit_id
563: FROM hr_organization_units o1
564: , hr_organization_information hoi1
565: , hr_organization_information hoi2
566: WHERE o1.business_group_id =g_business_group_id
567: AND hoi1.organization_id = o1.organization_id
568: AND hoi1.organization_id = csr_v_legal_unit_id
569: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 576: CURSOR csr_local_unit_details (csr_v_local_unit_id hr_organization_information.organization_id%TYPE)

572: AND hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNITS';
573:
574:
575: /* Local Unit Details */
576: CURSOR csr_local_unit_details (csr_v_local_unit_id hr_organization_information.organization_id%TYPE)
577: IS
578: SELECT --o1.NAME local_unit_name,
579: hoi2.org_information2 cfar_number
580: FROM hr_organization_units o1

Line 581: , hr_organization_information hoi1

577: IS
578: SELECT --o1.NAME local_unit_name,
579: hoi2.org_information2 cfar_number
580: FROM hr_organization_units o1
581: , hr_organization_information hoi1
582: , hr_organization_information hoi2
583: WHERE o1.business_group_id = g_business_group_id
584: AND hoi1.organization_id = o1.organization_id
585: AND hoi1.organization_id = csr_v_local_unit_id

Line 582: , hr_organization_information hoi2

578: SELECT --o1.NAME local_unit_name,
579: hoi2.org_information2 cfar_number
580: FROM hr_organization_units o1
581: , hr_organization_information hoi1
582: , hr_organization_information hoi2
583: WHERE o1.business_group_id = g_business_group_id
584: AND hoi1.organization_id = o1.organization_id
585: AND hoi1.organization_id = csr_v_local_unit_id
586: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 600: , hr_organization_information hoi1

596: hoi2.org_information2 Association_Number,
597: hl.meaning Agreement_Code,
598: hoi2.org_information4 Weekend_duty_pay
599: FROM hr_organization_units o1
600: , hr_organization_information hoi1
601: , hr_organization_information hoi2
602: ,hr_lookups hl
603: WHERE o1.business_group_id =csr_v_business_group_id --3133 --l_business_group_id
604: AND hoi1.organization_id = o1.organization_id

Line 601: , hr_organization_information hoi2

597: hl.meaning Agreement_Code,
598: hoi2.org_information4 Weekend_duty_pay
599: FROM hr_organization_units o1
600: , hr_organization_information hoi1
601: , hr_organization_information hoi2
602: ,hr_lookups hl
603: WHERE o1.business_group_id =csr_v_business_group_id --3133 --l_business_group_id
604: AND hoi1.organization_id = o1.organization_id
605: AND hoi1.organization_id = csr_v_legal_employer_id --3134 --csr_v_legal_unit_id

Line 618: , hr_organization_information hoi1

614: CURSOR csr_legal_employer(csr_v_business_group_id hr_organization_units.business_group_id%TYPE)
615: IS
616: SELECT o1.organization_id legal_employer_id
617: FROM hr_organization_units o1
618: , hr_organization_information hoi1
619: WHERE o1.business_group_id =csr_v_business_group_id --3133
620: AND hoi1.organization_id = o1.organization_id
621: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
622: AND hoi1.org_information_context = 'CLASS';

Line 632: , hr_organization_information hoi1

628: SELECT o1.name legal_employer,
629: hoi2.org_information2 Organization_Id,
630: hoi2.org_information9 Membership_Number
631: FROM hr_organization_units o1
632: , hr_organization_information hoi1
633: , hr_organization_information hoi2
634: WHERE o1.business_group_id =csr_v_business_group_id --3133 --l_business_group_id
635: AND hoi1.organization_id = o1.organization_id
636: AND hoi1.organization_id = csr_v_legal_employer_id --3134 --csr_v_legal_unit_id

Line 633: , hr_organization_information hoi2

629: hoi2.org_information2 Organization_Id,
630: hoi2.org_information9 Membership_Number
631: FROM hr_organization_units o1
632: , hr_organization_information hoi1
633: , hr_organization_information hoi2
634: WHERE o1.business_group_id =csr_v_business_group_id --3133 --l_business_group_id
635: AND hoi1.organization_id = o1.organization_id
636: AND hoi1.organization_id = csr_v_legal_employer_id --3134 --csr_v_legal_unit_id
637: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 649: , hr_organization_information hoi1

645: csr_v_legal_employer_id hr_organization_units.organization_id%TYPE)
646: IS
647: SELECT hoi2.ORG_INFORMATION1 local_unit
648: FROM hr_organization_units o1
649: , hr_organization_information hoi1
650: , hr_organization_information hoi2
651: WHERE o1.business_group_id =csr_v_business_group_id --3133 --l_business_group_id
652: AND hoi1.organization_id = o1.organization_id
653: AND hoi1.organization_id = csr_v_legal_employer_id --3134 --csr_v_legal_unit_id

Line 650: , hr_organization_information hoi2

646: IS
647: SELECT hoi2.ORG_INFORMATION1 local_unit
648: FROM hr_organization_units o1
649: , hr_organization_information hoi1
650: , hr_organization_information hoi2
651: WHERE o1.business_group_id =csr_v_business_group_id --3133 --l_business_group_id
652: AND hoi1.organization_id = o1.organization_id
653: AND hoi1.organization_id = csr_v_legal_employer_id --3134 --csr_v_legal_unit_id
654: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 2188: , hr_organization_information hoi1

2184: /* Bug Fix 6209364 */
2185: AND pai3.action_information9 IN (SELECT
2186: hl.meaning Agreement_Code
2187: FROM hr_organization_units o1
2188: , hr_organization_information hoi1
2189: ,hr_lookups hl
2190: WHERE o1.business_group_id =g_business_group_id
2191: AND hoi1.organization_id = o1.organization_id
2192: AND hoi1.organization_id =pai1.action_information3

Line 2248: , hr_organization_information hoi1

2244: hoi1.ORG_INFORMATION1 Working_Site_Number,
2245: hoi1.ORG_INFORMATION2 Association_Number,
2246: hoi1.ORG_INFORMATION4 Weekend_Pay_Duty
2247: FROM hr_organization_units o1
2248: , hr_organization_information hoi1
2249: ,hr_lookups hl
2250: WHERE o1.business_group_id =g_business_group_id --3133 --3133 --csr_v_business_group_id --3133 --l_business_group_id
2251: AND hoi1.organization_id = o1.organization_id
2252: AND hoi1.organization_id =csr_v_legal_employer --3134 --pai1.action_information3 --csr_v_legal_employer_id --3134 --csr_v_legal_unit_id