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
39: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
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
39: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
40: FROM PER_ALL_ASSIGNMENTS_F ASG
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
39: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
40: FROM PER_ALL_ASSIGNMENTS_F ASG
41: ,HR_SOFT_CODING_KEYFLEX SCL
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
39: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
40: FROM PER_ALL_ASSIGNMENTS_F ASG
41: ,HR_SOFT_CODING_KEYFLEX SCL
42: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
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
80: , (SELECT TRIM (scl.segment2) AS org_id
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
80: , (SELECT TRIM (scl.segment2) AS org_id
81: FROM per_all_assignments_f asg
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
80: , (SELECT TRIM (scl.segment2) AS org_id
81: FROM per_all_assignments_f asg
82: ,hr_soft_coding_keyflex scl
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
80: , (SELECT TRIM (scl.segment2) AS org_id
81: FROM per_all_assignments_f asg
82: ,hr_soft_coding_keyflex scl
83: WHERE asg.assignment_id = p_assignment_id
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
165: , (SELECT TRIM (scl.segment2) AS org_id
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
165: , (SELECT TRIM (scl.segment2) AS org_id
166: FROM per_all_assignments_f asg
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
165: , (SELECT TRIM (scl.segment2) AS org_id
166: FROM per_all_assignments_f asg
167: ,hr_soft_coding_keyflex scl
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
165: , (SELECT TRIM (scl.segment2) AS org_id
166: FROM per_all_assignments_f asg
167: ,hr_soft_coding_keyflex scl
168: WHERE asg.assignment_id = p_assignment_id
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
316: , (SELECT TRIM (scl.segment2) AS org_id
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
316: , (SELECT TRIM (scl.segment2) AS org_id
317: FROM per_all_assignments_f asg
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
316: , (SELECT TRIM (scl.segment2) AS org_id
317: FROM per_all_assignments_f asg
318: ,hr_soft_coding_keyflex scl
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
316: , (SELECT TRIM (scl.segment2) AS org_id
317: FROM per_all_assignments_f asg
318: ,hr_soft_coding_keyflex scl
319: WHERE asg.assignment_id = p_assignment_id
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
464: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
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
464: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
465: FROM PER_ALL_ASSIGNMENTS_F ASG
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
464: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
465: FROM PER_ALL_ASSIGNMENTS_F ASG
466: ,HR_SOFT_CODING_KEYFLEX SCL
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
464: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
465: FROM PER_ALL_ASSIGNMENTS_F ASG
466: ,HR_SOFT_CODING_KEYFLEX SCL
467: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
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
505: , (SELECT TRIM (scl.segment2) AS org_id
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
505: , (SELECT TRIM (scl.segment2) AS org_id
506: FROM per_all_assignments_f asg
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
505: , (SELECT TRIM (scl.segment2) AS org_id
506: FROM per_all_assignments_f asg
507: ,hr_soft_coding_keyflex scl
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
505: , (SELECT TRIM (scl.segment2) AS org_id
506: FROM per_all_assignments_f asg
507: ,hr_soft_coding_keyflex scl
508: WHERE asg.assignment_id = p_assignment_id
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
589: , (SELECT TRIM (scl.segment2) AS org_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
589: , (SELECT TRIM (scl.segment2) AS org_id
590: FROM per_all_assignments_f asg
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
589: , (SELECT TRIM (scl.segment2) AS org_id
590: FROM per_all_assignments_f asg
591: ,hr_soft_coding_keyflex scl
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
589: , (SELECT TRIM (scl.segment2) AS org_id
590: FROM per_all_assignments_f asg
591: ,hr_soft_coding_keyflex scl
592: WHERE asg.assignment_id = p_assignment_id
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
887: , (SELECT TRIM (scl.segment2) AS org_id
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
887: , (SELECT TRIM (scl.segment2) AS org_id
888: FROM per_all_assignments_f asg
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
887: , (SELECT TRIM (scl.segment2) AS org_id
888: FROM per_all_assignments_f asg
889: ,hr_soft_coding_keyflex scl
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
887: , (SELECT TRIM (scl.segment2) AS org_id
888: FROM per_all_assignments_f asg
889: ,hr_soft_coding_keyflex scl
890: WHERE asg.assignment_id = p_assignment_id
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
1126: , (SELECT TRIM (scl.segment2) AS org_id
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
1126: , (SELECT TRIM (scl.segment2) AS org_id
1127: FROM per_all_assignments_f asg
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
1126: , (SELECT TRIM (scl.segment2) AS org_id
1127: FROM per_all_assignments_f asg
1128: ,hr_soft_coding_keyflex scl
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
1126: , (SELECT TRIM (scl.segment2) AS org_id
1127: FROM per_all_assignments_f asg
1128: ,hr_soft_coding_keyflex scl
1129: WHERE asg.assignment_id = p_assignment_id
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
1170: , (SELECT TRIM (scl.segment2) AS org_id
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
1170: , (SELECT TRIM (scl.segment2) AS org_id
1171: FROM per_all_assignments_f asg
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
1170: , (SELECT TRIM (scl.segment2) AS org_id
1171: FROM per_all_assignments_f asg
1172: ,hr_soft_coding_keyflex scl
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
1170: , (SELECT TRIM (scl.segment2) AS org_id
1171: FROM per_all_assignments_f asg
1172: ,hr_soft_coding_keyflex scl
1173: WHERE asg.assignment_id = p_assignment_id
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
1274: AND hoi1.org_information_context = 'CLASS'
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
1274: AND hoi1.org_information_context = 'CLASS'
1275: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
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
1344: AND hoi1.org_information_context = 'CLASS'
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
1344: AND hoi1.org_information_context = 'CLASS'
1345: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
1503: FUNCTION update_entitlement_ran (p_tax_unit_id IN NUMBER)
1504: RETURN NUMBER
1505: IS
1506: BEGIN
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
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
1516: AND hoi1.org_information_context = 'CLASS'
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
1516: AND hoi1.org_information_context = 'CLASS'
1517: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
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
1557: AND hoi1.org_information_context = 'CLASS'
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
1557: AND hoi1.org_information_context = 'CLASS'
1558: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
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
1749: , (SELECT TRIM (scl.segment2) AS org_id
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
1749: , (SELECT TRIM (scl.segment2) AS org_id
1750: FROM per_all_assignments_f asg
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
1749: , (SELECT TRIM (scl.segment2) AS org_id
1750: FROM per_all_assignments_f asg
1751: ,hr_soft_coding_keyflex scl
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
1749: , (SELECT TRIM (scl.segment2) AS org_id
1750: FROM per_all_assignments_f asg
1751: ,hr_soft_coding_keyflex scl
1752: WHERE asg.assignment_id = p_assignment_id
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
1780: AND hoi1.org_information_context = 'CLASS'
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
1780: AND hoi1.org_information_context = 'CLASS'
1781: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
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
1821: , (SELECT TRIM (scl.segment2) AS org_id
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
1821: , (SELECT TRIM (scl.segment2) AS org_id
1822: FROM per_all_assignments_f asg
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
1821: , (SELECT TRIM (scl.segment2) AS org_id
1822: FROM per_all_assignments_f asg
1823: ,hr_soft_coding_keyflex scl
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
1821: , (SELECT TRIM (scl.segment2) AS org_id
1822: FROM per_all_assignments_f asg
1823: ,hr_soft_coding_keyflex scl
1824: WHERE asg.assignment_id = p_assignment_id
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
2033: , (SELECT TRIM (scl.segment2) AS org_id
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
2033: , (SELECT TRIM (scl.segment2) AS org_id
2034: FROM per_all_assignments_f asg
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
2033: , (SELECT TRIM (scl.segment2) AS org_id
2034: FROM per_all_assignments_f asg
2035: ,hr_soft_coding_keyflex scl
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
2033: , (SELECT TRIM (scl.segment2) AS org_id
2034: FROM per_all_assignments_f asg
2035: ,hr_soft_coding_keyflex scl
2036: WHERE asg.assignment_id = p_assignment_id
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
2064: AND hoi1.org_information_context = 'CLASS'
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
2064: AND hoi1.org_information_context = 'CLASS'
2065: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
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
2105: , (SELECT TRIM (scl.segment2) AS org_id
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
2105: , (SELECT TRIM (scl.segment2) AS org_id
2106: FROM per_all_assignments_f asg
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
2105: , (SELECT TRIM (scl.segment2) AS org_id
2106: FROM per_all_assignments_f asg
2107: ,hr_soft_coding_keyflex scl
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
2105: , (SELECT TRIM (scl.segment2) AS org_id
2106: FROM per_all_assignments_f asg
2107: ,hr_soft_coding_keyflex scl
2108: WHERE asg.assignment_id = p_assignment_id
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
2270: AND hoi3.organization_id = p_tax_unit_id
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
2270: AND hoi3.organization_id = p_tax_unit_id
2271: AND hoi3.org_information_context = 'CLASS'
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
2426: AND hoi3.organization_id = p_tax_unit_id
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
2426: AND hoi3.organization_id = p_tax_unit_id
2427: AND hoi3.org_information_context = 'CLASS'
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
2542: AND hoi3.organization_id = p_tax_unit_id
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
2542: AND hoi3.organization_id = p_tax_unit_id
2543: AND hoi3.org_information_context = 'CLASS'
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
2599: AND hoi3.organization_id = p_tax_unit_id
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
2599: AND hoi3.organization_id = p_tax_unit_id
2600: AND hoi3.org_information_context = 'CLASS'
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
2785: AND hoi1.org_information_context = 'CLASS'
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
2785: AND hoi1.org_information_context = 'CLASS'
2786: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
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
2863: AND hoi3.organization_id = p_tax_unit_id
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
2863: AND hoi3.organization_id = p_tax_unit_id
2864: AND hoi3.org_information_context = 'CLASS'
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
3024: AND hoi3.organization_id = p_tax_unit_id
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
3024: AND hoi3.organization_id = p_tax_unit_id
3025: AND hoi3.org_information_context = 'CLASS'
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
3254: AND hoi3.organization_id = p_tax_unit_id
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
3254: AND hoi3.organization_id = p_tax_unit_id
3255: AND hoi3.org_information_context = 'CLASS'
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
3609: AND hoi1.org_information_context = 'CLASS'
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
3609: AND hoi1.org_information_context = 'CLASS'
3610: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'