APPS.PAY_US_YEAR_BEGIN_PROCESS dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 910: from pay_us_emp_city_tax_rules_f pct,

906:
907: cursor csr_get_asg(p_start_day DATE,
908: p_business_group varchar2) is
909: select pct.*
910: from pay_us_emp_city_tax_rules_f pct,
911: pay_state_rules psr,
912: pay_us_states pus
913: where psr.head_tax_period = 'A'
914: and psr.state_code = pus.state_abbrev

Line 921: l_city_rec PAY_US_EMP_CITY_TAX_RULES_F%rowtype;

917: and p_start_day between (pct.effective_start_date+1) and pct.effective_end_date
918: and pct.business_group_id = to_number(p_business_group) ;
919:
920:
921: l_city_rec PAY_US_EMP_CITY_TAX_RULES_F%rowtype;
922: l_last_day DATE;
923: l_start_day DATE;
924: l_last_year VARCHAR2(4);
925: l_curr_year VARCHAR2(4);

Line 957: update PAY_US_EMP_CITY_TAX_RULES_F

953:
954: /* End date the city tax record as of /12/31/(input year-1) */
955:
956:
957: update PAY_US_EMP_CITY_TAX_RULES_F
958: set effective_end_date = l_last_day --to_date('12/31/'||end_year,'MM/DD/YYYY')
959: where emp_city_tax_rule_id = l_city_rec.emp_city_tax_rule_id
960: and assignment_id = l_city_rec.assignment_id
961: and effective_start_date = l_city_rec.effective_start_date

Line 974: insert into PAY_US_EMP_CITY_TAX_RULES_F

970: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_city_rec.effective_end_date));
971:
972:
973:
974: insert into PAY_US_EMP_CITY_TAX_RULES_F
975: (
976: EMP_CITY_TAX_RULE_ID,
977: EFFECTIVE_START_DATE,
978: EFFECTIVE_END_DATE ,