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_NO_K27_REIM_UPLD dependencies on HR_ORGANIZATION_UNITS

Line 448: HR_ORGANIZATION_UNITS hou,

444: IS
445: select hoi.ORG_INFORMATION1
446: FROM
447: HR_ORGANIZATION_INFORMATION hoi,
448: HR_ORGANIZATION_UNITS hou,
449: HR_ORGANIZATION_INFORMATION hoi1
450: where hoi.org_information_context = 'NO_LOCAL_UNIT_DETAILS'
451: and HOi1.ORG_INFORMATION_CONTEXT = 'CLASS'
452: and HOI1.org_information2 ='Y'

Line 947: l_emp_id hr_organization_units.organization_id%TYPE ;

943: l_count NUMBER := 0;
944: l_business_group_id NUMBER;
945:
946: -- l_company_terminating varchar2(1); bug 10367494
947: l_emp_id hr_organization_units.organization_id%TYPE ;
948: l_le_name hr_organization_units.name%TYPE ;
949: l_business_id hr_organization_information.org_information1%TYPE ;
950: l_cvr_number hr_organization_information.org_information1%TYPE ;
951: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;

Line 948: l_le_name hr_organization_units.name%TYPE ;

944: l_business_group_id NUMBER;
945:
946: -- l_company_terminating varchar2(1); bug 10367494
947: l_emp_id hr_organization_units.organization_id%TYPE ;
948: l_le_name hr_organization_units.name%TYPE ;
949: l_business_id hr_organization_information.org_information1%TYPE ;
950: l_cvr_number hr_organization_information.org_information1%TYPE ;
951: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
952: l_org_type hr_organization_information.org_information1%TYPE ;

Line 979: FROM hr_organization_units o1

975: /*Legal Employer Information*/
976: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
977: IS
978: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
979: FROM hr_organization_units o1
980: , hr_organization_information hoi1
981: , hr_organization_information hoi2
982: WHERE o1.business_group_id =l_business_group_id
983: AND hoi1.organization_id = o1.organization_id

Line 1001: FROM hr_organization_units o1

997: hoi2.ORG_INFORMATION3,
998: hoi2.ORG_INFORMATION4,
999: hoi2.ORG_INFORMATION5,
1000: hoi2.ORG_INFORMATION6
1001: FROM hr_organization_units o1
1002: , hr_organization_information hoi1
1003: , hr_organization_information hoi2
1004: WHERE o1.business_group_id =l_business_group_id
1005: AND hoi1.organization_id = o1.organization_id

Line 1021: select organization_id from hr_organization_units

1017: is
1018: select * from hr_organization_information
1019: where org_information_context = 'DK_SERVICE_PROVIDER_DETAILS'
1020: and organization_id in (
1021: select organization_id from hr_organization_units
1022: where business_group_id= l_business_group_id);
1023:
1024: sp service_provider_details%rowtype;
1025:

Line 1068: hr_organization_units hou,

1064: ptp.TIME_PERIOD_ID
1065: FROM
1066: pay_payrolls_f ppf,
1067: per_assignments_f paf,
1068: hr_organization_units hou,
1069: hr_organization_information hoi,
1070: hr_soft_coding_keyflex scl,
1071: per_time_periods ptp
1072: WHERE hou.business_group_id = l_business_group_id