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

Line 292: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

288: l_element_context VARCHAR2 (5);
289:
290: -- Archiving the data , as this will fire once
291: CURSOR csr_legal_employer_details (
292: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
293: )
294: IS
295: SELECT o1.NAME legal_employer_name
296: , hoi2.org_information2 org_number

Line 299: , hr_organization_information hoi1

295: SELECT o1.NAME legal_employer_name
296: , hoi2.org_information2 org_number
297: , hoi1.organization_id legal_id
298: FROM hr_organization_units o1
299: , hr_organization_information hoi1
300: , hr_organization_information hoi2
301: WHERE o1.business_group_id = g_business_group_id
302: AND hoi1.organization_id = o1.organization_id
303: AND hoi1.organization_id =

Line 300: , hr_organization_information hoi2

296: , hoi2.org_information2 org_number
297: , hoi1.organization_id legal_id
298: FROM hr_organization_units o1
299: , hr_organization_information hoi1
300: , hr_organization_information hoi2
301: WHERE o1.business_group_id = g_business_group_id
302: AND hoi1.organization_id = o1.organization_id
303: AND hoi1.organization_id =
304: NVL (csr_v_legal_employer_id, hoi1.organization_id)

Line 612: l_pension_type hr_organization_information.org_information1%TYPE;

608: l_count NUMBER := 0;
609: l_prev_prepay NUMBER := 0;
610: l_canonical_start_date DATE;
611: l_canonical_end_date DATE;
612: l_pension_type hr_organization_information.org_information1%TYPE;
613: l_prepay_action_id NUMBER;
614: l_actid NUMBER;
615: l_assignment_id NUMBER;
616: l_action_sequence NUMBER;

Line 994: csr_v_organization_id hr_organization_information.organization_id%TYPE

990: lr_get_segment2 csr_get_segment2%ROWTYPE;
991:
992: -- Cursor to pick up LEGAL EMPLOYER
993: CURSOR csr_find_legal_employer (
994: csr_v_organization_id hr_organization_information.organization_id%TYPE
995: )
996: IS
997: SELECT hoi3.organization_id legal_id
998: FROM hr_all_organization_units o1

Line 999: , hr_organization_information hoi1

995: )
996: IS
997: SELECT hoi3.organization_id legal_id
998: FROM hr_all_organization_units o1
999: , hr_organization_information hoi1
1000: , hr_organization_information hoi2
1001: , hr_organization_information hoi3
1002: WHERE o1.business_group_id = g_business_group_id
1003: AND hoi1.organization_id = o1.organization_id

Line 1000: , hr_organization_information hoi2

996: IS
997: SELECT hoi3.organization_id legal_id
998: FROM hr_all_organization_units o1
999: , hr_organization_information hoi1
1000: , hr_organization_information hoi2
1001: , hr_organization_information hoi3
1002: WHERE o1.business_group_id = g_business_group_id
1003: AND hoi1.organization_id = o1.organization_id
1004: AND hoi1.organization_id = csr_v_organization_id

Line 1001: , hr_organization_information hoi3

997: SELECT hoi3.organization_id legal_id
998: FROM hr_all_organization_units o1
999: , hr_organization_information hoi1
1000: , hr_organization_information hoi2
1001: , hr_organization_information hoi3
1002: WHERE o1.business_group_id = g_business_group_id
1003: AND hoi1.organization_id = o1.organization_id
1004: AND hoi1.organization_id = csr_v_organization_id
1005: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1017: csr_v_local_unit_id hr_organization_information.organization_id%TYPE

1013: lr_find_legal_employer csr_find_legal_employer%ROWTYPE;
1014:
1015: -- Cursor to pick up Local Unit Details
1016: CURSOR csr_local_unit_details (
1017: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
1018: )
1019: IS
1020: SELECT o1.NAME, hoi2.org_information1
1021: FROM hr_organization_units o1

Line 1022: , hr_organization_information hoi1

1018: )
1019: IS
1020: SELECT o1.NAME, hoi2.org_information1
1021: FROM hr_organization_units o1
1022: , hr_organization_information hoi1
1023: , hr_organization_information hoi2
1024: WHERE o1.business_group_id = g_business_group_id
1025: AND hoi1.organization_id = o1.organization_id
1026: AND hoi1.organization_id = csr_v_local_unit_id

Line 1023: , hr_organization_information hoi2

1019: IS
1020: SELECT o1.NAME, hoi2.org_information1
1021: FROM hr_organization_units o1
1022: , hr_organization_information hoi1
1023: , hr_organization_information hoi2
1024: WHERE o1.business_group_id = g_business_group_id
1025: AND hoi1.organization_id = o1.organization_id
1026: AND hoi1.organization_id = csr_v_local_unit_id
1027: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'