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

Line 238: from HR_ORGANIZATION_UNITS o1

234: csr_local_unit_ID NUMBER
235: )
236: is
237: select o1.NAME LU_NAME,hoi2.ORG_INFORMATION2 CFAR
238: from HR_ORGANIZATION_UNITS o1
239: , HR_ORGANIZATION_INFORMATION hoi1
240: , HR_ORGANIZATION_INFORMATION hoi2
241: WHERE o1.business_group_id = g_business_group_id
242: and hoi1.organization_id = o1.organization_id

Line 368: FROM hr_organization_units o1

364: IS
365: SELECT o1.NAME legal_employer_name
366: -- , hoi2.org_information2 org_number
367: -- , hoi1.organization_id legal_id
368: FROM hr_organization_units o1
369: , hr_organization_information hoi1
370: , hr_organization_information hoi2
371: WHERE o1.business_group_id = g_business_group_id
372: AND hoi1.organization_id = o1.organization_id

Line 486: hr_organization_units.organization_id%TYPE)

482: FROM pay_Assignment_actions WHERE
483: payroll_action_id=csr_v_payroll_action_id; --23
484:
485: CURSOR csr_Local_unit_Legal(csr_v_legal_unit_id
486: hr_organization_units.organization_id%TYPE)
487: IS
488: SELECT hoi2.ORG_INFORMATION1 local_unit_id
489: FROM hr_organization_units o1
490: , hr_organization_information hoi1

Line 489: FROM hr_organization_units o1

485: CURSOR csr_Local_unit_Legal(csr_v_legal_unit_id
486: hr_organization_units.organization_id%TYPE)
487: IS
488: SELECT hoi2.ORG_INFORMATION1 local_unit_id
489: FROM hr_organization_units o1
490: , hr_organization_information hoi1
491: , hr_organization_information hoi2
492: WHERE o1.business_group_id =g_business_group_id
493: AND hoi1.organization_id = o1.organization_id

Line 507: FROM hr_organization_units o1

503: IS
504: SELECT o1.NAME local_unit_name
505: -- , hoi2.org_information2 org_number
506: -- , hoi1.organization_id legal_id
507: FROM hr_organization_units o1
508: , hr_organization_information hoi1
509: , hr_organization_information hoi2
510: WHERE o1.business_group_id = g_business_group_id
511: AND hoi1.organization_id = o1.organization_id

Line 744: from HR_ORGANIZATION_UNITS o1

740: csr_local_unit_ID NUMBER
741: )
742: is
743: select o1.NAME LU_NAME,hoi2.ORG_INFORMATION2 CFAR
744: from HR_ORGANIZATION_UNITS o1
745: , HR_ORGANIZATION_INFORMATION hoi1
746: , HR_ORGANIZATION_INFORMATION hoi2
747: WHERE o1.business_group_id = g_business_group_id
748: and hoi1.organization_id = o1.organization_id

Line 874: FROM hr_organization_units o1

870: IS
871: SELECT o1.NAME legal_employer_name
872: -- , hoi2.org_information2 org_number
873: -- , hoi1.organization_id legal_id
874: FROM hr_organization_units o1
875: , hr_organization_information hoi1
876: , hr_organization_information hoi2
877: WHERE o1.business_group_id = g_business_group_id
878: AND hoi1.organization_id = o1.organization_id

Line 1023: hr_organization_units.organization_id%TYPE)

1019: FROM pay_Assignment_actions WHERE
1020: payroll_action_id=csr_v_payroll_action_id; --23
1021:
1022: CURSOR csr_Local_unit_Legal(csr_v_legal_unit_id
1023: hr_organization_units.organization_id%TYPE)
1024: IS
1025: SELECT hoi2.ORG_INFORMATION1 local_unit_id
1026: FROM hr_organization_units o1
1027: , hr_organization_information hoi1

Line 1026: FROM hr_organization_units o1

1022: CURSOR csr_Local_unit_Legal(csr_v_legal_unit_id
1023: hr_organization_units.organization_id%TYPE)
1024: IS
1025: SELECT hoi2.ORG_INFORMATION1 local_unit_id
1026: FROM hr_organization_units o1
1027: , hr_organization_information hoi1
1028: , hr_organization_information hoi2
1029: WHERE o1.business_group_id =g_business_group_id
1030: AND hoi1.organization_id = o1.organization_id

Line 1044: FROM hr_organization_units o1

1040: IS
1041: SELECT o1.NAME local_unit_name
1042: -- , hoi2.org_information2 org_number
1043: -- , hoi1.organization_id legal_id
1044: FROM hr_organization_units o1
1045: , hr_organization_information hoi1
1046: , hr_organization_information hoi2
1047: WHERE o1.business_group_id = g_business_group_id
1048: AND hoi1.organization_id = o1.organization_id

Line 3597: l_legal_employer hr_organization_units.name%type;

3593: l_employee_category per_all_assignments_f.employee_category%type;
3594: l_lu_salary NUMBER;
3595: l_salary NUMBER:=0;
3596: l_grand_salary NUMBER:=0;
3597: l_legal_employer hr_organization_units.name%type;
3598: l_local_unit hr_organization_units.name%type;
3599: l_action_information_id pay_action_information.action_information_id%TYPE;
3600: l_month varchar2(20);
3601: l_year NUMBER;

Line 3598: l_local_unit hr_organization_units.name%type;

3594: l_lu_salary NUMBER;
3595: l_salary NUMBER:=0;
3596: l_grand_salary NUMBER:=0;
3597: l_legal_employer hr_organization_units.name%type;
3598: l_local_unit hr_organization_units.name%type;
3599: l_action_information_id pay_action_information.action_information_id%TYPE;
3600: l_month varchar2(20);
3601: l_year NUMBER;
3602: l_retroactive_date_from DATE;

Line 4074: l_local_unit_id hr_organization_units.organization_id%type;

4070: l_regular_women NUMBER;
4071: l_temp_men NUMBER;
4072: l_temp_women NUMBER;*/
4073: l_person_number VARCHAR2(50);
4074: l_local_unit_id hr_organization_units.organization_id%type;
4075: l_period varchar2(50);
4076:
4077: --l_local_unit hr_organization_units.name%TYPE;
4078:

Line 4077: --l_local_unit hr_organization_units.name%TYPE;

4073: l_person_number VARCHAR2(50);
4074: l_local_unit_id hr_organization_units.organization_id%type;
4075: l_period varchar2(50);
4076:
4077: --l_local_unit hr_organization_units.name%TYPE;
4078:
4079: BEGIN
4080:
4081: