APPS.PAY_US_YEAR_BEGIN_PROCESS dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 44: from pay_us_emp_state_tax_rules_f pst

40:
41: cursor csr_get_asg(p_start_day DATE,
42: p_business_group varchar2) is
43: select *
44: from pay_us_emp_state_tax_rules_f pst
45: where pst.sui_wage_base_override_amount is not null
46: and p_start_day between (pst.effective_start_date+1) and pst.effective_end_date
47: and pst.business_group_id = to_number(p_business_group) ;
48:

Line 49: l_state_rec PAY_US_EMP_STATE_TAX_RULES_F%rowtype;

45: where pst.sui_wage_base_override_amount is not null
46: and p_start_day between (pst.effective_start_date+1) and pst.effective_end_date
47: and pst.business_group_id = to_number(p_business_group) ;
48:
49: l_state_rec PAY_US_EMP_STATE_TAX_RULES_F%rowtype;
50: l_last_day DATE;
51: l_start_day DATE;
52: l_last_year VARCHAR2(4);
53: l_curr_year VARCHAR2(4);

Line 102: update PAY_US_EMP_STATE_TAX_RULES_F

98:
99: /* End date the state tax record as of /12/31/(input year-1) */
100:
101:
102: update PAY_US_EMP_STATE_TAX_RULES_F
103: set effective_end_date = l_last_day --to_date('12/31/'||end_year,'MM/DD/YYYY')
104: where emp_state_tax_rule_id = l_state_rec.emp_state_tax_rule_id
105: and assignment_id = l_state_rec.assignment_id
106: and effective_start_date = l_state_rec.effective_start_date

Line 123: insert into PAY_US_EMP_STATE_TAX_RULES_F

119: l_ind_eic := l_state_rec.sta_information1;
120: END IF; will write a new procedure for this too*/
121:
122:
123: insert into PAY_US_EMP_STATE_TAX_RULES_F
124: (emp_state_tax_rule_id,
125: effective_start_date,
126: effective_end_date,
127: assignment_id,

Line 194: from pay_us_emp_state_tax_rules_f pst

190:
191: cursor csr_get_asg(p_start_day DATE,
192: p_business_group varchar2) is
193: select *
194: from pay_us_emp_state_tax_rules_f pst
195: where pst.sta_information1 is not null
196: and p_start_day between (pst.effective_start_date+1) and pst.effective_end_date
197: and sta_information_category = 'IN'
198: and state_code = '15'

Line 201: l_state_rec PAY_US_EMP_STATE_TAX_RULES_F%rowtype;

197: and sta_information_category = 'IN'
198: and state_code = '15'
199: and pst.business_group_id = to_number(p_business_group);
200:
201: l_state_rec PAY_US_EMP_STATE_TAX_RULES_F%rowtype;
202: l_last_day DATE;
203: l_start_day DATE;
204: l_last_year VARCHAR2(4);
205: l_curr_year VARCHAR2(4);

Line 254: update PAY_US_EMP_STATE_TAX_RULES_F

250:
251: /* End date the state tax record as of /12/31/(input year-1) */
252:
253:
254: update PAY_US_EMP_STATE_TAX_RULES_F
255: set effective_end_date = l_last_day --to_date('12/31/'||end_year,'MM/DD/YYYY')
256: where emp_state_tax_rule_id = l_state_rec.emp_state_tax_rule_id
257: and assignment_id = l_state_rec.assignment_id
258: and effective_start_date = l_state_rec.effective_start_date

Line 269: insert into PAY_US_EMP_STATE_TAX_RULES_F

265: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
266:
267: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));
268:
269: insert into PAY_US_EMP_STATE_TAX_RULES_F
270: (
271: EMP_STATE_TAX_RULE_ID,
272: EFFECTIVE_START_DATE ,
273: EFFECTIVE_END_DATE ,