APPS.PAY_US_YEAR_BEGIN_PROCESS dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 474: from pay_us_emp_city_tax_rules_f pct,

470:
471: cursor csr_get_asg(p_start_day DATE,
472: p_business_group varchar2) is
473: select pct.*
474: from pay_us_emp_city_tax_rules_f pct,
475: pay_state_rules psr,
476: pay_us_states pus
477: where psr.head_tax_period = 'A'
478: and psr.state_code = pus.state_abbrev

Line 485: l_city_rec PAY_US_EMP_CITY_TAX_RULES_F%rowtype;

481: and p_start_day between (pct.effective_start_date+1) and pct.effective_end_date
482: and pct.business_group_id = to_number(p_business_group) ;
483:
484:
485: l_city_rec PAY_US_EMP_CITY_TAX_RULES_F%rowtype;
486: l_last_day DATE;
487: l_start_day DATE;
488: l_last_year VARCHAR2(4);
489: l_curr_year VARCHAR2(4);

Line 521: update PAY_US_EMP_CITY_TAX_RULES_F

517:
518: /* End date the city tax record as of /12/31/(input year-1) */
519:
520:
521: update PAY_US_EMP_CITY_TAX_RULES_F
522: set effective_end_date = l_last_day --to_date('12/31/'||end_year,'MM/DD/YYYY')
523: where emp_city_tax_rule_id = l_city_rec.emp_city_tax_rule_id
524: and assignment_id = l_city_rec.assignment_id
525: and effective_start_date = l_city_rec.effective_start_date

Line 538: insert into PAY_US_EMP_CITY_TAX_RULES_F

534: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_city_rec.effective_end_date));
535:
536:
537:
538: insert into PAY_US_EMP_CITY_TAX_RULES_F
539: (
540: EMP_CITY_TAX_RULE_ID,
541: EFFECTIVE_START_DATE,
542: EFFECTIVE_END_DATE ,