APPS.PAY_US_YEAR_BEGIN_PROCESS dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 739: from pay_us_emp_fed_tax_rules_f pft

735:
736: cursor csr_get_asg(p_start_day DATE,
737: p_business_group varchar2) is
738: select *
739: from pay_us_emp_fed_tax_rules_f pft
740: where pft.eic_filing_status_code <> 0
741: and p_start_day between (pft.effective_start_date+1) and pft.effective_end_date
742: and pft.business_group_id = to_number(p_business_group);
743:

Line 745: l_fed_rec PAY_US_EMP_FED_TAX_RULES_F%rowtype;

741: and p_start_day between (pft.effective_start_date+1) and pft.effective_end_date
742: and pft.business_group_id = to_number(p_business_group);
743:
744:
745: l_fed_rec PAY_US_EMP_FED_TAX_RULES_F%rowtype;
746: l_last_day DATE;
747: l_start_day DATE;
748: l_last_year VARCHAR2(4);
749: l_curr_year VARCHAR2(4);

Line 781: update PAY_US_EMP_FED_TAX_RULES_F

777:
778: /* End date the fed tax record as of /12/31/(input year-1) */
779:
780:
781: update PAY_US_EMP_FED_TAX_RULES_F
782: set effective_end_date = l_last_day --to_date('12/31/'||end_year,'MM/DD/YYYY')
783: where assignment_id = l_fed_rec.assignment_id
784: and effective_start_date = l_fed_rec.effective_start_date
785: and effective_end_date = l_fed_rec.effective_end_date

Line 798: insert into pay_us_emp_fed_tax_rules_f

794:
795:
796:
797: /* Insert Stmt for FED Tax Rules will come here */
798: insert into pay_us_emp_fed_tax_rules_f
799: (
800: EMP_FED_TAX_RULE_ID ,
801: EFFECTIVE_START_DATE ,
802: EFFECTIVE_END_DATE ,