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_MTRA dependencies on HR_ORGANIZATION_UNITS

Line 163: l_emp_id hr_organization_units.organization_id%TYPE ;

159: l_adjustment_ss NUMBER ;
160: l_adjustment_ts NUMBER ;
161: l_vat NUMBER ;
162: l_emp_type VARCHAR2(2);
163: l_emp_id hr_organization_units.organization_id%TYPE ;
164: l_due_date1 DATE ;
165: l_due_date2 VARCHAR2(30);
166: l_ref_number NUMBER ;
167: l_ref_num VARCHAR2(20);

Line 170: l_tax_payer_name hr_organization_units.name%TYPE ;

166: l_ref_number NUMBER ;
167: l_ref_num VARCHAR2(20);
168:
169: l_Record_code VARCHAR2(240) :=' ';
170: l_tax_payer_name hr_organization_units.name%TYPE ;
171: l_le_name hr_organization_units.name%TYPE ;
172: l_lu_name hr_organization_units.name%TYPE ;
173: l_address_line_1 hr_locations.address_line_1%TYPE ;
174: l_address_line_2 hr_locations.address_line_2%TYPE ;

Line 171: l_le_name hr_organization_units.name%TYPE ;

167: l_ref_num VARCHAR2(20);
168:
169: l_Record_code VARCHAR2(240) :=' ';
170: l_tax_payer_name hr_organization_units.name%TYPE ;
171: l_le_name hr_organization_units.name%TYPE ;
172: l_lu_name hr_organization_units.name%TYPE ;
173: l_address_line_1 hr_locations.address_line_1%TYPE ;
174: l_address_line_2 hr_locations.address_line_2%TYPE ;
175: l_address_line_3 hr_locations.address_line_3%TYPE ;

Line 172: l_lu_name hr_organization_units.name%TYPE ;

168:
169: l_Record_code VARCHAR2(240) :=' ';
170: l_tax_payer_name hr_organization_units.name%TYPE ;
171: l_le_name hr_organization_units.name%TYPE ;
172: l_lu_name hr_organization_units.name%TYPE ;
173: l_address_line_1 hr_locations.address_line_1%TYPE ;
174: l_address_line_2 hr_locations.address_line_2%TYPE ;
175: l_address_line_3 hr_locations.address_line_3%TYPE ;
176: l_postal_code hr_locations.postal_code%TYPE ;

Line 197: l_tax_office_name hr_organization_units.name%TYPE ;

193: l_phone hr_organization_information.org_information1%TYPE ;
194: l_fax hr_organization_information.org_information1%TYPE ;
195: l_tax_office_ba pay_external_accounts.segment3%TYPE ;
196: l_tax_office_pay_meth_id hr_organization_information.org_information2%TYPE ;
197: l_tax_office_name hr_organization_units.name%TYPE ;
198: l_employer_ba pay_external_accounts.segment3%TYPE ;
199: l_employer_pay_meth_id hr_organization_information.org_information1%TYPE ;
200: l_tax_office_id hr_organization_information.organization_id%TYPE ;
201: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 223: FROM hr_organization_units o1

219:
220: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)
221: IS
222: SELECT o1.name , hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION7
223: FROM hr_organization_units o1
224: , hr_organization_information hoi1
225: , hr_organization_information hoi2
226: WHERE o1.business_group_id =l_business_group_id
227: AND hoi1.organization_id = o1.organization_id

Line 239: FROM hr_organization_units o1

235:
236: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
237: IS
238: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION11
239: FROM hr_organization_units o1
240: , hr_organization_information hoi1
241: , hr_organization_information hoi2
242: WHERE o1.business_group_id =l_business_group_id
243: AND hoi1.organization_id = o1.organization_id

Line 256: FROM hr_organization_units o1

252:
253: Cursor csr_Legal_Emp_Contact ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
254: IS
255: SELECT hoi4.ORG_INFORMATION2 contact_person , hoi3.ORG_INFORMATION2 phone ,hoi2.ORG_INFORMATION2 fax
256: FROM hr_organization_units o1
257: , hr_organization_information hoi1
258: , hr_organization_information hoi2
259: , hr_organization_information hoi3
260: , hr_organization_information hoi4

Line 281: FROM hr_organization_units o1

277:
278: Cursor csr_Local_Unit_contact ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)
279: IS
280: SELECT hoi4.ORG_INFORMATION2 contact_person , hoi3.ORG_INFORMATION2 phone ,hoi2.ORG_INFORMATION2 fax
281: FROM hr_organization_units o1
282: , hr_organization_information hoi1
283: , hr_organization_information hoi2
284: , hr_organization_information hoi3
285: , hr_organization_information hoi4

Line 307: FROM hr_organization_units o1

303: Cursor csr_Local_Unit_addr ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)
304: IS
305: SELECT hoi1.ADDRESS_LINE_1 , hoi1.ADDRESS_LINE_2 , hoi1.ADDRESS_LINE_3 ,
306: hoi1.POSTAL_CODE , hoi1.TOWN_OR_CITY , hoi1.COUNTRY
307: FROM hr_organization_units o1
308: , hr_locations hoi1
309: ,hr_organization_information hoi2
310: WHERE o1.business_group_id = l_business_group_id
311: AND hoi1.location_id = o1.location_id

Line 323: FROM hr_organization_units o1

319: Cursor csr_Legal_Emp_addr ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
320: IS
321: SELECT hoi1.ADDRESS_LINE_1 , hoi1.ADDRESS_LINE_2 , hoi1.ADDRESS_LINE_3 ,
322: hoi1.POSTAL_CODE , hoi1.TOWN_OR_CITY , hoi1.COUNTRY
323: FROM hr_organization_units o1
324: , hr_locations hoi1
325: ,hr_organization_information hoi2
326: WHERE o1.business_group_id = l_business_group_id
327: AND hoi1.location_id = o1.location_id

Line 339: FROM hr_organization_units o1

335:
336: Cursor csr_Tax_Office_Details ( csr_v_tax_office_id hr_organization_information.ORGANIZATION_ID%TYPE)
337: IS
338: SELECT o1.name ,hoi2.ORG_INFORMATION1 ,hoi2.ORG_INFORMATION2
339: FROM hr_organization_units o1
340: , hr_organization_information hoi1
341: , hr_organization_information hoi2
342: , hr_organization_information hoi3
343: WHERE o1.business_group_id =l_business_group_id