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

Line 126: l_business_id hr_organization_information.org_information1%TYPE ;

122: l_business_group_id NUMBER;
123: l_emp_id hr_organization_units.organization_id%TYPE ;
124: l_le_name hr_organization_units.name%TYPE ;
125: l_lu_name hr_organization_units.name%TYPE ;
126: l_business_id hr_organization_information.org_information1%TYPE ;
127: l_y_number hr_organization_information.org_information1%TYPE ;
128: l_contact_person hr_organization_information.org_information1%TYPE ;
129: l_phone hr_organization_information.org_information1%TYPE ;
130: l_org_type hr_organization_information.org_information1%TYPE ;

Line 127: l_y_number hr_organization_information.org_information1%TYPE ;

123: l_emp_id hr_organization_units.organization_id%TYPE ;
124: l_le_name hr_organization_units.name%TYPE ;
125: l_lu_name hr_organization_units.name%TYPE ;
126: l_business_id hr_organization_information.org_information1%TYPE ;
127: l_y_number hr_organization_information.org_information1%TYPE ;
128: l_contact_person hr_organization_information.org_information1%TYPE ;
129: l_phone hr_organization_information.org_information1%TYPE ;
130: l_org_type hr_organization_information.org_information1%TYPE ;
131:

Line 128: l_contact_person 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_business_id hr_organization_information.org_information1%TYPE ;
127: l_y_number hr_organization_information.org_information1%TYPE ;
128: l_contact_person hr_organization_information.org_information1%TYPE ;
129: l_phone hr_organization_information.org_information1%TYPE ;
130: l_org_type hr_organization_information.org_information1%TYPE ;
131:
132: /*Cursors */

Line 129: l_phone hr_organization_information.org_information1%TYPE ;

125: l_lu_name hr_organization_units.name%TYPE ;
126: l_business_id hr_organization_information.org_information1%TYPE ;
127: l_y_number hr_organization_information.org_information1%TYPE ;
128: l_contact_person hr_organization_information.org_information1%TYPE ;
129: l_phone hr_organization_information.org_information1%TYPE ;
130: l_org_type hr_organization_information.org_information1%TYPE ;
131:
132: /*Cursors */
133: /*Local Unit Information*/

Line 130: l_org_type hr_organization_information.org_information1%TYPE ;

126: l_business_id hr_organization_information.org_information1%TYPE ;
127: l_y_number hr_organization_information.org_information1%TYPE ;
128: l_contact_person hr_organization_information.org_information1%TYPE ;
129: l_phone hr_organization_information.org_information1%TYPE ;
130: l_org_type hr_organization_information.org_information1%TYPE ;
131:
132: /*Cursors */
133: /*Local Unit Information*/
134: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)

Line 134: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)

130: l_org_type hr_organization_information.org_information1%TYPE ;
131:
132: /*Cursors */
133: /*Local Unit Information*/
134: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)
135: IS
136: SELECT o1.name , hoi2.ORG_INFORMATION1
137: FROM hr_organization_units o1
138: , hr_organization_information hoi1

Line 138: , hr_organization_information hoi1

134: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)
135: IS
136: SELECT o1.name , hoi2.ORG_INFORMATION1
137: FROM hr_organization_units o1
138: , hr_organization_information hoi1
139: , hr_organization_information hoi2
140: WHERE o1.business_group_id =l_business_group_id
141: AND hoi1.organization_id = o1.organization_id
142: AND hoi1.organization_id = csr_v_local_unit_id

Line 139: , hr_organization_information hoi2

135: IS
136: SELECT o1.name , hoi2.ORG_INFORMATION1
137: FROM hr_organization_units o1
138: , hr_organization_information hoi1
139: , hr_organization_information hoi2
140: WHERE o1.business_group_id =l_business_group_id
141: AND hoi1.organization_id = o1.organization_id
142: AND hoi1.organization_id = csr_v_local_unit_id
143: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'

Line 151: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)

147:
148: rg_Local_Unit_Details csr_Local_Unit_Details%rowtype;
149:
150: /*Legal Employer Information*/
151: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
152: IS
153: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION13
154: FROM hr_organization_units o1
155: , hr_organization_information hoi1

Line 155: , hr_organization_information hoi1

151: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
152: IS
153: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION13
154: FROM hr_organization_units o1
155: , hr_organization_information hoi1
156: , hr_organization_information hoi2
157: WHERE o1.business_group_id =l_business_group_id
158: AND hoi1.organization_id = o1.organization_id
159: AND hoi1.organization_id = csr_v_legal_emp_id

Line 156: , hr_organization_information hoi2

152: IS
153: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION13
154: FROM hr_organization_units o1
155: , hr_organization_information hoi1
156: , hr_organization_information hoi2
157: WHERE o1.business_group_id =l_business_group_id
158: AND hoi1.organization_id = o1.organization_id
159: AND hoi1.organization_id = csr_v_legal_emp_id
160: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 169: Cursor csr_Legal_Emp_Contact ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)

165:
166: rg_Legal_Emp_Details csr_Legal_Emp_Details%rowtype;
167:
168: /*Legal Employer Contact Information*/
169: Cursor csr_Legal_Emp_Contact ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
170: IS
171: SELECT hoi4.ORG_INFORMATION2 contact_person , hoi3.ORG_INFORMATION2 phone
172: FROM hr_organization_units o1
173: , hr_organization_information hoi1

Line 173: , hr_organization_information hoi1

169: Cursor csr_Legal_Emp_Contact ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
170: IS
171: SELECT hoi4.ORG_INFORMATION2 contact_person , hoi3.ORG_INFORMATION2 phone
172: FROM hr_organization_units o1
173: , hr_organization_information hoi1
174: , hr_organization_information hoi3
175: , hr_organization_information hoi4
176: WHERE o1.business_group_id =l_business_group_id
177: AND hoi1.organization_id = o1.organization_id

Line 174: , hr_organization_information hoi3

170: IS
171: SELECT hoi4.ORG_INFORMATION2 contact_person , hoi3.ORG_INFORMATION2 phone
172: FROM hr_organization_units o1
173: , hr_organization_information hoi1
174: , hr_organization_information hoi3
175: , hr_organization_information hoi4
176: WHERE o1.business_group_id =l_business_group_id
177: AND hoi1.organization_id = o1.organization_id
178: AND hoi1.organization_id = csr_v_legal_emp_id

Line 175: , hr_organization_information hoi4

171: SELECT hoi4.ORG_INFORMATION2 contact_person , hoi3.ORG_INFORMATION2 phone
172: FROM hr_organization_units o1
173: , hr_organization_information hoi1
174: , hr_organization_information hoi3
175: , hr_organization_information hoi4
176: WHERE o1.business_group_id =l_business_group_id
177: AND hoi1.organization_id = o1.organization_id
178: AND hoi1.organization_id = csr_v_legal_emp_id
179: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 191: Cursor csr_Local_Unit_contact ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)

187:
188: rg_Legal_Emp_Contact csr_Legal_Emp_Contact%rowtype;
189:
190: /*Local Unit Contact Information*/
191: Cursor csr_Local_Unit_contact ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)
192: IS
193: SELECT hoi4.ORG_INFORMATION2 contact_person , hoi3.ORG_INFORMATION2 phone
194: FROM hr_organization_units o1
195: , hr_organization_information hoi1

Line 195: , hr_organization_information hoi1

191: Cursor csr_Local_Unit_contact ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)
192: IS
193: SELECT hoi4.ORG_INFORMATION2 contact_person , hoi3.ORG_INFORMATION2 phone
194: FROM hr_organization_units o1
195: , hr_organization_information hoi1
196: , hr_organization_information hoi3
197: , hr_organization_information hoi4
198: WHERE o1.business_group_id =l_business_group_id
199: AND hoi1.organization_id = o1.organization_id

Line 196: , hr_organization_information hoi3

192: IS
193: SELECT hoi4.ORG_INFORMATION2 contact_person , hoi3.ORG_INFORMATION2 phone
194: FROM hr_organization_units o1
195: , hr_organization_information hoi1
196: , hr_organization_information hoi3
197: , hr_organization_information hoi4
198: WHERE o1.business_group_id =l_business_group_id
199: AND hoi1.organization_id = o1.organization_id
200: AND hoi1.organization_id = csr_v_local_unit_id

Line 197: , hr_organization_information hoi4

193: SELECT hoi4.ORG_INFORMATION2 contact_person , hoi3.ORG_INFORMATION2 phone
194: FROM hr_organization_units o1
195: , hr_organization_information hoi1
196: , hr_organization_information hoi3
197: , hr_organization_information hoi4
198: WHERE o1.business_group_id =l_business_group_id
199: AND hoi1.organization_id = o1.organization_id
200: AND hoi1.organization_id = csr_v_local_unit_id
201: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'