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_SALARY_STRUCTURE_STATS dependencies on HR_LOOKUPS

Line 216: ,hr_lookups hl

212: hoi2.org_information4 Weekend_duty_pay
213: FROM hr_organization_units o1
214: , hr_organization_information hoi1
215: , hr_organization_information hoi2
216: ,hr_lookups hl
217: WHERE o1.business_group_id =csr_v_business_group_id --3133 --l_business_group_id
218: AND hoi1.organization_id = o1.organization_id
219: AND hoi1.organization_id = csr_v_legal_employer_id --3134 --csr_v_legal_unit_id
220: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 300: FROM hr_lookups

296:
297: CURSOR csr_sep_month (csr_v_month NUMBER)
298: IS
299: SELECT MEANING
300: FROM hr_lookups
301: WHERE LOOKUP_TYPE = 'HR_SE_SEPTEMBER'
302: AND ENABLED_FLAG = 'Y'
303: AND LOOKUP_CODE = csr_v_month; -- 01;
304:

Line 602: ,hr_lookups hl

598: hoi2.org_information4 Weekend_duty_pay
599: FROM hr_organization_units o1
600: , hr_organization_information hoi1
601: , hr_organization_information hoi2
602: ,hr_lookups hl
603: WHERE o1.business_group_id =csr_v_business_group_id --3133 --l_business_group_id
604: AND hoi1.organization_id = o1.organization_id
605: AND hoi1.organization_id = csr_v_legal_employer_id --3134 --csr_v_legal_unit_id
606: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 664: hr_lookups hl

660: CURSOR csr_extra_assignment(csr_v_assignment_id per_all_assignments_f.assignment_id%type)
661: IS
662: SELECT hl.meaning
663: FROM per_assignment_extra_info,
664: hr_lookups hl
665: WHERE assignment_id = csr_v_assignment_id --32516 --p_assignment_id
666: AND information_type = 'SE_SALARY_STRUCTURE'
667: AND hl.LOOKUP_TYPE='SE_WORKING_HOUR_TYPE'
668: AND hl.lookup_code=aei_information1;

Line 740: CURSOR csr_lookup_values(csr_v_lookup_type hr_lookups.lookup_type%TYPE,

736: AND papf.CURRENT_EMPLOYEE_FLAG='Y'
737: AND paaf.payroll_id IS NOT NULL
738: ORDER BY papf.person_id;
739:
740: CURSOR csr_lookup_values(csr_v_lookup_type hr_lookups.lookup_type%TYPE,
741: csr_v_lookup_code hr_lookups.lookup_code%TYPE)
742: IS
743: SELECT meaning FROM hr_lookups WHERE
744: lookup_type =csr_v_lookup_type --'SE_AGREEMENT_CODE'

Line 741: csr_v_lookup_code hr_lookups.lookup_code%TYPE)

737: AND paaf.payroll_id IS NOT NULL
738: ORDER BY papf.person_id;
739:
740: CURSOR csr_lookup_values(csr_v_lookup_type hr_lookups.lookup_type%TYPE,
741: csr_v_lookup_code hr_lookups.lookup_code%TYPE)
742: IS
743: SELECT meaning FROM hr_lookups WHERE
744: lookup_type =csr_v_lookup_type --'SE_AGREEMENT_CODE'
745: AND LOOKUP_CODE=csr_v_lookup_code ;

Line 743: SELECT meaning FROM hr_lookups WHERE

739:
740: CURSOR csr_lookup_values(csr_v_lookup_type hr_lookups.lookup_type%TYPE,
741: csr_v_lookup_code hr_lookups.lookup_code%TYPE)
742: IS
743: SELECT meaning FROM hr_lookups WHERE
744: lookup_type =csr_v_lookup_type --'SE_AGREEMENT_CODE'
745: AND LOOKUP_CODE=csr_v_lookup_code ;
746:
747:

Line 798: l_agreement_code hr_lookups.meaning%TYPE;

794: l_check_insert number;
795: l_worksite_number varchar2(10);
796: l_association_number varchar2(10);
797: l_legal_agreement_code varchar2(10);
798: l_agreement_code hr_lookups.meaning%TYPE;
799: l_agreement hr_lookups.lookup_code%TYPE;
800: l_asg_agreement_code hr_lookups.meaning%TYPE;
801: l_weekend_duty varchar2(10);
802: l_legal_employer hr_organization_units.name%TYPE;

Line 799: l_agreement hr_lookups.lookup_code%TYPE;

795: l_worksite_number varchar2(10);
796: l_association_number varchar2(10);
797: l_legal_agreement_code varchar2(10);
798: l_agreement_code hr_lookups.meaning%TYPE;
799: l_agreement hr_lookups.lookup_code%TYPE;
800: l_asg_agreement_code hr_lookups.meaning%TYPE;
801: l_weekend_duty varchar2(10);
802: l_legal_employer hr_organization_units.name%TYPE;
803: l_organization_id varchar2(20);

Line 800: l_asg_agreement_code hr_lookups.meaning%TYPE;

796: l_association_number varchar2(10);
797: l_legal_agreement_code varchar2(10);
798: l_agreement_code hr_lookups.meaning%TYPE;
799: l_agreement hr_lookups.lookup_code%TYPE;
800: l_asg_agreement_code hr_lookups.meaning%TYPE;
801: l_weekend_duty varchar2(10);
802: l_legal_employer hr_organization_units.name%TYPE;
803: l_organization_id varchar2(20);
804: l_membership_number varchar2(10);

Line 807: l_ssyk hr_lookups.lookup_code%TYPE;

803: l_organization_id varchar2(20);
804: l_membership_number varchar2(10);
805: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
806: l_person_id per_all_people_f.person_id%TYPE;
807: l_ssyk hr_lookups.lookup_code%TYPE;
808: l_ssyk_code hr_lookups.meaning%TYPE;
809: l_association_code varchar2(10);
810: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
811: l_work_type varchar2(250);

Line 808: l_ssyk_code hr_lookups.meaning%TYPE;

804: l_membership_number varchar2(10);
805: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
806: l_person_id per_all_people_f.person_id%TYPE;
807: l_ssyk hr_lookups.lookup_code%TYPE;
808: l_ssyk_code hr_lookups.meaning%TYPE;
809: l_association_code varchar2(10);
810: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
811: l_work_type varchar2(250);
812: l_salary_type Number(1);

Line 2013: l_employee_category hr_lookups.meaning%type;

2009:
2010:
2011: /* Cursor to fetch Header Information */
2012:
2013: l_employee_category hr_lookups.meaning%type;
2014: l_weekend_pay_duty hr_lookups.meaning%type;
2015: l_working_hour_code hr_lookups.lookup_code%type;
2016: l_lu_salary NUMBER;
2017: l_salary NUMBER:=0;

Line 2014: l_weekend_pay_duty hr_lookups.meaning%type;

2010:
2011: /* Cursor to fetch Header Information */
2012:
2013: l_employee_category hr_lookups.meaning%type;
2014: l_weekend_pay_duty hr_lookups.meaning%type;
2015: l_working_hour_code hr_lookups.lookup_code%type;
2016: l_lu_salary NUMBER;
2017: l_salary NUMBER:=0;
2018: l_grand_salary NUMBER:=0;

Line 2015: l_working_hour_code hr_lookups.lookup_code%type;

2011: /* Cursor to fetch Header Information */
2012:
2013: l_employee_category hr_lookups.meaning%type;
2014: l_weekend_pay_duty hr_lookups.meaning%type;
2015: l_working_hour_code hr_lookups.lookup_code%type;
2016: l_lu_salary NUMBER;
2017: l_salary NUMBER:=0;
2018: l_grand_salary NUMBER:=0;
2019: l_legal_employer hr_organization_units.name%type;

Line 2189: hr_lookups WHERE lookup_type =csr_v_lookup_type-- 'EMPLOYEE_CATG'

2185:
2186: CURSOR csr_lookup_values(csr_v_lookup_type varchar2, csr_v_lookup_code varchar2)
2187: IS
2188: SELECT meaning FROM
2189: hr_lookups WHERE lookup_type =csr_v_lookup_type-- 'EMPLOYEE_CATG'
2190: AND lookup_code=csr_v_lookup_code; -- 'WC'
2191:
2192: CURSOR csr_lookup_code(csr_v_lookup_type varchar2, csr_v_lookup_meaning varchar2)
2193: IS

Line 2195: hr_lookups WHERE lookup_type =csr_v_lookup_type-- 'EMPLOYEE_CATG'

2191:
2192: CURSOR csr_lookup_code(csr_v_lookup_type varchar2, csr_v_lookup_meaning varchar2)
2193: IS
2194: SELECT lookup_code FROM
2195: hr_lookups WHERE lookup_type =csr_v_lookup_type-- 'EMPLOYEE_CATG'
2196: AND meaning=csr_v_lookup_meaning; -- 'WC'
2197:
2198:
2199: l_counter NUMBER:=0;