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

Line 147: l_emp_id hr_organization_units.organization_id%TYPE ;

143: l_canonical_end_date DATE;
144: l_effective_date DATE;
145: l_legal_employer_id NUMBER ;
146: l_local_unit_id NUMBER ;
147: l_emp_id hr_organization_units.organization_id%TYPE ;
148: l_lu_name hr_organization_units.name%TYPE ;
149: l_business_id hr_organization_information.org_information1%TYPE ;
150: l_archive VARCHAR2(3);
151:

Line 148: l_lu_name hr_organization_units.name%TYPE ;

144: l_effective_date DATE;
145: l_legal_employer_id NUMBER ;
146: l_local_unit_id NUMBER ;
147: l_emp_id hr_organization_units.organization_id%TYPE ;
148: l_lu_name hr_organization_units.name%TYPE ;
149: l_business_id hr_organization_information.org_information1%TYPE ;
150: l_archive VARCHAR2(3);
151:
152: l_le_name hr_organization_units.name%TYPE ;

Line 152: l_le_name hr_organization_units.name%TYPE ;

148: l_lu_name hr_organization_units.name%TYPE ;
149: l_business_id hr_organization_information.org_information1%TYPE ;
150: l_archive VARCHAR2(3);
151:
152: l_le_name hr_organization_units.name%TYPE ;
153: l_org_number hr_organization_information.org_information1%TYPE ;
154: l_municipal_no hr_organization_information.org_information1%TYPE ;
155: l_industry_status hr_organization_information.org_information1%TYPE ;
156: l_tax_office_name hr_organization_units.name%TYPE ;

Line 156: l_tax_office_name hr_organization_units.name%TYPE ;

152: l_le_name hr_organization_units.name%TYPE ;
153: l_org_number hr_organization_information.org_information1%TYPE ;
154: l_municipal_no hr_organization_information.org_information1%TYPE ;
155: l_industry_status hr_organization_information.org_information1%TYPE ;
156: l_tax_office_name hr_organization_units.name%TYPE ;
157: l_tax_office_id hr_organization_information.organization_id%TYPE ;
158:
159: l_address_line_1 hr_locations.address_line_1%TYPE ;
160: l_address_line_2 hr_locations.address_line_2%TYPE ;

Line 234: FROM hr_organization_units o1

230:
231: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)
232: IS
233: SELECT o1.name , hoi2.ORG_INFORMATION4
234: FROM hr_organization_units o1
235: , hr_organization_information hoi1
236: , hr_organization_information hoi2
237: WHERE o1.business_group_id =l_business_group_id
238: AND hoi1.organization_id = o1.organization_id

Line 250: FROM hr_organization_units o1

246:
247: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
248: IS
249: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2 , hoi2.ORG_INFORMATION3 , hoi2.ORG_INFORMATION5
250: FROM hr_organization_units o1
251: , hr_organization_information hoi1
252: , hr_organization_information hoi2
253: WHERE o1.business_group_id =l_business_group_id
254: AND hoi1.organization_id = o1.organization_id

Line 267: FROM hr_organization_units o1

263:
264: Cursor csr_Legal_Emp_Contact ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
265: IS
266: SELECT hoi2.ORG_INFORMATION2 email , hoi3.ORG_INFORMATION2 phone
267: FROM hr_organization_units o1
268: , hr_organization_information hoi1
269: , hr_organization_information hoi2
270: , hr_organization_information hoi3
271: WHERE o1.business_group_id =l_business_group_id

Line 289: FROM hr_organization_units o1

285: Cursor csr_Legal_Emp_addr ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
286: IS
287: SELECT hoi1.ADDRESS_LINE_1 , hoi1.ADDRESS_LINE_2 , hoi1.ADDRESS_LINE_3 ,
288: hoi1.POSTAL_CODE , SUBSTR(hlu.MEANING , INSTR(hlu.MEANING,' ', 1,1) , LENGTH(hlu.MEANING) -(INSTR(hlu.MEANING,' ', 1,1) -1) ) POSTAL_OFFICE
289: FROM hr_organization_units o1
290: , hr_locations hoi1
291: ,hr_organization_information hoi2
292: ,hr_lookups hlu
293: WHERE o1.business_group_id = l_business_group_id

Line 312: FROM hr_organization_units o1

308: Cursor csr_Tax_Office_Details ( csr_v_tax_office_id hr_organization_information.ORGANIZATION_ID%TYPE)
309: IS
310: SELECT o1.name , hoi1.ADDRESS_LINE_1 , hoi1.ADDRESS_LINE_2 , hoi1.ADDRESS_LINE_3 ,
311: hoi1.POSTAL_CODE , SUBSTR(hlu.MEANING , INSTR(hlu.MEANING,' ', 1,1) ) POSTAL_OFFICE
312: FROM hr_organization_units o1
313: , hr_locations hoi1
314: ,hr_organization_information hoi2
315: ,hr_lookups hlu
316: WHERE o1.business_group_id = l_business_group_id

Line 369: FROM hr_organization_units o1

365: AND act.TAX_UNIT_ID = p_legal_employer_id
366: AND hsck.SOFT_CODING_KEYFLEX_ID=as1.SOFT_CODING_KEYFLEX_ID
367: AND EXISTS
368: ( SELECT hoi1.organization_id
369: FROM hr_organization_units o1
370: , hr_organization_information hoi1
371: , hr_organization_information hoi2
372: , hr_organization_information hoi3
373: , hr_organization_information hoi4

Line 487: FROM hr_organization_units o1

483:
484: CURSOR csr_lu_dtls(p_legal_employer_id NUMBER )
485: IS
486: SELECT hoi1.organization_id
487: FROM hr_organization_units o1
488: , hr_organization_information hoi1
489: , hr_organization_information hoi2
490: , hr_organization_information hoi3
491: , hr_organization_information hoi4

Line 515: FROM hr_organization_units o1

511:
512: Cursor csr_Local_Unit_EL ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE, p_date_earned DATE)
513: IS
514: SELECT hoi2.org_information1
515: FROM hr_organization_units o1
516: , hr_organization_information hoi1
517: , hr_organization_information hoi2
518: WHERE o1.business_group_id =l_business_group_id
519: AND hoi1.organization_id = o1.organization_id

Line 533: FROM hr_organization_units o1

529:
530: Cursor csr_Legal_Emp_EL( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE, p_date_earned DATE)
531: IS
532: SELECT hoi2.org_information1
533: FROM hr_organization_units o1
534: , hr_organization_information hoi1
535: , hr_organization_information hoi2
536: WHERE o1.business_group_id =l_business_group_id
537: AND hoi1.organization_id = o1.organization_id