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_UNITS

Line 29: FROM hr_organization_units o1

25: AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
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

Line 69: l_tax_unit_id hr_organization_units.organization_id%TYPE ;

65: l_third_party_id number;
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 ;

Line 73: l_pension_provider hr_organization_units.organization_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:
77:

Line 162: FROM hr_organization_units o1

158: AND target.enabled_flag = 'Y';
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

Line 179: FROM hr_organization_units o1

175: AND hoi3.org_information1 = 'HR_LEGAL_EMPLOYER' ;
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

Line 213: FROM hr_organization_units o1

209:
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

Line 229: FROM hr_organization_units o1

225: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY'))
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