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 240: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

236: l_element_context VARCHAR2 (5);
237:
238: -- Archiving the data , as this will fire once
239: CURSOR csr_legal_employer_details (
240: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
241: )
242: IS
243: SELECT o1.NAME legal_employer_name
244: ,hoi2.org_information2 org_number

Line 247: ,hr_organization_information hoi1

243: SELECT o1.NAME legal_employer_name
244: ,hoi2.org_information2 org_number
245: ,hoi1.organization_id legal_id
246: FROM hr_organization_units o1
247: ,hr_organization_information hoi1
248: ,hr_organization_information hoi2
249: WHERE o1.business_group_id = g_business_group_id
250: AND hoi1.organization_id = o1.organization_id
251: AND hoi1.organization_id =

Line 248: ,hr_organization_information hoi2

244: ,hoi2.org_information2 org_number
245: ,hoi1.organization_id legal_id
246: FROM hr_organization_units o1
247: ,hr_organization_information hoi1
248: ,hr_organization_information hoi2
249: WHERE o1.business_group_id = g_business_group_id
250: AND hoi1.organization_id = o1.organization_id
251: AND hoi1.organization_id =
252: NVL (csr_v_legal_employer_id, hoi1.organization_id)

Line 506: l_pension_type hr_organization_information.org_information1%TYPE;

502: l_count NUMBER := 0;
503: l_prev_prepay NUMBER := 0;
504: l_canonical_start_date DATE;
505: l_canonical_end_date DATE;
506: l_pension_type hr_organization_information.org_information1%TYPE;
507: l_prepay_action_id NUMBER;
508: l_actid NUMBER;
509: l_assignment_id NUMBER;
510: l_action_sequence NUMBER;

Line 640: ,hr_organization_information hoi1

636: CURSOR csr_get_all_legal_employer_id
637: IS
638: SELECT o.organization_id
639: FROM hr_all_organization_units o
640: ,hr_organization_information hoi1
641: WHERE o.business_group_id = g_business_group_id
642: AND hoi1.organization_id = o.organization_id
643: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
644: AND hoi1.org_information_context = 'CLASS'

Line 697: ,hr_organization_information hoi1

693: ,hoi3.org_information6
694: ,hoi3.org_information7
695: ,hoi3.org_information8
696: FROM hr_all_organization_units o
697: ,hr_organization_information hoi1
698: ,hr_organization_information hoi3
699: WHERE o.business_group_id = g_business_group_id
700: AND hoi1.organization_id = o.organization_id
701: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 698: ,hr_organization_information hoi3

694: ,hoi3.org_information7
695: ,hoi3.org_information8
696: FROM hr_all_organization_units o
697: ,hr_organization_information hoi1
698: ,hr_organization_information hoi3
699: WHERE o.business_group_id = g_business_group_id
700: AND hoi1.organization_id = o.organization_id
701: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
702: AND hoi1.org_information_context = 'CLASS'

Line 1060: csr_v_organization_id hr_organization_information.organization_id%TYPE

1056: lr_get_segment2 csr_get_segment2%ROWTYPE;
1057:
1058: -- Cursor to pick up LEGAL EMPLOYER
1059: CURSOR csr_find_legal_employer (
1060: csr_v_organization_id hr_organization_information.organization_id%TYPE
1061: )
1062: IS
1063: SELECT hoi3.organization_id legal_id
1064: FROM hr_all_organization_units o1

Line 1065: ,hr_organization_information hoi1

1061: )
1062: IS
1063: SELECT hoi3.organization_id legal_id
1064: FROM hr_all_organization_units o1
1065: ,hr_organization_information hoi1
1066: ,hr_organization_information hoi2
1067: ,hr_organization_information hoi3
1068: WHERE o1.business_group_id = g_business_group_id
1069: AND hoi1.organization_id = o1.organization_id

Line 1066: ,hr_organization_information hoi2

1062: IS
1063: SELECT hoi3.organization_id legal_id
1064: FROM hr_all_organization_units o1
1065: ,hr_organization_information hoi1
1066: ,hr_organization_information hoi2
1067: ,hr_organization_information hoi3
1068: WHERE o1.business_group_id = g_business_group_id
1069: AND hoi1.organization_id = o1.organization_id
1070: AND hoi1.organization_id = csr_v_organization_id

Line 1067: ,hr_organization_information hoi3

1063: SELECT hoi3.organization_id legal_id
1064: FROM hr_all_organization_units o1
1065: ,hr_organization_information hoi1
1066: ,hr_organization_information hoi2
1067: ,hr_organization_information hoi3
1068: WHERE o1.business_group_id = g_business_group_id
1069: AND hoi1.organization_id = o1.organization_id
1070: AND hoi1.organization_id = csr_v_organization_id
1071: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1083: csr_v_local_unit_id hr_organization_information.organization_id%TYPE

1079: lr_find_legal_employer csr_find_legal_employer%ROWTYPE;
1080:
1081: -- Cursor to pick up Local Unit Details
1082: CURSOR csr_local_unit_details (
1083: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
1084: )
1085: IS
1086: SELECT o1.NAME
1087: ,hoi2.org_information1

Line 1089: ,hr_organization_information hoi1

1085: IS
1086: SELECT o1.NAME
1087: ,hoi2.org_information1
1088: FROM hr_organization_units o1
1089: ,hr_organization_information hoi1
1090: ,hr_organization_information hoi2
1091: WHERE o1.business_group_id = g_business_group_id
1092: AND hoi1.organization_id = o1.organization_id
1093: AND hoi1.organization_id = csr_v_local_unit_id

