APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 1600: from PAY_US_EMP_COUNTY_TAX_RULES_F ctr

1596: from sys.DUAL;
1597:
1598: cursor csr_get_row_id is
1599: select rowidtochar(rowid)
1600: from PAY_US_EMP_COUNTY_TAX_RULES_F ctr
1601: where ctr.emp_county_tax_rule_id = p_emp_county_tax_rule_id
1602: and ctr.effective_start_date = p_effective_start_date
1603: and ctr.effective_end_date = p_effective_end_date;
1604:

Line 1641: insert into pay_us_emp_county_tax_rules_f

1637: hr_utility.set_location('pay_us_emp_dt_tax_rules.insert_county_tax_row'||
1638: ' - inserting row', 4);
1639:
1640:
1641: insert into pay_us_emp_county_tax_rules_f
1642: (emp_county_tax_rule_id,
1643: effective_start_date,
1644: effective_end_date,
1645: assignment_id,

Line 2760: update PAY_US_EMP_COUNTY_TAX_RULES_F

2756:
2757: hr_utility.set_location('pay_us_emp_dt_tax_rules.update_county_tax_row'||
2758: ' - updating row', 2);
2759:
2760: update PAY_US_EMP_COUNTY_TAX_RULES_F
2761: set emp_county_tax_rule_id = p_emp_county_tax_rule_id,
2762: effective_start_date = p_effective_start_date,
2763: effective_end_date = p_effective_end_date,
2764: assignment_id = p_assignment_id,

Line 3118: from PAY_US_EMP_COUNTY_TAX_RULES_F puc

3114:
3115: /* Cursor to get the counties for the state */
3116: cursor csr_state_counties is
3117: select puc.jurisdiction_code
3118: from PAY_US_EMP_COUNTY_TAX_RULES_F puc
3119: where puc.assignment_id = p_assignment_id
3120: and puc.state_code = p_state_code;
3121:
3122: /* Cursor to get the cities for the state */

Line 3249: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */

3245: delete PAY_US_EMP_CITY_TAX_RULES_F
3246: where assignment_id = p_assignment_id
3247: and state_code = p_state_code;
3248:
3249: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */
3250:
3251: delete PAY_US_EMP_COUNTY_TAX_RULES_F
3252: where assignment_id = p_assignment_id
3253: and state_code = p_state_code;

Line 3251: delete PAY_US_EMP_COUNTY_TAX_RULES_F

3247: and state_code = p_state_code;
3248:
3249: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */
3250:
3251: delete PAY_US_EMP_COUNTY_TAX_RULES_F
3252: where assignment_id = p_assignment_id
3253: and state_code = p_state_code;
3254:
3255: /* Delete records from PAY_US_EMP_STATE_TAX_RULES_F */

Line 3310: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */

3306: where assignment_id = p_assignment_id
3307: and state_code = p_state_code
3308: and county_code = p_county_code;
3309:
3310: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */
3311:
3312: delete PAY_US_EMP_COUNTY_TAX_RULES_F
3313: where assignment_id = p_assignment_id
3314: and state_code = p_state_code

Line 3312: delete PAY_US_EMP_COUNTY_TAX_RULES_F

3308: and county_code = p_county_code;
3309:
3310: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */
3311:
3312: delete PAY_US_EMP_COUNTY_TAX_RULES_F
3313: where assignment_id = p_assignment_id
3314: and state_code = p_state_code
3315: and county_code = p_county_code;
3316:

Line 4419: from PAY_US_EMP_COUNTY_TAX_RULES_F

4415:
4416:
4417: cursor csr_county_rec is
4418: select *
4419: from PAY_US_EMP_COUNTY_TAX_RULES_F
4420: where rowid = chartorowid(p_row_id)
4421: for update of emp_county_tax_rule_id nowait;
4422:
4423: county_rec csr_county_rec%rowtype;

Line 5721: from pay_us_emp_county_tax_rules_f pst

5717: cursor chk_county_exists is
5718: select 'Y'
5719: from dual
5720: where exists (select null
5721: from pay_us_emp_county_tax_rules_f pst
5722: where pst.assignment_id = p_assignment_id
5723: and state_code = p_state_code
5724: and county_code = p_county_code
5725: and business_group_id + 0 = p_business_group_id);

Line 7232: from PAY_US_EMP_COUNTY_TAX_RULES_F ctr

7228:
7229: cursor csr_get_counties is
7230: select state_code,
7231: county_code
7232: from PAY_US_EMP_COUNTY_TAX_RULES_F ctr
7233: where ctr.assignment_id = p_assignment_id
7234: and p_session_date between ctr.effective_start_date
7235: and ctr.effective_end_date;
7236:

Line 7540: from PAY_US_EMP_COUNTY_TAX_RULES_F ctr

7536:
7537: cursor csr_get_counties is
7538: select state_code,
7539: county_code
7540: from PAY_US_EMP_COUNTY_TAX_RULES_F ctr
7541: where ctr.assignment_id = p_assignment_id
7542: and p_session_date between
7543: ctr.effective_start_date and ctr.effective_end_date;
7544:

Line 10505: update PAY_US_EMP_COUNTY_TAX_RULES_F

10501: fnd_message.set_token('STEP','3');
10502: fnd_message.raise_error;
10503: end if;
10504:
10505: update PAY_US_EMP_COUNTY_TAX_RULES_F
10506: set effective_start_date = p_new_start_date
10507: where assignment_id = p_assignment_id
10508: and l_ef_date between effective_start_date and effective_end_date;
10509:

Line 10540: delete PAY_US_EMP_COUNTY_TAX_RULES_F

10536: delete PAY_US_EMP_STATE_TAX_RULES_F
10537: where assignment_id = p_assignment_id
10538: and p_new_start_date > effective_start_date;
10539:
10540: delete PAY_US_EMP_COUNTY_TAX_RULES_F
10541: where assignment_id = p_assignment_id
10542: and p_new_start_date > effective_start_date;
10543:
10544: delete PAY_US_EMP_CITY_TAX_RULES_F

Line 11991: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */

11987: delete PAY_US_EMP_CITY_TAX_RULES_F
11988: where assignment_id = p_assignment_id
11989: and business_group_id = p_business_group_id;
11990:
11991: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */
11992:
11993: delete PAY_US_EMP_COUNTY_TAX_RULES_F
11994: where assignment_id = p_assignment_id
11995: and business_group_id = p_business_group_id;

Line 11993: delete PAY_US_EMP_COUNTY_TAX_RULES_F

11989: and business_group_id = p_business_group_id;
11990:
11991: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */
11992:
11993: delete PAY_US_EMP_COUNTY_TAX_RULES_F
11994: where assignment_id = p_assignment_id
11995: and business_group_id = p_business_group_id;
11996:
11997: /* Delete records from PAY_US_EMP_STATE_TAX_RULES_F */