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_US_EXTRA_PER_INFO_LEG_HOOK dependencies on DUAL

Line 68: and fetr.effective_start_date <=(select sysdate from dual)

64: IS
65: SELECT WITHHOLDING_ALLOWANCES
66: FROM pay_us_emp_fed_tax_rules_f fetr
67: WHERE fetr.assignment_id=p_assignment_id
68: and fetr.effective_start_date <=(select sysdate from dual)
69: and fetr.effective_end_date >=(select sysdate from dual);
70:
71: CURSOR get_fsc_fed(p_assignment_id NUMBER)
72: IS

Line 69: and fetr.effective_end_date >=(select sysdate from dual);

65: SELECT WITHHOLDING_ALLOWANCES
66: FROM pay_us_emp_fed_tax_rules_f fetr
67: WHERE fetr.assignment_id=p_assignment_id
68: and fetr.effective_start_date <=(select sysdate from dual)
69: and fetr.effective_end_date >=(select sysdate from dual);
70:
71: CURSOR get_fsc_fed(p_assignment_id NUMBER)
72: IS
73: SELECT FILING_STATUS_CODE

Line 76: and fetr.effective_start_date <=(select sysdate from dual)

72: IS
73: SELECT FILING_STATUS_CODE
74: FROM pay_us_emp_fed_tax_rules_f fetr
75: WHERE fetr.assignment_id=p_assignment_id
76: and fetr.effective_start_date <=(select sysdate from dual)
77: and fetr.effective_end_date >=(select sysdate from dual);
78:
79: CURSOR get_fitexempt_fed(p_assignment_id NUMBER)
80: IS

Line 77: and fetr.effective_end_date >=(select sysdate from dual);

73: SELECT FILING_STATUS_CODE
74: FROM pay_us_emp_fed_tax_rules_f fetr
75: WHERE fetr.assignment_id=p_assignment_id
76: and fetr.effective_start_date <=(select sysdate from dual)
77: and fetr.effective_end_date >=(select sysdate from dual);
78:
79: CURSOR get_fitexempt_fed(p_assignment_id NUMBER)
80: IS
81: SELECT FIT_EXEMPT

Line 84: and fetr.effective_start_date <=(select sysdate from dual)

80: IS
81: SELECT FIT_EXEMPT
82: FROM pay_us_emp_fed_tax_rules_f fetr
83: WHERE fetr.assignment_id=p_assignment_id
84: and fetr.effective_start_date <=(select sysdate from dual)
85: and fetr.effective_end_date >=(select sysdate from dual);
86:
87: begin
88: hr_utility.trace('Entering PAY_US_EXTRA_PER_INFO_LEG_HOOK.person_check_nra_status_create');

Line 85: and fetr.effective_end_date >=(select sysdate from dual);

81: SELECT FIT_EXEMPT
82: FROM pay_us_emp_fed_tax_rules_f fetr
83: WHERE fetr.assignment_id=p_assignment_id
84: and fetr.effective_start_date <=(select sysdate from dual)
85: and fetr.effective_end_date >=(select sysdate from dual);
86:
87: begin
88: hr_utility.trace('Entering PAY_US_EXTRA_PER_INFO_LEG_HOOK.person_check_nra_status_create');
89:

Line 213: and fetr.effective_start_date <=(select sysdate from dual)

209: IS
210: SELECT WITHHOLDING_ALLOWANCES
211: FROM pay_us_emp_fed_tax_rules_f fetr
212: WHERE fetr.assignment_id=p_assignment_id
213: and fetr.effective_start_date <=(select sysdate from dual)
214: and fetr.effective_end_date >=(select sysdate from dual);
215:
216: CURSOR get_fsc_fed(p_assignment_id NUMBER)
217: IS

Line 214: and fetr.effective_end_date >=(select sysdate from dual);

210: SELECT WITHHOLDING_ALLOWANCES
211: FROM pay_us_emp_fed_tax_rules_f fetr
212: WHERE fetr.assignment_id=p_assignment_id
213: and fetr.effective_start_date <=(select sysdate from dual)
214: and fetr.effective_end_date >=(select sysdate from dual);
215:
216: CURSOR get_fsc_fed(p_assignment_id NUMBER)
217: IS
218: SELECT FILING_STATUS_CODE

Line 221: and fetr.effective_start_date <=(select sysdate from dual)

217: IS
218: SELECT FILING_STATUS_CODE
219: FROM pay_us_emp_fed_tax_rules_f fetr
220: WHERE fetr.assignment_id=p_assignment_id
221: and fetr.effective_start_date <=(select sysdate from dual)
222: and fetr.effective_end_date >=(select sysdate from dual);
223:
224: CURSOR get_fitexempt_fed(p_assignment_id NUMBER)
225: IS

Line 222: and fetr.effective_end_date >=(select sysdate from dual);

218: SELECT FILING_STATUS_CODE
219: FROM pay_us_emp_fed_tax_rules_f fetr
220: WHERE fetr.assignment_id=p_assignment_id
221: and fetr.effective_start_date <=(select sysdate from dual)
222: and fetr.effective_end_date >=(select sysdate from dual);
223:
224: CURSOR get_fitexempt_fed(p_assignment_id NUMBER)
225: IS
226: SELECT FIT_EXEMPT

Line 229: and fetr.effective_start_date <=(select sysdate from dual)

225: IS
226: SELECT FIT_EXEMPT
227: FROM pay_us_emp_fed_tax_rules_f fetr
228: WHERE fetr.assignment_id=p_assignment_id
229: and fetr.effective_start_date <=(select sysdate from dual)
230: and fetr.effective_end_date >=(select sysdate from dual);
231:
232:
233:

Line 230: and fetr.effective_end_date >=(select sysdate from dual);

226: SELECT FIT_EXEMPT
227: FROM pay_us_emp_fed_tax_rules_f fetr
228: WHERE fetr.assignment_id=p_assignment_id
229: and fetr.effective_start_date <=(select sysdate from dual)
230: and fetr.effective_end_date >=(select sysdate from dual);
231:
232:
233:
234: begin