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_NO_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 249: ,pay_element_classifications pec

245: ,hoi.org_information7 element_narrative
246: ,pec.classification_name ele_class
247: ,piv.uom uom
248: FROM hr_organization_information hoi
249: ,pay_element_classifications pec
250: ,pay_element_types_f pet
251: ,pay_input_values_f piv
252: WHERE hoi.organization_id = p_bus_grp_id
253: AND hoi.org_information_context = 'Business Group:Payslip Info'

Line 270: ,pay_element_classifications pec

266: ,piv.uom uom
267: ,piv.lookup_type lookup_type
268: ,piv.value_set_id value_set_id
269: FROM hr_organization_information hoi
270: ,pay_element_classifications pec
271: ,pay_element_types_f pet
272: ,pay_input_values_f piv
273: WHERE hoi.organization_id = p_bus_grp_id
274: AND hoi.org_information_context = 'Business Group:Payslip Info'

Line 320: ,pay_element_classifications eleclass

316: ,decode (eleclass.classification_name,'Additional Taxable Pay _ Absence',2,'Additional Taxable Pay _ Earnings',2
317: ,'Additional Taxable Pay _ Supplemental Earnings',2,'Additional Taxable Pay _ Taxable Benefits',2,0) percent_base
318: ,decode (eleclass.classification_name,'Holiday Pay',3,0) holiday_pay
319: FROM pay_sub_classification_rules_f subclass
320: ,pay_element_classifications eleclass
321:
322: WHERE subclass.element_type_id = p_ele_type_id
323: AND p_date_earned BETWEEN subclass.effective_start_date AND subclass.effective_end_date
324: AND ((subclass.business_group_id IS NULL AND subclass.legislation_code = 'NO')

Line 333: CURSOR csr_sub_class (p_date_earned date , p_ele_type_id NUMBER , p_ele_sub_class_name pay_element_classifications.classification_name%type ) IS

329:
330: */
331:
332:
333: CURSOR csr_sub_class (p_date_earned date , p_ele_type_id NUMBER , p_ele_sub_class_name pay_element_classifications.classification_name%type ) IS
334: SELECT 1
335: FROM pay_sub_classification_rules_f subclass
336: ,pay_element_classifications eleclass
337: WHERE subclass.element_type_id = p_ele_type_id

Line 336: ,pay_element_classifications eleclass

332:
333: CURSOR csr_sub_class (p_date_earned date , p_ele_type_id NUMBER , p_ele_sub_class_name pay_element_classifications.classification_name%type ) IS
334: SELECT 1
335: FROM pay_sub_classification_rules_f subclass
336: ,pay_element_classifications eleclass
337: WHERE subclass.element_type_id = p_ele_type_id
338: AND eleclass.classification_name = p_ele_sub_class_name
339: AND p_date_earned BETWEEN subclass.effective_start_date AND subclass.effective_end_date
340: AND ((subclass.business_group_id IS NULL AND subclass.legislation_code = 'NO')

Line 353: ,pay_element_classifications eleclass

349: /*
350: CURSOR csr_hol_sub_class (p_date_earned date , p_ele_type_id NUMBER ) IS
351: SELECT 'YES'
352: FROM pay_sub_classification_rules_f subclass
353: ,pay_element_classifications eleclass
354: WHERE subclass.element_type_id = p_ele_type_id
355: AND eleclass.classification_id = subclass.classification_id
356: AND eleclass.classification_name in ( 'Holiday Pay Base _ Absence',
357: 'Holiday Pay Base _ Earnings',

Line 375: ,pay_element_classifications eleclass

371: /*
372: CURSOR csr_hol_sub_class (p_date_earned date , p_ele_type_id NUMBER ) IS
373: SELECT 'YES'
374: FROM pay_sub_classification_rules_f subclass
375: ,pay_element_classifications eleclass
376: WHERE subclass.element_type_id = p_ele_type_id
377: AND eleclass.classification_id = subclass.classification_id
378: AND eleclass.classification_name in ( 'Holiday Pay Base _ Absence',
379: 'Holiday Pay Base _ Earnings',

Line 396: ,pay_element_classifications eleclass

392: /*
393: CURSOR csr_hol_sub_class (p_date_earned date , p_ele_type_id NUMBER ) IS
394: SELECT 'YES'
395: FROM pay_sub_classification_rules_f subclass
396: ,pay_element_classifications eleclass
397: WHERE subclass.element_type_id = p_ele_type_id
398: AND eleclass.classification_id = subclass.classification_id
399: AND eleclass.classification_name in ( 'Holiday Pay Base _ Absence',
400: 'Holiday Pay Base _ Earnings',

Line 419: ,pay_element_classifications eleclass

415:
416: CURSOR csr_hol_sub_class (p_date_earned date , p_ele_type_id NUMBER ) IS
417: SELECT 'YES'
418: FROM pay_sub_classification_rules_f subclass
419: ,pay_element_classifications eleclass
420: WHERE subclass.element_type_id = p_ele_type_id
421: AND eleclass.classification_id = subclass.classification_id
422: AND eleclass.classification_name in ( 'Holiday Pay Base _ Absence',
423: 'Holiday Pay Base _ Earnings',

Line 1884: , pay_element_classifications classification

1880: ,iv.uom uom
1881: FROM pay_element_types_f et
1882: , pay_element_types_f_tl pettl
1883: , pay_input_values_f iv
1884: , pay_element_classifications classification
1885: WHERE et.element_type_id = iv.element_type_id
1886: AND et.element_type_id = pettl.element_type_id
1887: AND pettl.language = USERENV('LANG')
1888: AND iv.name = 'Pay Value'

Line 1911: , pay_element_classifications classification

1907: ,iv.uom uom
1908: FROM pay_element_types_f et
1909: , pay_element_types_f_tl pettl
1910: , pay_input_values_f iv
1911: , pay_element_classifications classification
1912: WHERE et.element_type_id = iv.element_type_id
1913: AND et.element_type_id = pettl.element_type_id
1914: AND pettl.language = USERENV('LANG')
1915: AND iv.name = 'Pay Value'

Line 1939: , pay_element_classifications classification

1935: ,classification.classification_name ele_class
1936: FROM pay_element_types_f et
1937: , pay_element_types_f_tl pettl
1938: , pay_input_values_f iv
1939: , pay_element_classifications classification
1940: WHERE et.element_type_id = iv.element_type_id
1941: AND et.element_type_id = pettl.element_type_id
1942: AND pettl.language = USERENV('LANG')
1943: AND iv.name = 'Pay Value'

Line 1961: CURSOR csr_element_info (p_ele_class_name pay_element_classifications.classification_name%type ) IS

1957: 'Benefits Not Taxed',11,'Expenses Information',12,'Taxable Expenses',13) ;
1958:
1959: */
1960:
1961: CURSOR csr_element_info (p_ele_class_name pay_element_classifications.classification_name%type ) IS
1962: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1963: ,et.element_type_id element_type_id
1964: ,iv.input_value_id input_value_id
1965: ,iv.uom uom

Line 1970: , pay_element_classifications classification

1966: ,classification.classification_name ele_class
1967: FROM pay_element_types_f et
1968: , pay_element_types_f_tl pettl
1969: , pay_input_values_f iv
1970: , pay_element_classifications classification
1971: WHERE et.element_type_id = iv.element_type_id
1972: AND et.element_type_id = pettl.element_type_id
1973: AND pettl.language = USERENV('LANG')
1974: AND iv.name = 'Pay Value'

Line 2023: ,pay_element_classifications eleclass

2019: ,'Additional Taxable Pay _ Supplemental Earnings',2,'Additional Taxable Pay _ Taxable Benefits',2,0) percent_base
2020: ,decode (eleclass.classification_name,'Holiday Pay',3,0) holiday_pay
2021:
2022: FROM pay_sub_classification_rules_f subclass
2023: ,pay_element_classifications eleclass
2024:
2025: WHERE subclass.element_type_id = p_ele_type_id
2026: AND p_date_earned BETWEEN subclass.effective_start_date AND subclass.effective_end_date
2027: AND ((subclass.business_group_id IS NULL AND subclass.legislation_code = 'NO')

Line 2035: CURSOR csr_sub_class (p_ele_type_id NUMBER , p_ele_sub_class_name pay_element_classifications.classification_name%type ) IS

2031: AND eleclass.classification_id = subclass.classification_id ;
2032:
2033: */
2034:
2035: CURSOR csr_sub_class (p_ele_type_id NUMBER , p_ele_sub_class_name pay_element_classifications.classification_name%type ) IS
2036: SELECT 1
2037: FROM pay_sub_classification_rules_f subclass
2038: ,pay_element_classifications eleclass
2039: WHERE subclass.element_type_id = p_ele_type_id

Line 2038: ,pay_element_classifications eleclass

2034:
2035: CURSOR csr_sub_class (p_ele_type_id NUMBER , p_ele_sub_class_name pay_element_classifications.classification_name%type ) IS
2036: SELECT 1
2037: FROM pay_sub_classification_rules_f subclass
2038: ,pay_element_classifications eleclass
2039: WHERE subclass.element_type_id = p_ele_type_id
2040: AND eleclass.classification_name = p_ele_sub_class_name
2041: AND p_date_earned BETWEEN subclass.effective_start_date AND subclass.effective_end_date
2042: AND ((subclass.business_group_id IS NULL AND subclass.legislation_code = 'NO')

Line 2055: ,pay_element_classifications eleclass

2051: /*
2052: CURSOR csr_hol_sub_class (p_ele_type_id NUMBER ) IS
2053: SELECT 'YES'
2054: FROM pay_sub_classification_rules_f subclass
2055: ,pay_element_classifications eleclass
2056: WHERE subclass.element_type_id = p_ele_type_id
2057: AND eleclass.classification_id = subclass.classification_id
2058: AND eleclass.classification_name in ( 'Holiday Pay Base _ Absence',
2059: 'Holiday Pay Base _ Earnings',

Line 2077: ,pay_element_classifications eleclass

2073: /*
2074: CURSOR csr_hol_sub_class (p_ele_type_id NUMBER ) IS
2075: SELECT 'YES'
2076: FROM pay_sub_classification_rules_f subclass
2077: ,pay_element_classifications eleclass
2078: WHERE subclass.element_type_id = p_ele_type_id
2079: AND eleclass.classification_id = subclass.classification_id
2080: AND eleclass.classification_name in ( 'Holiday Pay Base _ Absence',
2081: 'Holiday Pay Base _ Earnings',

Line 2098: ,pay_element_classifications eleclass

2094: /*
2095: CURSOR csr_hol_sub_class (p_ele_type_id NUMBER ) IS
2096: SELECT 'YES'
2097: FROM pay_sub_classification_rules_f subclass
2098: ,pay_element_classifications eleclass
2099: WHERE subclass.element_type_id = p_ele_type_id
2100: AND eleclass.classification_id = subclass.classification_id
2101: AND eleclass.classification_name in ( 'Holiday Pay Base _ Absence',
2102: 'Holiday Pay Base _ Earnings',

Line 2121: ,pay_element_classifications eleclass

2117:
2118: CURSOR csr_hol_sub_class (p_ele_type_id NUMBER ) IS
2119: SELECT 'YES'
2120: FROM pay_sub_classification_rules_f subclass
2121: ,pay_element_classifications eleclass
2122: WHERE subclass.element_type_id = p_ele_type_id
2123: AND eleclass.classification_id = subclass.classification_id
2124: AND eleclass.classification_name in ( 'Holiday Pay Base _ Absence',
2125: 'Holiday Pay Base _ Earnings',

Line 2152: TYPE ele_class_rec IS RECORD ( ele_class_name pay_element_classifications.classification_name%type

2148: l_basis_text VARCHAR2(240);
2149: l_holiday_text VARCHAR2(240);
2150: l_index NUMBER;
2151:
2152: TYPE ele_class_rec IS RECORD ( ele_class_name pay_element_classifications.classification_name%type
2153: , ele_context VARCHAR2(20) );
2154:
2155: TYPE ele_class_tab IS TABLE OF ele_class_rec INDEX BY BINARY_INTEGER;
2156:

Line 2959: ,pay_element_classifications pec

2955: ,hoi.org_information7 element_narrative
2956: ,pec.classification_name
2957: ,piv.uom
2958: FROM hr_organization_information hoi
2959: ,pay_element_classifications pec
2960: ,pay_element_types_f pet
2961: ,pay_input_values_f piv
2962: WHERE hoi.organization_id = p_bus_grp_id
2963: AND hoi.org_information_context = 'Business Group:Payslip Info'

Line 4219: , pay_element_classifications classification

4215: ,iv.uom uom
4216: FROM pay_element_types_f et
4217: , pay_element_types_f_tl pettl
4218: , pay_input_values_f iv
4219: , pay_element_classifications classification
4220: WHERE et.element_type_id = iv.element_type_id
4221: AND et.element_type_id = pettl.element_type_id
4222: AND pettl.language = USERENV('LANG')
4223: AND iv.name = 'Pay Value'

Line 4246: , pay_element_classifications classification

4242: ,iv.uom uom
4243: FROM pay_element_types_f et
4244: , pay_element_types_f_tl pettl
4245: , pay_input_values_f iv
4246: , pay_element_classifications classification
4247: WHERE et.element_type_id = iv.element_type_id
4248: AND et.element_type_id = pettl.element_type_id
4249: AND pettl.language = USERENV('LANG')
4250: AND iv.name = 'Pay Value'