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

Line 1175: from pay_us_emp_fed_tax_rules_f pft

1171:
1172: cursor csr_get_asg(p_start_day DATE,
1173: p_business_group varchar2) is
1174: select *
1175: from pay_us_emp_fed_tax_rules_f pft
1176: where pft.eic_filing_status_code <> 0
1177: and p_start_day between (pft.effective_start_date+1) and pft.effective_end_date
1178: and pft.business_group_id = to_number(p_business_group);
1179:

Line 1181: l_fed_rec PAY_US_EMP_FED_TAX_RULES_F%rowtype;

1177: and p_start_day between (pft.effective_start_date+1) and pft.effective_end_date
1178: and pft.business_group_id = to_number(p_business_group);
1179:
1180:
1181: l_fed_rec PAY_US_EMP_FED_TAX_RULES_F%rowtype;
1182: l_last_day DATE;
1183: l_start_day DATE;
1184: l_last_year VARCHAR2(4);
1185: l_curr_year VARCHAR2(4);

Line 1217: update PAY_US_EMP_FED_TAX_RULES_F

1213:
1214: /* End date the fed tax record as of /12/31/(input year-1) */
1215:
1216:
1217: update PAY_US_EMP_FED_TAX_RULES_F
1218: set effective_end_date = l_last_day --to_date('12/31/'||end_year,'MM/DD/YYYY')
1219: where assignment_id = l_fed_rec.assignment_id
1220: and effective_start_date = l_fed_rec.effective_start_date
1221: and effective_end_date = l_fed_rec.effective_end_date

Line 1234: insert into pay_us_emp_fed_tax_rules_f

1230:
1231:
1232:
1233: /* Insert Stmt for FED Tax Rules will come here */
1234: insert into pay_us_emp_fed_tax_rules_f
1235: (
1236: EMP_FED_TAX_RULE_ID ,
1237: EFFECTIVE_START_DATE ,
1238: EFFECTIVE_END_DATE ,