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 742: CURSOR csr_lookup_values(csr_v_lookup_type hr_lookups.lookup_type%TYPE,

738: AND paaf.payroll_id IS NOT NULL
739: AND hsck.segment14 IS NOT NULL /* need not archive the person if he doesnt have agreement code */
740: ORDER BY papf.person_id;
741:
742: CURSOR csr_lookup_values(csr_v_lookup_type hr_lookups.lookup_type%TYPE,
743: csr_v_lookup_code hr_lookups.lookup_code%TYPE)
744: IS
745: SELECT meaning FROM hr_lookups WHERE
746: lookup_type =csr_v_lookup_type --'SE_AGREEMENT_CODE'

Line 743: csr_v_lookup_code hr_lookups.lookup_code%TYPE)

739: AND hsck.segment14 IS NOT NULL /* need not archive the person if he doesnt have agreement code */
740: ORDER BY papf.person_id;
741:
742: CURSOR csr_lookup_values(csr_v_lookup_type hr_lookups.lookup_type%TYPE,
743: csr_v_lookup_code hr_lookups.lookup_code%TYPE)
744: IS
745: SELECT meaning FROM hr_lookups WHERE
746: lookup_type =csr_v_lookup_type --'SE_AGREEMENT_CODE'
747: AND LOOKUP_CODE=csr_v_lookup_code ;

Line 745: SELECT meaning FROM hr_lookups WHERE

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

Line 800: l_agreement_code hr_lookups.meaning%TYPE;

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

Line 801: l_agreement hr_lookups.lookup_code%TYPE;

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

Line 802: l_asg_agreement_code hr_lookups.meaning%TYPE;

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

Line 809: l_ssyk hr_lookups.lookup_code%TYPE;

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

Line 810: l_ssyk_code hr_lookups.meaning%TYPE;

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

Line 2042: l_employee_category hr_lookups.meaning%type;

2038:
2039:
2040: /* Cursor to fetch Header Information */
2041:
2042: l_employee_category hr_lookups.meaning%type;
2043: l_weekend_pay_duty hr_lookups.meaning%type;
2044: l_working_hour_code hr_lookups.lookup_code%type;
2045: l_lu_salary NUMBER;
2046: l_salary NUMBER:=0;

Line 2043: l_weekend_pay_duty hr_lookups.meaning%type;

2039:
2040: /* Cursor to fetch Header Information */
2041:
2042: l_employee_category hr_lookups.meaning%type;
2043: l_weekend_pay_duty hr_lookups.meaning%type;
2044: l_working_hour_code hr_lookups.lookup_code%type;
2045: l_lu_salary NUMBER;
2046: l_salary NUMBER:=0;
2047: l_grand_salary NUMBER:=0;

Line 2044: l_working_hour_code hr_lookups.lookup_code%type;

2040: /* Cursor to fetch Header Information */
2041:
2042: l_employee_category hr_lookups.meaning%type;
2043: l_weekend_pay_duty hr_lookups.meaning%type;
2044: l_working_hour_code hr_lookups.lookup_code%type;
2045: l_lu_salary NUMBER;
2046: l_salary NUMBER:=0;
2047: l_grand_salary NUMBER:=0;
2048: l_legal_employer hr_organization_units.name%type;

Line 2189: ,hr_lookups hl

2185: AND pai3.action_information9 IN (SELECT
2186: hl.meaning Agreement_Code
2187: FROM hr_organization_units o1
2188: , hr_organization_information hoi1
2189: ,hr_lookups hl
2190: WHERE o1.business_group_id =g_business_group_id
2191: AND hoi1.organization_id = o1.organization_id
2192: AND hoi1.organization_id =pai1.action_information3
2193: AND hoi1.ORG_INFORMATION_CONTEXT='SE_SALARY_STRUCTURE'

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

2228:
2229: CURSOR csr_lookup_values(csr_v_lookup_type varchar2, csr_v_lookup_code varchar2)
2230: IS
2231: SELECT meaning FROM
2232: hr_lookups WHERE lookup_type =csr_v_lookup_type-- 'EMPLOYEE_CATG'
2233: AND lookup_code=csr_v_lookup_code; -- 'WC'
2234:
2235: CURSOR csr_lookup_code(csr_v_lookup_type varchar2, csr_v_lookup_meaning varchar2)
2236: IS

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

2234:
2235: CURSOR csr_lookup_code(csr_v_lookup_type varchar2, csr_v_lookup_meaning varchar2)
2236: IS
2237: SELECT lookup_code FROM
2238: hr_lookups WHERE lookup_type =csr_v_lookup_type-- 'EMPLOYEE_CATG'
2239: AND meaning=csr_v_lookup_meaning; -- 'WC'
2240:
2241: CURSOR csr_agreement_legal (csr_v_legal_employer NUMBER, csr_v_agreement VARCHAR2 )
2242: IS

Line 2249: ,hr_lookups hl

2245: hoi1.ORG_INFORMATION2 Association_Number,
2246: hoi1.ORG_INFORMATION4 Weekend_Pay_Duty
2247: FROM hr_organization_units o1
2248: , hr_organization_information hoi1
2249: ,hr_lookups hl
2250: WHERE o1.business_group_id =g_business_group_id --3133 --3133 --csr_v_business_group_id --3133 --l_business_group_id
2251: AND hoi1.organization_id = o1.organization_id
2252: AND hoi1.organization_id =csr_v_legal_employer --3134 --pai1.action_information3 --csr_v_legal_employer_id --3134 --csr_v_legal_unit_id
2253: AND hoi1.ORG_INFORMATION_CONTEXT='SE_SALARY_STRUCTURE'

Line 2275: l_working_hour_meaning hr_lookups.meaning%type;

2271: l_report_year number(4);
2272: l_local_count NUMBER;
2273: l_CFAR_Number NUMBER;
2274: l_legal_employer_id hr_organization_units.organization_id%TYPE;
2275: l_working_hour_meaning hr_lookups.meaning%type;
2276: l_association_number varchar2(10);
2277: l_worksite_number varchar2(10);
2278: l_agreement_code hr_lookups.meaning%TYPE;
2279:

Line 2278: l_agreement_code hr_lookups.meaning%TYPE;

2274: l_legal_employer_id hr_organization_units.organization_id%TYPE;
2275: l_working_hour_meaning hr_lookups.meaning%type;
2276: l_association_number varchar2(10);
2277: l_worksite_number varchar2(10);
2278: l_agreement_code hr_lookups.meaning%TYPE;
2279:
2280:
2281: --l_local_unit hr_organization_units.name%TYPE;
2282: