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_SUB_CLASSIFICATION_RULES_F

Line 319: FROM pay_sub_classification_rules_f subclass

315: ,'Taxable Pay _ Supplemental Earnings',1,'Taxable Pay _ Taxable Benefits',1,0) table_base
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

Line 335: FROM pay_sub_classification_rules_f subclass

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
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

Line 352: FROM pay_sub_classification_rules_f subclass

348:
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',

Line 374: FROM pay_sub_classification_rules_f subclass

370:
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',

Line 395: FROM pay_sub_classification_rules_f subclass

391: /* Sub classification added for Impact of Absence on Holiday Pay */
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',

Line 418: FROM pay_sub_classification_rules_f subclass

414: -- Holiday Pay Base _ Holiday Pay Earnings Adjust => Holiday Pay Base _ Holiday Pay Earnings Adjust Obsolete
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',

Line 2033: FROM pay_sub_classification_rules_f subclass

2029: ,decode (eleclass.classification_name,'Additional Taxable Pay _ Absence',2,'Additional Taxable Pay _ Earnings',2
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

Line 2048: FROM pay_sub_classification_rules_f subclass

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
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

Line 2065: FROM pay_sub_classification_rules_f subclass

2061:
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',

Line 2087: FROM pay_sub_classification_rules_f subclass

2083:
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',

Line 2108: FROM pay_sub_classification_rules_f subclass

2104: /* Sub classification added for Impact of Absence on Holiday Pay */
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',

Line 2131: FROM pay_sub_classification_rules_f subclass

2127: -- Holiday Pay Base _ Holiday Pay Earnings Adjust => Holiday Pay Base _ Holiday Pay Earnings Adjust Obsolete
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',