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_GET_TAX_EXISTS_PKG dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 60: FROM pay_us_emp_fed_tax_rules_f pest

56: AND pest.state_code = SUBSTR(p_jurisdiction_code, 1, 2);
57:
58: CURSOR futa_exempt IS
59: SELECT DECODE(pest.futa_tax_exempt, NULL, 'N', pest.futa_tax_exempt)
60: FROM pay_us_emp_fed_tax_rules_f pest
61: WHERE pest.assignment_id = p_assign_id
62: AND TO_DATE(l_change_date, 'DD-MM-YYYY') BETWEEN
63: pest.effective_start_date AND pest.effective_end_date;
64:

Line 67: FROM pay_us_emp_fed_tax_rules_f pest

63: pest.effective_start_date AND pest.effective_end_date;
64:
65: CURSOR fica_exempt IS
66: SELECT DECODE(pest.ss_tax_exempt, NULL, 'N', pest.ss_tax_exempt)
67: FROM pay_us_emp_fed_tax_rules_f pest
68: WHERE pest.assignment_id = p_assign_id
69: AND TO_DATE(l_change_date, 'DD-MM-YYYY') BETWEEN
70: pest.effective_start_date AND pest.effective_end_date;
71:

Line 74: FROM pay_us_emp_fed_tax_rules_f pest

70: pest.effective_start_date AND pest.effective_end_date;
71:
72: CURSOR medi_exempt IS
73: SELECT DECODE(pest.medicare_tax_exempt, NULL, 'N', pest.medicare_tax_exempt)
74: FROM pay_us_emp_fed_tax_rules_f pest
75: WHERE pest.assignment_id = p_assign_id
76: AND TO_DATE(l_change_date, 'DD-MM-YYYY') BETWEEN
77: pest.effective_start_date AND pest.effective_end_date;
78: