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

Line 280: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

276: l_element_context VARCHAR2 (5);
277:
278: -- Archiving the data , as this will fire once
279: CURSOR csr_legal_employer_details (
280: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
281: )
282: IS
283: SELECT o1.NAME legal_employer_name
284: ,hoi2.org_information2 org_number

Line 287: ,hr_organization_information hoi1

283: SELECT o1.NAME legal_employer_name
284: ,hoi2.org_information2 org_number
285: ,hoi1.organization_id legal_id
286: FROM hr_organization_units o1
287: ,hr_organization_information hoi1
288: ,hr_organization_information hoi2
289: WHERE o1.business_group_id = g_business_group_id
290: AND hoi1.organization_id = o1.organization_id
291: AND hoi1.organization_id =

Line 288: ,hr_organization_information hoi2

284: ,hoi2.org_information2 org_number
285: ,hoi1.organization_id legal_id
286: FROM hr_organization_units o1
287: ,hr_organization_information hoi1
288: ,hr_organization_information hoi2
289: WHERE o1.business_group_id = g_business_group_id
290: AND hoi1.organization_id = o1.organization_id
291: AND hoi1.organization_id =
292: NVL (csr_v_legal_employer_id, hoi1.organization_id)

Line 546: l_pension_type hr_organization_information.org_information1%TYPE;

542: l_count NUMBER := 0;
543: l_prev_prepay NUMBER := 0;
544: l_canonical_start_date DATE;
545: l_canonical_end_date DATE;
546: l_pension_type hr_organization_information.org_information1%TYPE;
547: l_prepay_action_id NUMBER;
548: l_actid NUMBER;
549: l_assignment_id NUMBER;
550: l_action_sequence NUMBER;

Line 680: ,hr_organization_information hoi1

676: CURSOR csr_get_all_legal_employer_id
677: IS
678: SELECT o.organization_id
679: FROM hr_all_organization_units o
680: ,hr_organization_information hoi1
681: WHERE o.business_group_id = g_business_group_id
682: AND hoi1.organization_id = o.organization_id
683: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
684: AND hoi1.org_information_context = 'CLASS'

Line 737: ,hr_organization_information hoi1

733: ,hoi3.org_information6
734: ,hoi3.org_information7
735: ,hoi3.org_information8
736: FROM hr_all_organization_units o
737: ,hr_organization_information hoi1
738: ,hr_organization_information hoi3
739: WHERE o.business_group_id = g_business_group_id
740: AND hoi1.organization_id = o.organization_id
741: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 738: ,hr_organization_information hoi3

734: ,hoi3.org_information7
735: ,hoi3.org_information8
736: FROM hr_all_organization_units o
737: ,hr_organization_information hoi1
738: ,hr_organization_information hoi3
739: WHERE o.business_group_id = g_business_group_id
740: AND hoi1.organization_id = o.organization_id
741: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
742: AND hoi1.org_information_context = 'CLASS'

Line 1107: csr_v_organization_id hr_organization_information.organization_id%TYPE

1103: lr_get_segment2 csr_get_segment2%ROWTYPE;
1104:
1105: -- Cursor to pick up LEGAL EMPLOYER
1106: CURSOR csr_find_legal_employer (
1107: csr_v_organization_id hr_organization_information.organization_id%TYPE
1108: )
1109: IS
1110: SELECT hoi3.organization_id legal_id
1111: FROM hr_all_organization_units o1

Line 1112: ,hr_organization_information hoi1

1108: )
1109: IS
1110: SELECT hoi3.organization_id legal_id
1111: FROM hr_all_organization_units o1
1112: ,hr_organization_information hoi1
1113: ,hr_organization_information hoi2
1114: ,hr_organization_information hoi3
1115: WHERE o1.business_group_id = g_business_group_id
1116: AND hoi1.organization_id = o1.organization_id

Line 1113: ,hr_organization_information hoi2

1109: IS
1110: SELECT hoi3.organization_id legal_id
1111: FROM hr_all_organization_units o1
1112: ,hr_organization_information hoi1
1113: ,hr_organization_information hoi2
1114: ,hr_organization_information hoi3
1115: WHERE o1.business_group_id = g_business_group_id
1116: AND hoi1.organization_id = o1.organization_id
1117: AND hoi1.organization_id = csr_v_organization_id

Line 1114: ,hr_organization_information hoi3

1110: SELECT hoi3.organization_id legal_id
1111: FROM hr_all_organization_units o1
1112: ,hr_organization_information hoi1
1113: ,hr_organization_information hoi2
1114: ,hr_organization_information hoi3
1115: WHERE o1.business_group_id = g_business_group_id
1116: AND hoi1.organization_id = o1.organization_id
1117: AND hoi1.organization_id = csr_v_organization_id
1118: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1130: csr_v_local_unit_id hr_organization_information.organization_id%TYPE

1126: lr_find_legal_employer csr_find_legal_employer%ROWTYPE;
1127:
1128: -- Cursor to pick up Local Unit Details
1129: CURSOR csr_local_unit_details (
1130: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
1131: )
1132: IS
1133: SELECT o1.NAME
1134: ,hoi2.org_information1

Line 1136: ,hr_organization_information hoi1

1132: IS
1133: SELECT o1.NAME
1134: ,hoi2.org_information1
1135: FROM hr_organization_units o1
1136: ,hr_organization_information hoi1
1137: ,hr_organization_information hoi2
1138: WHERE o1.business_group_id = g_business_group_id
1139: AND hoi1.organization_id = o1.organization_id
1140: AND hoi1.organization_id = csr_v_local_unit_id

