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

Line 30: , hr_organization_information hoi1

26: AND p_effective_date BETWEEN PAA.effective_start_date AND PAA.effective_end_date ;
27: CURSOR c_tax_unit_id (p_business_group_id NUMBER , p_organization_id NUMBER) IS
28: SELECT hoi3.organization_id
29: FROM hr_organization_units o1
30: , hr_organization_information hoi1
31: , hr_organization_information hoi2
32: , hr_organization_information hoi3
33: WHERE o1.business_group_id =p_business_group_id
34: AND hoi1.organization_id = o1.organization_id

Line 31: , hr_organization_information hoi2

27: CURSOR c_tax_unit_id (p_business_group_id NUMBER , p_organization_id NUMBER) IS
28: SELECT hoi3.organization_id
29: FROM hr_organization_units o1
30: , hr_organization_information hoi1
31: , hr_organization_information hoi2
32: , hr_organization_information hoi3
33: WHERE o1.business_group_id =p_business_group_id
34: AND hoi1.organization_id = o1.organization_id
35: AND hoi1.organization_id = p_organization_id

Line 32: , hr_organization_information hoi3

28: SELECT hoi3.organization_id
29: FROM hr_organization_units o1
30: , hr_organization_information hoi1
31: , hr_organization_information hoi2
32: , hr_organization_information hoi3
33: WHERE o1.business_group_id =p_business_group_id
34: AND hoi1.organization_id = o1.organization_id
35: AND hoi1.organization_id = p_organization_id
36: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'

Line 70: l_pension_group_id hr_organization_information.org_information_id%TYPE;

66: l_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
67: l_local_unit_id hr_soft_coding_keyflex.SEGMENT2%TYPE ;
68: l_business_group_id per_all_assignments_f.business_group_id%TYPE ;
69: l_tax_unit_id hr_organization_units.organization_id%TYPE ;
70: l_pension_group_id hr_organization_information.org_information_id%TYPE;
71: l_pension_group hr_organization_information.org_information2%TYPE;
72: l_pension_num hr_organization_information.org_information6%TYPE;
73: l_pension_provider hr_organization_units.organization_id%TYPE ;
74:

Line 71: l_pension_group hr_organization_information.org_information2%TYPE;

67: l_local_unit_id hr_soft_coding_keyflex.SEGMENT2%TYPE ;
68: l_business_group_id per_all_assignments_f.business_group_id%TYPE ;
69: l_tax_unit_id hr_organization_units.organization_id%TYPE ;
70: l_pension_group_id hr_organization_information.org_information_id%TYPE;
71: l_pension_group hr_organization_information.org_information2%TYPE;
72: l_pension_num hr_organization_information.org_information6%TYPE;
73: l_pension_provider hr_organization_units.organization_id%TYPE ;
74:
75: l_effective_date DATE;

Line 72: l_pension_num hr_organization_information.org_information6%TYPE;

68: l_business_group_id per_all_assignments_f.business_group_id%TYPE ;
69: l_tax_unit_id hr_organization_units.organization_id%TYPE ;
70: l_pension_group_id hr_organization_information.org_information_id%TYPE;
71: l_pension_group hr_organization_information.org_information2%TYPE;
72: l_pension_num hr_organization_information.org_information6%TYPE;
73: l_pension_provider hr_organization_units.organization_id%TYPE ;
74:
75: l_effective_date DATE;
76:

Line 163: , hr_organization_information hoi1

159:
160: CURSOR c_tax_unit_id (p_business_group_id NUMBER , p_organization_id NUMBER) IS
161: SELECT hoi3.organization_id
162: FROM hr_organization_units o1
163: , hr_organization_information hoi1
164: , hr_organization_information hoi2
165: , hr_organization_information hoi3
166: WHERE o1.business_group_id =p_business_group_id
167: AND hoi1.organization_id = o1.organization_id

Line 164: , hr_organization_information hoi2

