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

Line 949: FROM hr_organization_units o1

945: l_tax_calendar_days hr_organization_information.org_information10%TYPE;
946:
947: CURSOR c_tax_calendar_days( p_business_group_id NUMBER , p_tax_unit_id NUMBER) IS
948: SELECT NVL(hoi2.org_information10,'364') org_information10
949: FROM hr_organization_units o1
950: , hr_organization_information hoi1
951: , hr_organization_information hoi2
952: WHERE o1.business_group_id =p_business_group_id
953: AND hoi1.organization_id = o1.organization_id

Line 989: FROM hr_organization_units o1

985:
986: CURSOR c_social_security_info( p_business_group_id NUMBER , p_tax_unit_id NUMBER) IS
987: SELECT NVL(hoi2.org_information3,0 ) org_information3 ,
988: NVL(hoi2.org_information12,'N') org_information11
989: FROM hr_organization_units o1
990: , hr_organization_information hoi1
991: , hr_organization_information hoi2
992: WHERE o1.business_group_id =p_business_group_id
993: AND hoi1.organization_id = o1.organization_id

Line 1034: FROM hr_organization_units o1

1030: l_accident_insurance_id hr_organization_information.org_information3%TYPE;
1031:
1032: CURSOR c_accident_insurance_info( p_business_group_id NUMBER , p_tax_unit_id NUMBER , p_effective_date DATE ) IS
1033: SELECT hoi2.org_information3
1034: FROM hr_organization_units o1
1035: , hr_organization_information hoi1
1036: , hr_organization_information hoi2
1037: WHERE o1.business_group_id =p_business_group_id
1038: AND hoi1.organization_id = o1.organization_id

Line 1088: FROM hr_organization_units o1

1084: CURSOR c_accident_insurance_info( p_business_group_id NUMBER , p_tax_unit_id NUMBER , p_effective_date DATE ) IS
1085: SELECT hoi2.org_information3 org_information3 ,
1086: NVL(hoi2.org_information5,0 ) org_information5 ,
1087: NVL(hoi2.org_information6,0 ) org_information6
1088: FROM hr_organization_units o1
1089: , hr_organization_information hoi1
1090: , hr_organization_information hoi2
1091: WHERE o1.business_group_id =p_business_group_id
1092: AND hoi1.organization_id = o1.organization_id

Line 1104: FROM hr_organization_units o1

1100:
1101:
1102: CURSOR c_lc_accident_insurance_info( p_business_group_id NUMBER , p_local_unit_id NUMBER , p_effective_date DATE ) IS
1103: SELECT hoi2.org_information4 org_information4
1104: FROM hr_organization_units o1
1105: , hr_organization_information hoi1
1106: , hr_organization_information hoi2
1107: WHERE o1.business_group_id =p_business_group_id
1108: AND hoi1.organization_id = o1.organization_id

Line 1194: FROM hr_organization_units o1

1190: AND nvl(fnd_date.canonical_to_date(per.per_information20),to_date('31/12/4712','DD/MM/YYYY'));
1191:
1192: CURSOR c_pension_provider_info( p_business_group_id NUMBER , p_tax_unit_id NUMBER , p_pension_num VARCHAR2 , p_effective_date DATE) IS
1193: SELECT NVL(hoi2.org_information4,0 ) org_information4 , NVL(hoi2.org_information7,0 ) org_information7
1194: FROM hr_organization_units o1
1195: , hr_organization_information hoi1
1196: , hr_organization_information hoi2
1197: WHERE o1.business_group_id =p_business_group_id
1198: AND hoi1.organization_id = o1.organization_id

Line 1210: FROM hr_organization_units o1

1206: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY'))
1207: AND hoi2.org_information6 IN
1208: (
1209: SELECT NVL(hoi2.org_information1,0 )
1210: FROM hr_organization_units o1
1211: , hr_organization_information hoi1
1212: , hr_organization_information hoi2
1213: WHERE o1.business_group_id = p_business_group_id
1214: AND hoi1.organization_id = o1.organization_id