Line 1137: ,hr_organization_information hoi2

1133: SELECT o1.NAME
1134: ,hoi2.org_information1
1135: FROM hr_organization_units o1
1136: ,hr_organization_information hoi1
1137: ,hr_organization_information hoi2
1138: WHERE o1.business_group_id = g_business_group_id
1139: AND hoi1.organization_id = o1.organization_id
1140: AND hoi1.organization_id = csr_v_local_unit_id
1141: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 2947: csr_v_organization_id hr_organization_information.organization_id%TYPE

2943: lr_get_details csr_get_details%ROWTYPE;
2944:
2945: -- Cursor to pick up LEGAL EMPLOYER
2946: CURSOR csr_find_legal_employer (
2947: csr_v_organization_id hr_organization_information.organization_id%TYPE
2948: )
2949: IS
2950: SELECT hoi3.organization_id legal_id
2951: FROM hr_all_organization_units o1

Line 2952: ,hr_organization_information hoi1

2948: )
2949: IS
2950: SELECT hoi3.organization_id legal_id
2951: FROM hr_all_organization_units o1
2952: ,hr_organization_information hoi1
2953: ,hr_organization_information hoi2
2954: ,hr_organization_information hoi3
2955: WHERE o1.business_group_id = g_business_group_id
2956: AND hoi1.organization_id = o1.organization_id

Line 2953: ,hr_organization_information hoi2

2949: IS
2950: SELECT hoi3.organization_id legal_id
2951: FROM hr_all_organization_units o1
2952: ,hr_organization_information hoi1
2953: ,hr_organization_information hoi2
2954: ,hr_organization_information hoi3
2955: WHERE o1.business_group_id = g_business_group_id
2956: AND hoi1.organization_id = o1.organization_id
2957: AND hoi1.organization_id = csr_v_organization_id

Line 2954: ,hr_organization_information hoi3

2950: SELECT hoi3.organization_id legal_id
2951: FROM hr_all_organization_units o1
2952: ,hr_organization_information hoi1
2953: ,hr_organization_information hoi2
2954: ,hr_organization_information hoi3
2955: WHERE o1.business_group_id = g_business_group_id
2956: AND hoi1.organization_id = o1.organization_id
2957: AND hoi1.organization_id = csr_v_organization_id
2958: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 2969: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

2965:
2966: lr_find_legal_employer csr_find_legal_employer%ROWTYPE;
2967:
2968: CURSOR csr_legal_employer_details (
2969: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
2970: )
2971: IS
2972: SELECT o1.NAME legal_employer_name
2973: ,hoi2.org_information2 org_number

Line 2976: ,hr_organization_information hoi1

2972: SELECT o1.NAME legal_employer_name
2973: ,hoi2.org_information2 org_number
2974: ,hoi1.organization_id legal_id
2975: FROM hr_organization_units o1
2976: ,hr_organization_information hoi1
2977: ,hr_organization_information hoi2
2978: WHERE o1.business_group_id = g_business_group_id
2979: AND hoi1.organization_id = o1.organization_id
2980: AND hoi1.organization_id = csr_v_legal_employer_id

Line 2977: ,hr_organization_information hoi2

2973: ,hoi2.org_information2 org_number
2974: ,hoi1.organization_id legal_id
2975: FROM hr_organization_units o1
2976: ,hr_organization_information hoi1
2977: ,hr_organization_information hoi2
2978: WHERE o1.business_group_id = g_business_group_id
2979: AND hoi1.organization_id = o1.organization_id
2980: AND hoi1.organization_id = csr_v_legal_employer_id
2981: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 3208: csr_v_organization_id hr_organization_information.organization_id%TYPE

3204: lr_get_details csr_get_details%ROWTYPE;
3205:
3206: -- Cursor to pick up LEGAL EMPLOYER
3207: CURSOR csr_find_legal_employer (
3208: csr_v_organization_id hr_organization_information.organization_id%TYPE
3209: )
3210: IS
3211: SELECT hoi3.organization_id legal_id
3212: FROM hr_all_organization_units o1

Line 3213: ,hr_organization_information hoi1

3209: )
3210: IS
3211: SELECT hoi3.organization_id legal_id
3212: FROM hr_all_organization_units o1
3213: ,hr_organization_information hoi1
3214: ,hr_organization_information hoi2
3215: ,hr_organization_information hoi3
3216: WHERE o1.business_group_id = g_business_group_id
3217: AND hoi1.organization_id = o1.organization_id

Line 3214: ,hr_organization_information hoi2

3210: IS
3211: SELECT hoi3.organization_id legal_id
3212: FROM hr_all_organization_units o1
3213: ,hr_organization_information hoi1
3214: ,hr_organization_information hoi2
3215: ,hr_organization_information hoi3
3216: WHERE o1.business_group_id = g_business_group_id
3217: AND hoi1.organization_id = o1.organization_id
3218: AND hoi1.organization_id = csr_v_organization_id

Line 3215: ,hr_organization_information hoi3

3211: SELECT hoi3.organization_id legal_id
3212: FROM hr_all_organization_units o1
3213: ,hr_organization_information hoi1
3214: ,hr_organization_information hoi2
3215: ,hr_organization_information hoi3
3216: WHERE o1.business_group_id = g_business_group_id
3217: AND hoi1.organization_id = o1.organization_id
3218: AND hoi1.organization_id = csr_v_organization_id
3219: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'