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

Line 128: l_business_id hr_organization_information.org_information1%TYPE ;

124: l_le_name hr_organization_units.name%TYPE ;
125: l_lu_name hr_organization_units.name%TYPE ;
126: l_element_name pay_element_types_f.element_name%TYPE;
127: l_element_set_name pay_element_sets.element_set_name%TYPE;
128: l_business_id hr_organization_information.org_information1%TYPE ;
129: l_y_number hr_organization_information.org_information1%TYPE ;
130: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
131: l_element_type_id pay_element_types_f.element_type_id%TYPE ;
132: d_element_type_id pay_element_types_f.element_type_id%TYPE ;

Line 129: l_y_number hr_organization_information.org_information1%TYPE ;

125: l_lu_name hr_organization_units.name%TYPE ;
126: l_element_name pay_element_types_f.element_name%TYPE;
127: l_element_set_name pay_element_sets.element_set_name%TYPE;
128: l_business_id hr_organization_information.org_information1%TYPE ;
129: l_y_number hr_organization_information.org_information1%TYPE ;
130: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
131: l_element_type_id pay_element_types_f.element_type_id%TYPE ;
132: d_element_type_id pay_element_types_f.element_type_id%TYPE ;
133: l_element_set_id pay_element_set_members.element_set_id%TYPE;

Line 144: hr_organization_information.ORGANIZATION_ID%TYPE)

140: l_counter number := 0;
141: l_archive VARCHAR2(3);
142: /* Cursors */
143: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id
144: hr_organization_information.ORGANIZATION_ID%TYPE)
145: IS
146: SELECT o1.name , hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION7
147: FROM hr_organization_units o1
148: , hr_organization_information hoi1

Line 148: , hr_organization_information hoi1

144: hr_organization_information.ORGANIZATION_ID%TYPE)
145: IS
146: SELECT o1.name , hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION7
147: FROM hr_organization_units o1
148: , hr_organization_information hoi1
149: , hr_organization_information hoi2
150: WHERE o1.business_group_id =l_business_group_id
151: AND hoi1.organization_id = o1.organization_id
152: AND hoi1.organization_id = csr_v_local_unit_id

Line 149: , hr_organization_information hoi2

145: IS
146: SELECT o1.name , hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION7
147: FROM hr_organization_units o1
148: , hr_organization_information hoi1
149: , hr_organization_information hoi2
150: WHERE o1.business_group_id =l_business_group_id
151: AND hoi1.organization_id = o1.organization_id
152: AND hoi1.organization_id = csr_v_local_unit_id
153: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'

Line 159: hr_organization_information.ORGANIZATION_ID%TYPE)

155: AND o1.organization_id =hoi2.organization_id
156: AND hoi2.ORG_INFORMATION_CONTEXT='FI_LOCAL_UNIT_DETAILS';
157: rg_Local_Unit_Details csr_Local_Unit_Details%rowtype;
158: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id
159: hr_organization_information.ORGANIZATION_ID%TYPE)
160: IS
161: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION11
162: FROM hr_organization_units o1
163: , hr_organization_information hoi1

Line 163: , hr_organization_information hoi1

159: hr_organization_information.ORGANIZATION_ID%TYPE)
160: IS
161: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION11
162: FROM hr_organization_units o1
163: , hr_organization_information hoi1
164: , hr_organization_information hoi2
165: WHERE o1.business_group_id =l_business_group_id
166: AND hoi1.organization_id = o1.organization_id
167: AND hoi1.organization_id = csr_v_legal_emp_id

Line 164: , hr_organization_information hoi2

160: IS
161: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION11
162: FROM hr_organization_units o1
163: , hr_organization_information hoi1
164: , hr_organization_information hoi2
165: WHERE o1.business_group_id =l_business_group_id
166: AND hoi1.organization_id = o1.organization_id
167: AND hoi1.organization_id = csr_v_legal_emp_id
168: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 203: , hr_organization_information hoi1

199: hr_organization_units.organization_id%TYPE)
200: IS
201: SELECT hoi2.ORG_INFORMATION1 local_unit
202: FROM hr_organization_units o1
203: , hr_organization_information hoi1
204: , hr_organization_information hoi2
205: WHERE o1.business_group_id =l_business_group_id
206: AND hoi1.organization_id = o1.organization_id
207: AND hoi1.organization_id = csr_v_legal_unit_id

Line 204: , hr_organization_information hoi2

200: IS
201: SELECT hoi2.ORG_INFORMATION1 local_unit
202: FROM hr_organization_units o1
203: , hr_organization_information hoi1
204: , hr_organization_information hoi2
205: WHERE o1.business_group_id =l_business_group_id
206: AND hoi1.organization_id = o1.organization_id
207: AND hoi1.organization_id = csr_v_legal_unit_id
208: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'