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

Line 239: , HR_ORGANIZATION_INFORMATION hoi1

235: )
236: is
237: select o1.NAME LU_NAME,hoi2.ORG_INFORMATION2 CFAR
238: from HR_ORGANIZATION_UNITS o1
239: , HR_ORGANIZATION_INFORMATION hoi1
240: , HR_ORGANIZATION_INFORMATION hoi2
241: WHERE o1.business_group_id = g_business_group_id
242: and hoi1.organization_id = o1.organization_id
243: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 240: , HR_ORGANIZATION_INFORMATION hoi2

236: is
237: select o1.NAME LU_NAME,hoi2.ORG_INFORMATION2 CFAR
238: from HR_ORGANIZATION_UNITS o1
239: , HR_ORGANIZATION_INFORMATION hoi1
240: , HR_ORGANIZATION_INFORMATION hoi2
241: WHERE o1.business_group_id = g_business_group_id
242: and hoi1.organization_id = o1.organization_id
243: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
244: and hoi1.org_information_context = 'CLASS'

Line 362: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

358: BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
359: AND primary_flag='Y';*/
360:
361: CURSOR csr_legal_employer_details (
362: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
363: )
364: IS
365: SELECT o1.NAME legal_employer_name
366: -- , hoi2.org_information2 org_number

Line 369: , hr_organization_information hoi1

365: SELECT o1.NAME legal_employer_name
366: -- , hoi2.org_information2 org_number
367: -- , hoi1.organization_id legal_id
368: FROM hr_organization_units o1
369: , hr_organization_information hoi1
370: , hr_organization_information hoi2
371: WHERE o1.business_group_id = g_business_group_id
372: AND hoi1.organization_id = o1.organization_id
373: AND hoi1.organization_id = csr_v_legal_employer_id

Line 370: , hr_organization_information hoi2

366: -- , hoi2.org_information2 org_number
367: -- , hoi1.organization_id legal_id
368: FROM hr_organization_units o1
369: , hr_organization_information hoi1
370: , hr_organization_information hoi2
371: WHERE o1.business_group_id = g_business_group_id
372: AND hoi1.organization_id = o1.organization_id
373: AND hoi1.organization_id = csr_v_legal_employer_id
374: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 490: , hr_organization_information hoi1

486: hr_organization_units.organization_id%TYPE)
487: IS
488: SELECT hoi2.ORG_INFORMATION1 local_unit_id
489: FROM hr_organization_units o1
490: , hr_organization_information hoi1
491: , hr_organization_information hoi2
492: WHERE o1.business_group_id =g_business_group_id
493: AND hoi1.organization_id = o1.organization_id
494: AND hoi1.organization_id = csr_v_legal_unit_id

Line 491: , hr_organization_information hoi2

487: IS
488: SELECT hoi2.ORG_INFORMATION1 local_unit_id
489: FROM hr_organization_units o1
490: , hr_organization_information hoi1
491: , hr_organization_information hoi2
492: WHERE o1.business_group_id =g_business_group_id
493: AND hoi1.organization_id = o1.organization_id
494: AND hoi1.organization_id = csr_v_legal_unit_id
495: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 501: csr_v_local_unit_id hr_organization_information.organization_id%TYPE

497: AND o1.organization_id =hoi2.organization_id
498: AND hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNITS';
499:
500: CURSOR csr_local_unit_details (
501: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
502: )
503: IS
504: SELECT o1.NAME local_unit_name
505: -- , hoi2.org_information2 org_number

Line 508: , hr_organization_information hoi1

504: SELECT o1.NAME local_unit_name
505: -- , hoi2.org_information2 org_number
506: -- , hoi1.organization_id legal_id
507: FROM hr_organization_units o1
508: , hr_organization_information hoi1
509: , hr_organization_information hoi2
510: WHERE o1.business_group_id = g_business_group_id
511: AND hoi1.organization_id = o1.organization_id
512: AND hoi1.organization_id = csr_v_local_unit_id

Line 509: , hr_organization_information hoi2

505: -- , hoi2.org_information2 org_number
506: -- , hoi1.organization_id legal_id
507: FROM hr_organization_units o1
508: , hr_organization_information hoi1
509: , hr_organization_information hoi2
510: WHERE o1.business_group_id = g_business_group_id
511: AND hoi1.organization_id = o1.organization_id
512: AND hoi1.organization_id = csr_v_local_unit_id
513: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 745: , HR_ORGANIZATION_INFORMATION hoi1

741: )
742: is
743: select o1.NAME LU_NAME,hoi2.ORG_INFORMATION2 CFAR
744: from HR_ORGANIZATION_UNITS o1
745: , HR_ORGANIZATION_INFORMATION hoi1
746: , HR_ORGANIZATION_INFORMATION hoi2
747: WHERE o1.business_group_id = g_business_group_id
748: and hoi1.organization_id = o1.organization_id
749: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 746: , HR_ORGANIZATION_INFORMATION hoi2

742: is
743: select o1.NAME LU_NAME,hoi2.ORG_INFORMATION2 CFAR
744: from HR_ORGANIZATION_UNITS o1
745: , HR_ORGANIZATION_INFORMATION hoi1
746: , HR_ORGANIZATION_INFORMATION hoi2
747: WHERE o1.business_group_id = g_business_group_id
748: and hoi1.organization_id = o1.organization_id
749: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
750: and hoi1.org_information_context = 'CLASS'

Line 868: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

864: BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
865: AND primary_flag='Y';*/
866:
867: CURSOR csr_legal_employer_details (
868: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
869: )
870: IS
871: SELECT o1.NAME legal_employer_name
872: -- , hoi2.org_information2 org_number

Line 875: , hr_organization_information hoi1

871: SELECT o1.NAME legal_employer_name
872: -- , hoi2.org_information2 org_number
873: -- , hoi1.organization_id legal_id
874: FROM hr_organization_units o1
875: , hr_organization_information hoi1
876: , hr_organization_information hoi2
877: WHERE o1.business_group_id = g_business_group_id
878: AND hoi1.organization_id = o1.organization_id
879: AND hoi1.organization_id = csr_v_legal_employer_id

Line 876: , hr_organization_information hoi2

872: -- , hoi2.org_information2 org_number
873: -- , hoi1.organization_id legal_id
874: FROM hr_organization_units o1
875: , hr_organization_information hoi1
876: , hr_organization_information hoi2
877: WHERE o1.business_group_id = g_business_group_id
878: AND hoi1.organization_id = o1.organization_id
879: AND hoi1.organization_id = csr_v_legal_employer_id
880: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1028: , hr_organization_information hoi1

1024: hr_organization_units.organization_id%TYPE)
1025: IS
1026: SELECT hoi2.ORG_INFORMATION1 local_unit_id
1027: FROM hr_organization_units o1
1028: , hr_organization_information hoi1
1029: , hr_organization_information hoi2
1030: WHERE o1.business_group_id =g_business_group_id
1031: AND hoi1.organization_id = o1.organization_id
1032: AND hoi1.organization_id = csr_v_legal_unit_id

Line 1029: , hr_organization_information hoi2

1025: IS
1026: SELECT hoi2.ORG_INFORMATION1 local_unit_id
1027: FROM hr_organization_units o1
1028: , hr_organization_information hoi1
1029: , hr_organization_information hoi2
1030: WHERE o1.business_group_id =g_business_group_id
1031: AND hoi1.organization_id = o1.organization_id
1032: AND hoi1.organization_id = csr_v_legal_unit_id
1033: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1039: csr_v_local_unit_id hr_organization_information.organization_id%TYPE

1035: AND o1.organization_id =hoi2.organization_id
1036: AND hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNITS';
1037:
1038: CURSOR csr_local_unit_details (
1039: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
1040: )
1041: IS
1042: SELECT o1.NAME local_unit_name
1043: -- , hoi2.org_information2 org_number

Line 1046: , hr_organization_information hoi1

1042: SELECT o1.NAME local_unit_name
1043: -- , hoi2.org_information2 org_number
1044: -- , hoi1.organization_id legal_id
1045: FROM hr_organization_units o1
1046: , hr_organization_information hoi1
1047: , hr_organization_information hoi2
1048: WHERE o1.business_group_id = g_business_group_id
1049: AND hoi1.organization_id = o1.organization_id
1050: AND hoi1.organization_id = csr_v_local_unit_id

Line 1047: , hr_organization_information hoi2

1043: -- , hoi2.org_information2 org_number
1044: -- , hoi1.organization_id legal_id
1045: FROM hr_organization_units o1
1046: , hr_organization_information hoi1
1047: , hr_organization_information hoi2
1048: WHERE o1.business_group_id = g_business_group_id
1049: AND hoi1.organization_id = o1.organization_id
1050: AND hoi1.organization_id = csr_v_local_unit_id
1051: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1091: FROM hr_organization_information hoi

1087: cursor csr_wages_details (csr_v_organization_id NUMBER, csr_v_category VARCHAR2, csr_v_display_name VARCHAR2)
1088: IS
1089: SELECT org_information3 Type, org_information4 Element_Type_Id, org_information5 Input_value_Id,
1090: org_information6 Balance_Type_Id,org_information7 Balance_Dimension_Id
1091: FROM hr_organization_information hoi
1092: WHERE hoi.organization_id=csr_v_organization_id --3134
1093: AND hoi.org_information_context='SE_WAGES_SALARY_DETAILS'
1094: AND hoi.org_information1=csr_v_category --'BH'
1095: AND hoi.org_information2=csr_v_display_name;--'CCD'