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

Line 212: from HR_ORGANIZATION_UNITS o1

208:
209: -- Cursor for getting the Insurance Number
210: CURSOR csr_Insurance_Number(csr_v_legal_employer_id NUMBER) is
211: select /*o1.NAME LU_NAME,*/ hoi2.ORG_INFORMATION6 Insurance_Number
212: from HR_ORGANIZATION_UNITS o1
213: , HR_ORGANIZATION_INFORMATION hoi1
214: , HR_ORGANIZATION_INFORMATION hoi2
215: WHERE o1.business_group_id = g_business_group_id --3133
216: and hoi1.organization_id = o1.organization_id

Line 230: from HR_ORGANIZATION_UNITS o1

226: csr_local_unit_ID NUMBER
227: )
228: is
229: select o1.NAME LU_NAME,hoi2.ORG_INFORMATION2 CFAR
230: from HR_ORGANIZATION_UNITS o1
231: , HR_ORGANIZATION_INFORMATION hoi1
232: , HR_ORGANIZATION_INFORMATION hoi2
233: WHERE o1.business_group_id = g_business_group_id
234: and hoi1.organization_id = o1.organization_id

Line 389: FROM hr_organization_units o1

385: IS
386: SELECT o1.NAME legal_employer_name
387: -- , hoi2.org_information2 org_number
388: -- , hoi1.organization_id legal_id
389: FROM hr_organization_units o1
390: , hr_organization_information hoi1
391: , hr_organization_information hoi2
392: WHERE o1.business_group_id = g_business_group_id
393: AND hoi1.organization_id = o1.organization_id

Line 449: hr_organization_units.organization_id%TYPE)

445: FROM pay_Assignment_actions WHERE
446: payroll_action_id=csr_v_payroll_action_id; --23
447:
448: CURSOR csr_Local_unit_Legal(csr_v_legal_unit_id
449: hr_organization_units.organization_id%TYPE)
450: IS
451: SELECT hoi2.ORG_INFORMATION1 local_unit_id
452: FROM hr_organization_units o1
453: , hr_organization_information hoi1

Line 452: FROM hr_organization_units o1

448: CURSOR csr_Local_unit_Legal(csr_v_legal_unit_id
449: hr_organization_units.organization_id%TYPE)
450: IS
451: SELECT hoi2.ORG_INFORMATION1 local_unit_id
452: FROM hr_organization_units o1
453: , hr_organization_information hoi1
454: , hr_organization_information hoi2
455: WHERE o1.business_group_id =g_business_group_id
456: AND hoi1.organization_id = o1.organization_id

Line 470: FROM hr_organization_units o1

466: IS
467: SELECT o1.NAME local_unit_name
468: -- , hoi2.org_information2 org_number
469: -- , hoi1.organization_id legal_id
470: FROM hr_organization_units o1
471: , hr_organization_information hoi1
472: , hr_organization_information hoi2
473: WHERE o1.business_group_id = g_business_group_id
474: AND hoi1.organization_id = o1.organization_id

Line 531: l_local_unit_id hr_organization_units.organization_id%type; --NUMBER;

527: L_MONTH_END_DATE DATE;
528: L_LOCAL_UNIT_NAME VARCHAR2(50);
529: l_person_id NUMBER;
530: l_sex CHAR(1);
531: l_local_unit_id hr_organization_units.organization_id%type; --NUMBER;
532: l_current_local_unit_id hr_organization_units.organization_id%type;
533: l_next_local_unit_id hr_organization_units.organization_id%type;
534: l_check_local_unit_id hr_organization_units.organization_id%type; -- NUMBER
535: l_assignment_category VARCHAR2(5);

Line 532: l_current_local_unit_id hr_organization_units.organization_id%type;

528: L_LOCAL_UNIT_NAME VARCHAR2(50);
529: l_person_id NUMBER;
530: l_sex CHAR(1);
531: l_local_unit_id hr_organization_units.organization_id%type; --NUMBER;
532: l_current_local_unit_id hr_organization_units.organization_id%type;
533: l_next_local_unit_id hr_organization_units.organization_id%type;
534: l_check_local_unit_id hr_organization_units.organization_id%type; -- NUMBER
535: l_assignment_category VARCHAR2(5);
536: l_assignment_start_date DATE;

Line 533: l_next_local_unit_id hr_organization_units.organization_id%type;

529: l_person_id NUMBER;
530: l_sex CHAR(1);
531: l_local_unit_id hr_organization_units.organization_id%type; --NUMBER;
532: l_current_local_unit_id hr_organization_units.organization_id%type;
533: l_next_local_unit_id hr_organization_units.organization_id%type;
534: l_check_local_unit_id hr_organization_units.organization_id%type; -- NUMBER
535: l_assignment_category VARCHAR2(5);
536: l_assignment_start_date DATE;
537: l_assignment_end_date DATE;

Line 534: l_check_local_unit_id hr_organization_units.organization_id%type; -- NUMBER

530: l_sex CHAR(1);
531: l_local_unit_id hr_organization_units.organization_id%type; --NUMBER;
532: l_current_local_unit_id hr_organization_units.organization_id%type;
533: l_next_local_unit_id hr_organization_units.organization_id%type;
534: l_check_local_unit_id hr_organization_units.organization_id%type; -- NUMBER
535: l_assignment_category VARCHAR2(5);
536: l_assignment_start_date DATE;
537: l_assignment_end_date DATE;
538: l_absence_count NUMBER;

Line 2232: l_local_unit_id hr_organization_units.organization_id%type;

2228: l_regular_women NUMBER;
2229: l_temp_men NUMBER;
2230: l_temp_women NUMBER;
2231: l_person_number VARCHAR2(50);
2232: l_local_unit_id hr_organization_units.organization_id%type;
2233:
2234: TYPE emp_cat_type IS VARRAY(10) OF CHAR(2);
2235: emp_cat emp_cat_type;
2236: l_local_unit hr_organization_units.name%TYPE;

Line 2236: l_local_unit hr_organization_units.name%TYPE;

2232: l_local_unit_id hr_organization_units.organization_id%type;
2233:
2234: TYPE emp_cat_type IS VARRAY(10) OF CHAR(2);
2235: emp_cat emp_cat_type;
2236: l_local_unit hr_organization_units.name%TYPE;
2237:
2238: BEGIN
2239:
2240: l_counter:=0;