Line 1090: ,hr_organization_information hoi2

1086: SELECT o1.NAME
1087: ,hoi2.org_information1
1088: FROM hr_organization_units o1
1089: ,hr_organization_information hoi1
1090: ,hr_organization_information hoi2
1091: WHERE o1.business_group_id = g_business_group_id
1092: AND hoi1.organization_id = o1.organization_id
1093: AND hoi1.organization_id = csr_v_local_unit_id
1094: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 2519: csr_v_organization_id hr_organization_information.organization_id%TYPE

2515: lr_get_details csr_get_details%ROWTYPE;
2516:
2517: -- Cursor to pick up LEGAL EMPLOYER
2518: CURSOR csr_find_legal_employer (
2519: csr_v_organization_id hr_organization_information.organization_id%TYPE
2520: )
2521: IS
2522: SELECT hoi3.organization_id legal_id
2523: FROM hr_all_organization_units o1

Line 2524: ,hr_organization_information hoi1

2520: )
2521: IS
2522: SELECT hoi3.organization_id legal_id
2523: FROM hr_all_organization_units o1
2524: ,hr_organization_information hoi1
2525: ,hr_organization_information hoi2
2526: ,hr_organization_information hoi3
2527: WHERE o1.business_group_id = g_business_group_id
2528: AND hoi1.organization_id = o1.organization_id

Line 2525: ,hr_organization_information hoi2

2521: IS
2522: SELECT hoi3.organization_id legal_id
2523: FROM hr_all_organization_units o1
2524: ,hr_organization_information hoi1
2525: ,hr_organization_information hoi2
2526: ,hr_organization_information hoi3
2527: WHERE o1.business_group_id = g_business_group_id
2528: AND hoi1.organization_id = o1.organization_id
2529: AND hoi1.organization_id = csr_v_organization_id

Line 2526: ,hr_organization_information hoi3

2522: SELECT hoi3.organization_id legal_id
2523: FROM hr_all_organization_units o1
2524: ,hr_organization_information hoi1
2525: ,hr_organization_information hoi2
2526: ,hr_organization_information hoi3
2527: WHERE o1.business_group_id = g_business_group_id
2528: AND hoi1.organization_id = o1.organization_id
2529: AND hoi1.organization_id = csr_v_organization_id
2530: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 2541: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

2537:
2538: lr_find_legal_employer csr_find_legal_employer%ROWTYPE;
2539:
2540: CURSOR csr_legal_employer_details (
2541: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
2542: )
2543: IS
2544: SELECT o1.NAME legal_employer_name
2545: ,hoi2.org_information2 org_number

Line 2548: ,hr_organization_information hoi1

2544: SELECT o1.NAME legal_employer_name
2545: ,hoi2.org_information2 org_number
2546: ,hoi1.organization_id legal_id
2547: FROM hr_organization_units o1
2548: ,hr_organization_information hoi1
2549: ,hr_organization_information hoi2
2550: WHERE o1.business_group_id = g_business_group_id
2551: AND hoi1.organization_id = o1.organization_id
2552: AND hoi1.organization_id = csr_v_legal_employer_id

Line 2549: ,hr_organization_information hoi2

2545: ,hoi2.org_information2 org_number
2546: ,hoi1.organization_id legal_id
2547: FROM hr_organization_units o1
2548: ,hr_organization_information hoi1
2549: ,hr_organization_information hoi2
2550: WHERE o1.business_group_id = g_business_group_id
2551: AND hoi1.organization_id = o1.organization_id
2552: AND hoi1.organization_id = csr_v_legal_employer_id
2553: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 2780: csr_v_organization_id hr_organization_information.organization_id%TYPE

2776: lr_get_details csr_get_details%ROWTYPE;
2777:
2778: -- Cursor to pick up LEGAL EMPLOYER
2779: CURSOR csr_find_legal_employer (
2780: csr_v_organization_id hr_organization_information.organization_id%TYPE
2781: )
2782: IS
2783: SELECT hoi3.organization_id legal_id
2784: FROM hr_all_organization_units o1

Line 2785: ,hr_organization_information hoi1

2781: )
2782: IS
2783: SELECT hoi3.organization_id legal_id
2784: FROM hr_all_organization_units o1
2785: ,hr_organization_information hoi1
2786: ,hr_organization_information hoi2
2787: ,hr_organization_information hoi3
2788: WHERE o1.business_group_id = g_business_group_id
2789: AND hoi1.organization_id = o1.organization_id

Line 2786: ,hr_organization_information hoi2

2782: IS
2783: SELECT hoi3.organization_id legal_id
2784: FROM hr_all_organization_units o1
2785: ,hr_organization_information hoi1
2786: ,hr_organization_information hoi2
2787: ,hr_organization_information hoi3
2788: WHERE o1.business_group_id = g_business_group_id
2789: AND hoi1.organization_id = o1.organization_id
2790: AND hoi1.organization_id = csr_v_organization_id

Line 2787: ,hr_organization_information hoi3

2783: SELECT hoi3.organization_id legal_id
2784: FROM hr_all_organization_units o1
2785: ,hr_organization_information hoi1
2786: ,hr_organization_information hoi2
2787: ,hr_organization_information hoi3
2788: WHERE o1.business_group_id = g_business_group_id
2789: AND hoi1.organization_id = o1.organization_id
2790: AND hoi1.organization_id = csr_v_organization_id
2791: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'