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 2022: FROM pay_sub_classification_rules_f subclass

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

Line 2037: FROM pay_sub_classification_rules_f subclass

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

Line 2054: FROM pay_sub_classification_rules_f subclass

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

Line 2076: FROM pay_sub_classification_rules_f subclass

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

Line 2097: FROM pay_sub_classification_rules_f subclass

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

Line 2120: FROM pay_sub_classification_rules_f subclass

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