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_INFORMATION

Line 945: l_tax_calendar_days hr_organization_information.org_information10%TYPE;

941: ) RETURN NUMBER
942: IS
943:
944:
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

Line 950: , hr_organization_information hoi1

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
954: AND hoi1.organization_id = p_tax_unit_id

Line 951: , hr_organization_information hoi2

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
954: AND hoi1.organization_id = p_tax_unit_id
955: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 990: , hr_organization_information hoi1

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
994: AND hoi1.organization_id = p_tax_unit_id

Line 991: , hr_organization_information hoi2

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
994: AND hoi1.organization_id = p_tax_unit_id
995: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1030: l_accident_insurance_id hr_organization_information.org_information3%TYPE;

1026: , p_effective_date DATE
1027: ) RETURN NUMBER
1028: IS
1029:
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

Line 1035: , hr_organization_information hoi1

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
1039: AND hoi1.organization_id = p_tax_unit_id

Line 1036: , hr_organization_information hoi2

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
1039: AND hoi1.organization_id = p_tax_unit_id
1040: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1078: l_accident_insurance_id hr_organization_information.org_information3%TYPE;

1074: ,p_rate OUT NOCOPY NUMBER
1075: ) RETURN NUMBER
1076: IS
1077:
1078: l_accident_insurance_id hr_organization_information.org_information3%TYPE;
1079: l_lc_accident_insurance_pct hr_organization_information.org_information4%TYPE;
1080: l_accident_insurance_pct hr_organization_information.org_information3%TYPE;
1081: l_group_insurance_pct hr_organization_information.org_information3%TYPE;
1082: l_local_unit hr_soft_coding_keyflex.segment2%TYPE;

Line 1079: l_lc_accident_insurance_pct hr_organization_information.org_information4%TYPE;

1075: ) RETURN NUMBER
1076: IS
1077:
1078: l_accident_insurance_id hr_organization_information.org_information3%TYPE;
1079: l_lc_accident_insurance_pct hr_organization_information.org_information4%TYPE;
1080: l_accident_insurance_pct hr_organization_information.org_information3%TYPE;
1081: l_group_insurance_pct hr_organization_information.org_information3%TYPE;
1082: l_local_unit hr_soft_coding_keyflex.segment2%TYPE;
1083:

Line 1080: l_accident_insurance_pct hr_organization_information.org_information3%TYPE;

1076: IS
1077:
1078: l_accident_insurance_id hr_organization_information.org_information3%TYPE;
1079: l_lc_accident_insurance_pct hr_organization_information.org_information4%TYPE;
1080: l_accident_insurance_pct hr_organization_information.org_information3%TYPE;
1081: l_group_insurance_pct hr_organization_information.org_information3%TYPE;
1082: l_local_unit hr_soft_coding_keyflex.segment2%TYPE;
1083:
1084: CURSOR c_accident_insurance_info( p_business_group_id NUMBER , p_tax_unit_id NUMBER , p_effective_date DATE ) IS

Line 1081: l_group_insurance_pct hr_organization_information.org_information3%TYPE;

1077:
1078: l_accident_insurance_id hr_organization_information.org_information3%TYPE;
1079: l_lc_accident_insurance_pct hr_organization_information.org_information4%TYPE;
1080: l_accident_insurance_pct hr_organization_information.org_information3%TYPE;
1081: l_group_insurance_pct hr_organization_information.org_information3%TYPE;
1082: l_local_unit hr_soft_coding_keyflex.segment2%TYPE;
1083:
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 ,

Line 1089: , hr_organization_information hoi1

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
1093: AND hoi1.organization_id = p_tax_unit_id

Line 1090: , hr_organization_information hoi2

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
1093: AND hoi1.organization_id = p_tax_unit_id
1094: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1105: , hr_organization_information hoi1

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
1109: AND hoi1.organization_id = p_local_unit_id

Line 1106: , hr_organization_information hoi2

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
1109: AND hoi1.organization_id = p_local_unit_id
1110: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'

Line 1176: l_pension_group_id hr_organization_information.org_information_id%TYPE;

1172: ,p_pension_rate OUT NOCOPY NUMBER
1173: ) RETURN NUMBER
1174: IS
1175:
1176: l_pension_group_id hr_organization_information.org_information_id%TYPE;
1177: l_pension_num hr_organization_information.org_information1%TYPE;
1178: l_local_unit hr_soft_coding_keyflex.segment2%TYPE;
1179: l_pension_rate hr_organization_information.org_information1%TYPE;
1180:

Line 1177: l_pension_num hr_organization_information.org_information1%TYPE;

1173: ) RETURN NUMBER
1174: IS
1175:
1176: l_pension_group_id hr_organization_information.org_information_id%TYPE;
1177: l_pension_num hr_organization_information.org_information1%TYPE;
1178: l_local_unit hr_soft_coding_keyflex.segment2%TYPE;
1179: l_pension_rate hr_organization_information.org_information1%TYPE;
1180:
1181: CURSOR c_person_pension_num(p_assignment_id NUMBER , p_effective_date DATE) IS

Line 1179: l_pension_rate hr_organization_information.org_information1%TYPE;

1175:
1176: l_pension_group_id hr_organization_information.org_information_id%TYPE;
1177: l_pension_num hr_organization_information.org_information1%TYPE;
1178: l_local_unit hr_soft_coding_keyflex.segment2%TYPE;
1179: l_pension_rate hr_organization_information.org_information1%TYPE;
1180:
1181: CURSOR c_person_pension_num(p_assignment_id NUMBER , p_effective_date DATE) IS
1182: SELECT PER_INFORMATION15, PER_INFORMATION16, PER_INFORMATION24
1183: FROM per_all_assignments_f asg1

Line 1195: , hr_organization_information hoi1

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
1199: AND hoi1.organization_id = p_tax_unit_id

Line 1196: , hr_organization_information hoi2

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
1199: AND hoi1.organization_id = p_tax_unit_id
1200: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1211: , hr_organization_information hoi1

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
1215: AND hoi1.organization_id = l_local_unit

Line 1212: , hr_organization_information hoi2

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
1215: AND hoi1.organization_id = l_local_unit
1216: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'