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 1895: , pay_element_classifications classification

1891: ,iv.uom uom
1892: FROM pay_element_types_f et
1893: , pay_element_types_f_tl pettl
1894: , pay_input_values_f iv
1895: , pay_element_classifications classification
1896: WHERE et.element_type_id = iv.element_type_id
1897: AND et.element_type_id = pettl.element_type_id
1898: AND pettl.language = USERENV('LANG')
1899: AND iv.name = 'Pay Value'

Line 1922: , pay_element_classifications classification

1918: ,iv.uom uom
1919: FROM pay_element_types_f et
1920: , pay_element_types_f_tl pettl
1921: , pay_input_values_f iv
1922: , pay_element_classifications classification
1923: WHERE et.element_type_id = iv.element_type_id
1924: AND et.element_type_id = pettl.element_type_id
1925: AND pettl.language = USERENV('LANG')
1926: AND iv.name = 'Pay Value'

Line 1950: , pay_element_classifications classification

1946: ,classification.classification_name ele_class
1947: FROM pay_element_types_f et
1948: , pay_element_types_f_tl pettl
1949: , pay_input_values_f iv
1950: , pay_element_classifications classification
1951: WHERE et.element_type_id = iv.element_type_id
1952: AND et.element_type_id = pettl.element_type_id
1953: AND pettl.language = USERENV('LANG')
1954: AND iv.name = 'Pay Value'

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

1968: 'Benefits Not Taxed',11,'Expenses Information',12,'Taxable Expenses',13) ;
1969:
1970: */
1971:
1972: CURSOR csr_element_info (p_ele_class_name pay_element_classifications.classification_name%type ) IS
1973: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1974: ,et.element_type_id element_type_id
1975: ,iv.input_value_id input_value_id
1976: ,iv.uom uom

Line 1981: , pay_element_classifications classification

1977: ,classification.classification_name ele_class
1978: FROM pay_element_types_f et
1979: , pay_element_types_f_tl pettl
1980: , pay_input_values_f iv
1981: , pay_element_classifications classification
1982: WHERE et.element_type_id = iv.element_type_id
1983: AND et.element_type_id = pettl.element_type_id
1984: AND pettl.language = USERENV('LANG')
1985: AND iv.name = 'Pay Value'

Line 2034: ,pay_element_classifications eleclass

