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_HOLIDAY_PAY dependencies on HR_ORGANIZATION_UNITS

Line 34: FROM HR_ORGANIZATION_UNITS o1

30: l_assignment_start DATE;
31:
32: /*Cursor csr_Earning_Year is
33: SELECT substr(hoi4.ORG_INFORMATION1,4,2),substr(hoi4.ORG_INFORMATION2,4,2)
34: FROM HR_ORGANIZATION_UNITS o1
35: ,HR_ORGANIZATION_INFORMATION hoi1
36: ,HR_ORGANIZATION_INFORMATION hoi2
37: ,HR_ORGANIZATION_INFORMATION hoi3
38: ,HR_ORGANIZATION_INFORMATION hoi4

Line 75: FROM hr_organization_units o1

71:
72: CURSOR csr_legal_employer_entitlement
73: IS
74: SELECT hoi4.org_information1
75: FROM hr_organization_units o1
76: ,hr_organization_information hoi1
77: ,hr_organization_information hoi2
78: ,hr_organization_information hoi3
79: ,hr_organization_information hoi4

Line 160: FROM hr_organization_units o1

156: CURSOR csr_earning_year
157: IS
158: SELECT SUBSTR (hoi4.org_information1, 4, 2)
159: ,SUBSTR (hoi4.org_information2, 4, 2)
160: FROM hr_organization_units o1
161: ,hr_organization_information hoi1
162: ,hr_organization_information hoi2
163: ,hr_organization_information hoi3
164: ,hr_organization_information hoi4

Line 311: FROM hr_organization_units o1

307: CURSOR csr_earning_year
308: IS
309: SELECT SUBSTR (hoi4.org_information1, 4, 2)
310: ,SUBSTR (hoi4.org_information2, 4, 2)
311: FROM hr_organization_units o1
312: ,hr_organization_information hoi1
313: ,hr_organization_information hoi2
314: ,hr_organization_information hoi3
315: ,hr_organization_information hoi4

Line 459: FROM HR_ORGANIZATION_UNITS o1

455: l_days NUMBER;
456:
457: /*Cursor csr_Earning_Year is
458: SELECT substr(hoi4.ORG_INFORMATION1,4,2),substr(hoi4.ORG_INFORMATION2,4,2)
459: FROM HR_ORGANIZATION_UNITS o1
460: ,HR_ORGANIZATION_INFORMATION hoi1
461: ,HR_ORGANIZATION_INFORMATION hoi2
462: ,HR_ORGANIZATION_INFORMATION hoi3
463: ,HR_ORGANIZATION_INFORMATION hoi4

Line 500: FROM hr_organization_units o1

496:
497: CURSOR csr_legal_employer_entitlement
498: IS
499: SELECT hoi4.org_information1
500: FROM hr_organization_units o1
501: ,hr_organization_information hoi1
502: ,hr_organization_information hoi2
503: ,hr_organization_information hoi3
504: ,hr_organization_information hoi4

Line 584: FROM hr_organization_units o1

580: FROM PER_ABSENCE_ATTENDANCE_TYPES
581: WHERE ABSENCE_ATTENDANCE_TYPE_ID=csr_v_absence_type_id;*/
582: SELECT hoi4.org_information2
583: ,hoi4.org_information3
584: FROM hr_organization_units o1
585: ,hr_organization_information hoi1
586: ,hr_organization_information hoi2
587: ,hr_organization_information hoi3
588: ,hr_organization_information hoi4

Line 882: FROM hr_organization_units o1

878:
879: CURSOR csr_legal_employer_entitlement
880: IS
881: SELECT hoi4.org_information1
882: FROM hr_organization_units o1
883: ,hr_organization_information hoi1
884: ,hr_organization_information hoi2
885: ,hr_organization_information hoi3
886: ,hr_organization_information hoi4

Line 1121: FROM hr_organization_units o1

1117:
1118: CURSOR csr_legal_employer_limit
1119: IS
1120: SELECT hoi4.org_information3
1121: FROM hr_organization_units o1
1122: ,hr_organization_information hoi1
1123: ,hr_organization_information hoi2
1124: ,hr_organization_information hoi3
1125: ,hr_organization_information hoi4

Line 1165: FROM hr_organization_units o1

1161:
1162: CURSOR csr_legal_employer_entitlement
1163: IS
1164: SELECT hoi4.org_information1
1165: FROM hr_organization_units o1
1166: ,hr_organization_information hoi1
1167: ,hr_organization_information hoi2
1168: ,hr_organization_information hoi3
1169: ,hr_organization_information hoi4

Line 1269: FROM hr_organization_units o1

1265: CURSOR csr_earning_year
1266: IS
1267: SELECT SUBSTR (hoi2.org_information1, 4, 2)
1268: ,SUBSTR (hoi2.org_information2, 4, 2)
1269: FROM hr_organization_units o1
1270: ,hr_organization_information hoi1
1271: ,hr_organization_information hoi2
1272: WHERE hoi1.organization_id = o1.organization_id
1273: AND hoi1.organization_id = p_tax_unit_id --3134

Line 1339: FROM hr_organization_units o1

1335: CURSOR csr_earning_year
1336: IS
1337: SELECT SUBSTR (hoi2.org_information1, 4, 2)
1338: ,SUBSTR (hoi2.org_information2, 4, 2)
1339: FROM hr_organization_units o1
1340: ,hr_organization_information hoi1
1341: ,hr_organization_information hoi2
1342: WHERE hoi1.organization_id = o1.organization_id
1343: AND hoi1.organization_id = p_tax_unit_id --3134

Line 1511: FROM hr_organization_units o1

1507: UPDATE hr_organization_information
1508: SET org_information5 = 'Y'
1509: WHERE org_information_id =
1510: (SELECT hoi2.org_information_id
1511: FROM hr_organization_units o1
1512: ,hr_organization_information hoi1
1513: ,hr_organization_information hoi2
1514: WHERE hoi1.organization_id = o1.organization_id
1515: AND hoi1.organization_id = p_tax_unit_id --3134

Line 1552: FROM hr_organization_units o1

1548: CURSOR csr_earning_year
1549: IS
1550: SELECT SUBSTR (hoi2.org_information1, 4, 2)
1551: ,SUBSTR (hoi2.org_information2, 4, 2)
1552: FROM hr_organization_units o1
1553: ,hr_organization_information hoi1
1554: ,hr_organization_information hoi2
1555: WHERE hoi1.organization_id = o1.organization_id
1556: AND hoi1.organization_id = p_tax_unit_id

Line 1744: FROM hr_organization_units o1

1740: CURSOR csr_generate_max_days
1741: IS
1742: SELECT hoi4.org_information2
1743: ,hoi4.org_information3
1744: FROM hr_organization_units o1
1745: ,hr_organization_information hoi1
1746: ,hr_organization_information hoi2
1747: ,hr_organization_information hoi3
1748: ,hr_organization_information hoi4

Line 1775: FROM hr_organization_units o1

1771:
1772: CURSOR csr_earning_year
1773: IS
1774: SELECT SUBSTR (hoi2.org_information2, 4, 2)
1775: FROM hr_organization_units o1
1776: ,hr_organization_information hoi1
1777: ,hr_organization_information hoi2
1778: WHERE hoi1.organization_id = o1.organization_id
1779: AND hoi1.organization_id = p_tax_unit_id

Line 1816: FROM hr_organization_units o1

1812:
1813: CURSOR csr_legal_employer_entitlement
1814: IS
1815: SELECT hoi4.org_information1
1816: FROM hr_organization_units o1
1817: ,hr_organization_information hoi1
1818: ,hr_organization_information hoi2
1819: ,hr_organization_information hoi3
1820: ,hr_organization_information hoi4

Line 2028: FROM hr_organization_units o1

2024: CURSOR csr_generate_max_days
2025: IS
2026: SELECT hoi4.org_information2
2027: ,hoi4.org_information3
2028: FROM hr_organization_units o1
2029: ,hr_organization_information hoi1
2030: ,hr_organization_information hoi2
2031: ,hr_organization_information hoi3
2032: ,hr_organization_information hoi4

Line 2059: FROM hr_organization_units o1

2055:
2056: CURSOR csr_earning_year
2057: IS
2058: SELECT SUBSTR (hoi2.org_information2, 4, 2)
2059: FROM hr_organization_units o1
2060: ,hr_organization_information hoi1
2061: ,hr_organization_information hoi2
2062: WHERE hoi1.organization_id = o1.organization_id
2063: AND hoi1.organization_id = p_tax_unit_id

Line 2100: FROM hr_organization_units o1

2096:
2097: CURSOR csr_legal_employer_entitlement
2098: IS
2099: SELECT hoi4.org_information1
2100: FROM hr_organization_units o1
2101: ,hr_organization_information hoi1
2102: ,hr_organization_information hoi2
2103: ,hr_organization_information hoi3
2104: ,hr_organization_information hoi4

Line 2265: FROM hr_organization_units o1

2261: CURSOR csr_earning_year
2262: IS
2263: SELECT SUBSTR (hoi4.org_information1, 4, 2)
2264: ,SUBSTR (hoi4.org_information2, 4, 2)
2265: FROM hr_organization_units o1
2266: ,hr_organization_information hoi3
2267: ,hr_organization_information hoi4
2268: WHERE o1.business_group_id = l_business_group_id
2269: AND o1.organization_id = hoi3.organization_id

Line 2421: FROM hr_organization_units o1

2417:
2418: CURSOR csr_legal_employer_entitlement
2419: IS
2420: SELECT hoi4.org_information1
2421: FROM hr_organization_units o1
2422: ,hr_organization_information hoi3
2423: ,hr_organization_information hoi4
2424: WHERE o1.business_group_id = l_business_group_id
2425: AND o1.organization_id = hoi3.organization_id

Line 2537: FROM hr_organization_units o1

2533:
2534: CURSOR csr_legal_employer_entitlement
2535: IS
2536: SELECT hoi4.org_information1
2537: FROM hr_organization_units o1
2538: ,hr_organization_information hoi3
2539: ,hr_organization_information hoi4
2540: WHERE o1.business_group_id = l_business_group_id
2541: AND o1.organization_id = hoi3.organization_id

Line 2594: FROM hr_organization_units o1

2590: CURSOR csr_generate_max_days
2591: IS
2592: SELECT hoi4.org_information2
2593: ,hoi4.org_information3
2594: FROM hr_organization_units o1
2595: ,hr_organization_information hoi3
2596: ,hr_organization_information hoi4
2597: WHERE o1.business_group_id = l_business_group_id
2598: AND hoi3.organization_id = o1.organization_id

Line 2780: FROM hr_organization_units o1

2776: CURSOR csr_earning_year
2777: IS
2778: SELECT SUBSTR (hoi2.org_information1, 4, 2)
2779: ,SUBSTR (hoi2.org_information2, 4, 2)
2780: FROM hr_organization_units o1
2781: ,hr_organization_information hoi1
2782: ,hr_organization_information hoi2
2783: WHERE hoi1.organization_id = o1.organization_id
2784: AND hoi1.organization_id = p_tax_unit_id --3134

Line 2858: FROM hr_organization_units o1

2854:
2855: CURSOR csr_get_concidental
2856: IS
2857: SELECT hoi4.org_information6
2858: FROM hr_organization_units o1
2859: ,hr_organization_information hoi3
2860: ,hr_organization_information hoi4
2861: WHERE o1.business_group_id = p_business_group_id
2862: AND o1.organization_id = hoi3.organization_id

Line 3019: FROM hr_organization_units o1

3015: CURSOR csr_earning_year
3016: IS
3017: SELECT SUBSTR (hoi4.org_information1, 4, 2)
3018: ,SUBSTR (hoi4.org_information2, 4, 2)
3019: FROM hr_organization_units o1
3020: ,hr_organization_information hoi3
3021: ,hr_organization_information hoi4
3022: WHERE o1.business_group_id = l_business_group_id
3023: AND o1.organization_id = hoi3.organization_id

Line 3249: FROM hr_organization_units o1

3245:
3246: CURSOR csr_legal_employer_entitlement
3247: IS
3248: SELECT hoi4.org_information2
3249: FROM hr_organization_units o1
3250: ,hr_organization_information hoi3
3251: ,hr_organization_information hoi4
3252: WHERE o1.business_group_id = p_business_group_id
3253: AND o1.organization_id = hoi3.organization_id

Line 3604: FROM hr_organization_units o1

3600: CURSOR csr_earning_year
3601: IS
3602: SELECT SUBSTR (hoi2.org_information1, 4, 2)
3603: ,SUBSTR (hoi2.org_information2, 4, 2)
3604: FROM hr_organization_units o1
3605: ,hr_organization_information hoi1
3606: ,hr_organization_information hoi2
3607: WHERE hoi1.organization_id = o1.organization_id
3608: AND hoi1.organization_id = p_tax_unit_id --3134