160: CURSOR c_tax_unit_id (p_business_group_id NUMBER , p_organization_id NUMBER) IS
161: SELECT hoi3.organization_id
162: FROM hr_organization_units o1
163: , hr_organization_information hoi1
164: , hr_organization_information hoi2
165: , hr_organization_information hoi3
166: WHERE o1.business_group_id =p_business_group_id
167: AND hoi1.organization_id = o1.organization_id
168: AND hoi1.organization_id = p_organization_id

Line 165: , hr_organization_information hoi3

161: SELECT hoi3.organization_id
162: FROM hr_organization_units o1
163: , hr_organization_information hoi1
164: , hr_organization_information hoi2
165: , hr_organization_information hoi3
166: WHERE o1.business_group_id =p_business_group_id
167: AND hoi1.organization_id = o1.organization_id
168: AND hoi1.organization_id = p_organization_id
169: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'

Line 180: , hr_organization_information hoi1

176:
177: CURSOR c_accident_insurance_info( p_business_group_id NUMBER , p_tax_unit_id NUMBER ,p_effective_date DATE ) IS
178: SELECT hoi2.org_information3
179: FROM hr_organization_units o1
180: , hr_organization_information hoi1
181: , hr_organization_information hoi2
182: WHERE o1.business_group_id =p_business_group_id
183: AND hoi1.organization_id = o1.organization_id
184: AND hoi1.organization_id = p_tax_unit_id

Line 181: , hr_organization_information hoi2

177: CURSOR c_accident_insurance_info( p_business_group_id NUMBER , p_tax_unit_id NUMBER ,p_effective_date DATE ) IS
178: SELECT hoi2.org_information3
179: FROM hr_organization_units o1
180: , hr_organization_information hoi1
181: , hr_organization_information hoi2
182: WHERE o1.business_group_id =p_business_group_id
183: AND hoi1.organization_id = o1.organization_id
184: AND hoi1.organization_id = p_tax_unit_id
185: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 214: , hr_organization_information hoi1

210:
211: CURSOR c_pension_provider_info( p_business_group_id NUMBER , p_tax_unit_id NUMBER , p_pension_num VARCHAR2 ,p_effective_date DATE ) IS
212: SELECT hoi2.org_information4
213: FROM hr_organization_units o1
214: , hr_organization_information hoi1
215: , hr_organization_information hoi2
216: WHERE o1.business_group_id =p_business_group_id
217: AND hoi1.organization_id = o1.organization_id
218: AND hoi1.organization_id = p_tax_unit_id

Line 215: , hr_organization_information hoi2

211: CURSOR c_pension_provider_info( p_business_group_id NUMBER , p_tax_unit_id NUMBER , p_pension_num VARCHAR2 ,p_effective_date DATE ) IS
212: SELECT hoi2.org_information4
213: FROM hr_organization_units o1
214: , hr_organization_information hoi1
215: , hr_organization_information hoi2
216: WHERE o1.business_group_id =p_business_group_id
217: AND hoi1.organization_id = o1.organization_id
218: AND hoi1.organization_id = p_tax_unit_id
219: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 230: , hr_organization_information hoi1

226: AND hoi2.org_information6 IN
227: (
228: SELECT NVL(hoi2.org_information1,0 )
229: FROM hr_organization_units o1
230: , hr_organization_information hoi1
231: , hr_organization_information hoi2
232: WHERE o1.business_group_id = p_business_group_id
233: AND hoi1.organization_id = o1.organization_id
234: AND hoi1.organization_id = l_local_unit_id

Line 231: , hr_organization_information hoi2

227: (
228: SELECT NVL(hoi2.org_information1,0 )
229: FROM hr_organization_units o1
230: , hr_organization_information hoi1
231: , hr_organization_information hoi2
232: WHERE o1.business_group_id = p_business_group_id
233: AND hoi1.organization_id = o1.organization_id
234: AND hoi1.organization_id = l_local_unit_id
235: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'