2030: ,'Additional Taxable Pay _ Supplemental Earnings',2,'Additional Taxable Pay _ Taxable Benefits',2,0) percent_base
2031: ,decode (eleclass.classification_name,'Holiday Pay',3,0) holiday_pay
2032:
2033: FROM pay_sub_classification_rules_f subclass
2034: ,pay_element_classifications eleclass
2035:
2036: WHERE subclass.element_type_id = p_ele_type_id
2037: AND p_date_earned BETWEEN subclass.effective_start_date AND subclass.effective_end_date
2038: AND ((subclass.business_group_id IS NULL AND subclass.legislation_code = 'NO')

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

2042: AND eleclass.classification_id = subclass.classification_id ;
2043:
2044: */
2045:
2046: CURSOR csr_sub_class (p_ele_type_id NUMBER , p_ele_sub_class_name pay_element_classifications.classification_name%type ) IS
2047: SELECT 1
2048: FROM pay_sub_classification_rules_f subclass
2049: ,pay_element_classifications eleclass
2050: WHERE subclass.element_type_id = p_ele_type_id

Line 2049: ,pay_element_classifications eleclass

2045:
2046: CURSOR csr_sub_class (p_ele_type_id NUMBER , p_ele_sub_class_name pay_element_classifications.classification_name%type ) IS
2047: SELECT 1
2048: FROM pay_sub_classification_rules_f subclass
2049: ,pay_element_classifications eleclass
2050: WHERE subclass.element_type_id = p_ele_type_id
2051: AND eleclass.classification_name = p_ele_sub_class_name
2052: AND p_date_earned BETWEEN subclass.effective_start_date AND subclass.effective_end_date
2053: AND ((subclass.business_group_id IS NULL AND subclass.legislation_code = 'NO')

Line 2066: ,pay_element_classifications eleclass

2062: /*
2063: CURSOR csr_hol_sub_class (p_ele_type_id NUMBER ) IS
2064: SELECT 'YES'
2065: FROM pay_sub_classification_rules_f subclass
2066: ,pay_element_classifications eleclass
2067: WHERE subclass.element_type_id = p_ele_type_id
2068: AND eleclass.classification_id = subclass.classification_id
2069: AND eleclass.classification_name in ( 'Holiday Pay Base _ Absence',
2070: 'Holiday Pay Base _ Earnings',

Line 2088: ,pay_element_classifications eleclass

2084: /*
2085: CURSOR csr_hol_sub_class (p_ele_type_id NUMBER ) IS
2086: SELECT 'YES'
2087: FROM pay_sub_classification_rules_f subclass
2088: ,pay_element_classifications eleclass
2089: WHERE subclass.element_type_id = p_ele_type_id
2090: AND eleclass.classification_id = subclass.classification_id
2091: AND eleclass.classification_name in ( 'Holiday Pay Base _ Absence',
2092: 'Holiday Pay Base _ Earnings',

Line 2109: ,pay_element_classifications eleclass

2105: /*
2106: CURSOR csr_hol_sub_class (p_ele_type_id NUMBER ) IS
2107: SELECT 'YES'
2108: FROM pay_sub_classification_rules_f subclass
2109: ,pay_element_classifications eleclass
2110: WHERE subclass.element_type_id = p_ele_type_id
2111: AND eleclass.classification_id = subclass.classification_id
2112: AND eleclass.classification_name in ( 'Holiday Pay Base _ Absence',
2113: 'Holiday Pay Base _ Earnings',

Line 2132: ,pay_element_classifications eleclass

2128:
2129: CURSOR csr_hol_sub_class (p_ele_type_id NUMBER ) IS
2130: SELECT 'YES'
2131: FROM pay_sub_classification_rules_f subclass
2132: ,pay_element_classifications eleclass
2133: WHERE subclass.element_type_id = p_ele_type_id
2134: AND eleclass.classification_id = subclass.classification_id
2135: AND eleclass.classification_name in ( 'Holiday Pay Base _ Absence',
2136: 'Holiday Pay Base _ Earnings',

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

2159: l_basis_text VARCHAR2(240);
2160: l_holiday_text VARCHAR2(240);
2161: l_index NUMBER;
2162:
2163: TYPE ele_class_rec IS RECORD ( ele_class_name pay_element_classifications.classification_name%type
2164: , ele_context VARCHAR2(20) );
2165:
2166: TYPE ele_class_tab IS TABLE OF ele_class_rec INDEX BY BINARY_INTEGER;
2167:

Line 2970: ,pay_element_classifications pec

2966: ,hoi.org_information7 element_narrative
2967: ,pec.classification_name
2968: ,piv.uom
2969: FROM hr_organization_information hoi
2970: ,pay_element_classifications pec
2971: ,pay_element_types_f pet
2972: ,pay_input_values_f piv
2973: WHERE hoi.organization_id = p_bus_grp_id
2974: AND hoi.org_information_context = 'Business Group:Payslip Info'

Line 4230: , pay_element_classifications classification

4226: ,iv.uom uom
4227: FROM pay_element_types_f et
4228: , pay_element_types_f_tl pettl
4229: , pay_input_values_f iv
4230: , pay_element_classifications classification
4231: WHERE et.element_type_id = iv.element_type_id
4232: AND et.element_type_id = pettl.element_type_id
4233: AND pettl.language = USERENV('LANG')
4234: AND iv.name = 'Pay Value'

Line 4257: , pay_element_classifications classification

4253: ,iv.uom uom
4254: FROM pay_element_types_f et
4255: , pay_element_types_f_tl pettl
4256: , pay_input_values_f iv
4257: , pay_element_classifications classification
4258: WHERE et.element_type_id = iv.element_type_id
4259: AND et.element_type_id = pettl.element_type_id
4260: AND pettl.language = USERENV('LANG')
4261: AND iv.name = 'Pay Value'