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 390: FROM hr_organization_units o1

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

Line 450: hr_organization_units.organization_id%TYPE)

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

Line 453: FROM hr_organization_units o1

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

Line 471: FROM hr_organization_units o1

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

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

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

Line 533: l_current_local_unit_id hr_organization_units.organization_id%type;

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

Line 534: l_next_local_unit_id hr_organization_units.organization_id%type;

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

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

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

Line 2260: l_local_unit_id hr_organization_units.organization_id%type;

2256: l_regular_women NUMBER;
2257: l_temp_men NUMBER;
2258: l_temp_women NUMBER;
2259: l_person_number VARCHAR2(50);
2260: l_local_unit_id hr_organization_units.organization_id%type;
2261: l_end_date DATE; -- Bug#9440498 fix
2262:
2263: TYPE emp_cat_type IS VARRAY(10) OF CHAR(2);
2264: emp_cat emp_cat_type;

Line 2265: l_local_unit hr_organization_units.name%TYPE;

2261: l_end_date DATE; -- Bug#9440498 fix
2262:
2263: TYPE emp_cat_type IS VARRAY(10) OF CHAR(2);
2264: emp_cat emp_cat_type;
2265: l_local_unit hr_organization_units.name%TYPE;
2266:
2267: BEGIN
2268:
2269: l_counter:=0;