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_STATE_TAX_RULES_F

Line 65: from pay_us_emp_state_tax_rules_f pst

61:
62: cursor csr_get_asg(p_start_day DATE,
63: p_business_group varchar2) is
64: select *
65: from pay_us_emp_state_tax_rules_f pst
66: where pst.sui_wage_base_override_amount is not null
67: and p_start_day between (pst.effective_start_date+1) and pst.effective_end_date
68: and pst.business_group_id = to_number(p_business_group) ;
69:

Line 70: l_state_rec PAY_US_EMP_STATE_TAX_RULES_F%rowtype;

66: where pst.sui_wage_base_override_amount is not null
67: and p_start_day between (pst.effective_start_date+1) and pst.effective_end_date
68: and pst.business_group_id = to_number(p_business_group) ;
69:
70: l_state_rec PAY_US_EMP_STATE_TAX_RULES_F%rowtype;
71: l_last_day DATE;
72: l_start_day DATE;
73: l_last_year VARCHAR2(4);
74: l_curr_year VARCHAR2(4);

Line 123: update PAY_US_EMP_STATE_TAX_RULES_F

119:
120: /* End date the state tax record as of /12/31/(input year-1) */
121:
122:
123: update PAY_US_EMP_STATE_TAX_RULES_F
124: set effective_end_date = l_last_day --to_date('12/31/'||end_year,'MM/DD/YYYY')
125: where emp_state_tax_rule_id = l_state_rec.emp_state_tax_rule_id
126: and assignment_id = l_state_rec.assignment_id
127: and effective_start_date = l_state_rec.effective_start_date

Line 144: insert into PAY_US_EMP_STATE_TAX_RULES_F

140: l_ind_eic := l_state_rec.sta_information1;
141: END IF; will write a new procedure for this too*/
142:
143: /* Added Attribute and Information columns in insert statement for bug#11056284 */
144: insert into PAY_US_EMP_STATE_TAX_RULES_F
145: (emp_state_tax_rule_id,
146: effective_start_date,
147: effective_end_date,
148: assignment_id,

Line 349: from pay_us_emp_state_tax_rules_f pst

345:
346: cursor csr_get_asg(p_start_day DATE,
347: p_business_group varchar2) is
348: select *
349: from pay_us_emp_state_tax_rules_f pst
350: where pst.sta_information1 is not null
351: and p_start_day between (pst.effective_start_date+1) and pst.effective_end_date
352: and sta_information_category = 'IN'
353: and state_code = '15'

Line 356: l_state_rec PAY_US_EMP_STATE_TAX_RULES_F%rowtype;

352: and sta_information_category = 'IN'
353: and state_code = '15'
354: and pst.business_group_id = to_number(p_business_group);
355:
356: l_state_rec PAY_US_EMP_STATE_TAX_RULES_F%rowtype;
357: l_last_day DATE;
358: l_start_day DATE;
359: l_last_year VARCHAR2(4);
360: l_curr_year VARCHAR2(4);

Line 409: update PAY_US_EMP_STATE_TAX_RULES_F

405:
406: /* End date the state tax record as of /12/31/(input year-1) */
407:
408:
409: update PAY_US_EMP_STATE_TAX_RULES_F
410: set effective_end_date = l_last_day --to_date('12/31/'||end_year,'MM/DD/YYYY')
411: where emp_state_tax_rule_id = l_state_rec.emp_state_tax_rule_id
412: and assignment_id = l_state_rec.assignment_id
413: and effective_start_date = l_state_rec.effective_start_date

Line 424: insert into PAY_US_EMP_STATE_TAX_RULES_F

420: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
421:
422: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));
423:
424: insert into PAY_US_EMP_STATE_TAX_RULES_F
425: (
426: EMP_STATE_TAX_RULE_ID,
427: EFFECTIVE_START_DATE ,
428: EFFECTIVE_END_DATE ,

Line 629: from pay_us_emp_state_tax_rules_f pst

625:
626: cursor csr_get_asg(p_start_day DATE,
627: p_business_group varchar2) is
628: select *
629: from pay_us_emp_state_tax_rules_f pst
630: where (pst.sta_information1 is not null
631: or pst.sta_information6 is not null)
632: and p_start_day between (pst.effective_start_date+1) and pst.effective_end_date
633: and sta_information_category = 'WI'

Line 637: l_state_rec PAY_US_EMP_STATE_TAX_RULES_F%rowtype;

633: and sta_information_category = 'WI'
634: and state_code = '50'
635: and pst.business_group_id = to_number(p_business_group);
636:
637: l_state_rec PAY_US_EMP_STATE_TAX_RULES_F%rowtype;
638: l_last_day DATE;
639: l_start_day DATE;
640: l_last_year VARCHAR2(4);
641: l_curr_year VARCHAR2(4);

Line 690: update PAY_US_EMP_STATE_TAX_RULES_F

686:
687: /* End date the state tax record as of /12/31/(input year-1) */
688:
689:
690: update PAY_US_EMP_STATE_TAX_RULES_F
691: set effective_end_date = l_last_day --to_date('12/31/'||end_year,'MM/DD/YYYY')
692: where emp_state_tax_rule_id = l_state_rec.emp_state_tax_rule_id
693: and assignment_id = l_state_rec.assignment_id
694: and effective_start_date = l_state_rec.effective_start_date

Line 705: insert into PAY_US_EMP_STATE_TAX_RULES_F

701: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
702:
703: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));
704:
705: insert into PAY_US_EMP_STATE_TAX_RULES_F
706: (
707: EMP_STATE_TAX_RULE_ID,
708: EFFECTIVE_START_DATE ,
709: EFFECTIVE_END_DATE ,