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 PAY_US_EMP_FED_TAX_RULES_F

Line 38: l_withholding_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

34: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;
35: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
36: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
37: l_person_id per_people_f.person_id%TYPE;
38: l_withholding_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
39: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
40: l_wa_fed pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
41: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
42: l_student_flag varchar2(3);

Line 39: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

35: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
36: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
37: l_person_id per_people_f.person_id%TYPE;
38: l_withholding_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
39: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
40: l_wa_fed pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
41: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
42: l_student_flag varchar2(3);
43: l_student per_people_extra_info.pei_information1%TYPE;

Line 40: l_wa_fed pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

36: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
37: l_person_id per_people_f.person_id%TYPE;
38: l_withholding_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
39: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
40: l_wa_fed pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
41: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
42: l_student_flag varchar2(3);
43: l_student per_people_extra_info.pei_information1%TYPE;
44: l_business_apprentice per_people_extra_info.pei_information2%TYPE;

Line 66: FROM pay_us_emp_fed_tax_rules_f fetr

62:
63: CURSOR get_wa_fed(p_assignment_id NUMBER)
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:

Line 74: FROM pay_us_emp_fed_tax_rules_f fetr

70:
71: CURSOR get_fsc_fed(p_assignment_id NUMBER)
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:

Line 82: FROM pay_us_emp_fed_tax_rules_f fetr

78:
79: CURSOR get_fitexempt_fed(p_assignment_id NUMBER)
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:

Line 169: l_withholding_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

165: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
166: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
167: l_pei_information9_1 per_people_extra_info.pei_information9%TYPE;
168: l_person_extra_info_id per_people_extra_info.person_extra_info_id%TYPE;
169: l_withholding_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
170: l_wa_fed pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
171: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
172: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
173: l_student_flag varchar2(3);

Line 170: l_wa_fed pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

166: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
167: l_pei_information9_1 per_people_extra_info.pei_information9%TYPE;
168: l_person_extra_info_id per_people_extra_info.person_extra_info_id%TYPE;
169: l_withholding_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
170: l_wa_fed pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
171: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
172: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
173: l_student_flag varchar2(3);
174: l_student per_people_extra_info.pei_information1%TYPE;

Line 171: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

167: l_pei_information9_1 per_people_extra_info.pei_information9%TYPE;
168: l_person_extra_info_id per_people_extra_info.person_extra_info_id%TYPE;
169: l_withholding_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
170: l_wa_fed pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
171: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
172: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
173: l_student_flag varchar2(3);
174: l_student per_people_extra_info.pei_information1%TYPE;
175: l_business_apprentice per_people_extra_info.pei_information2%TYPE;

Line 211: FROM pay_us_emp_fed_tax_rules_f fetr

207:
208: CURSOR get_wa_fed(p_assignment_id NUMBER)
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:

Line 219: FROM pay_us_emp_fed_tax_rules_f fetr

215:
216: CURSOR get_fsc_fed(p_assignment_id NUMBER)
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:

Line 227: FROM pay_us_emp_fed_tax_rules_f fetr

223:
224: CURSOR get_fitexempt_fed(p_assignment_id NUMBER)
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: