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.

[Home] [Help]

APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 1624: from PAY_US_EMP_COUNTY_TAX_RULES_F ctr

1620: from sys.DUAL;
1621:
1622: cursor csr_get_row_id is
1623: select rowidtochar(rowid)
1624: from PAY_US_EMP_COUNTY_TAX_RULES_F ctr
1625: where ctr.emp_county_tax_rule_id = p_emp_county_tax_rule_id
1626: and ctr.effective_start_date = p_effective_start_date
1627: and ctr.effective_end_date = p_effective_end_date;
1628:

Line 1632: from pay_us_emp_county_tax_rules_f sta

1628:
1629: /** added for bug 13872151**/
1630: cursor csr_county_tax_rule is
1631: select null
1632: from pay_us_emp_county_tax_rules_f sta
1633: where sta.assignment_id = p_assignment_id
1634: and sta.state_code = p_state_code
1635: and sta.county_code= p_county_code;
1636:

Line 1689: insert into pay_us_emp_county_tax_rules_f

1685: end if;
1686: close csr_county_tax_rule;
1687: --End of changes for bug 13872151
1688:
1689: insert into pay_us_emp_county_tax_rules_f
1690: (emp_county_tax_rule_id,
1691: effective_start_date,
1692: effective_end_date,
1693: assignment_id,

Line 2835: update PAY_US_EMP_COUNTY_TAX_RULES_F

2831:
2832: hr_utility.set_location('pay_us_emp_dt_tax_rules.update_county_tax_row'||
2833: ' - updating row', 2);
2834:
2835: update PAY_US_EMP_COUNTY_TAX_RULES_F
2836: set emp_county_tax_rule_id = p_emp_county_tax_rule_id,
2837: effective_start_date = p_effective_start_date,
2838: effective_end_date = p_effective_end_date,
2839: assignment_id = p_assignment_id,

Line 3194: from PAY_US_EMP_COUNTY_TAX_RULES_F puc

3190:
3191: /* Cursor to get the counties for the state */
3192: cursor csr_state_counties is
3193: select puc.jurisdiction_code
3194: from PAY_US_EMP_COUNTY_TAX_RULES_F puc
3195: where puc.assignment_id = p_assignment_id
3196: and puc.state_code = p_state_code;
3197:
3198: /* Cursor to get the cities for the state */

Line 3325: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */

3321: delete PAY_US_EMP_CITY_TAX_RULES_F
3322: where assignment_id = p_assignment_id
3323: and state_code = p_state_code;
3324:
3325: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */
3326:
3327: delete PAY_US_EMP_COUNTY_TAX_RULES_F
3328: where assignment_id = p_assignment_id
3329: and state_code = p_state_code;

Line 3327: delete PAY_US_EMP_COUNTY_TAX_RULES_F

3323: and state_code = p_state_code;
3324:
3325: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */
3326:
3327: delete PAY_US_EMP_COUNTY_TAX_RULES_F
3328: where assignment_id = p_assignment_id
3329: and state_code = p_state_code;
3330:
3331: /* Delete records from PAY_US_EMP_STATE_TAX_RULES_F */

Line 3386: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */

3382: where assignment_id = p_assignment_id
3383: and state_code = p_state_code
3384: and county_code = p_county_code;
3385:
3386: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */
3387:
3388: delete PAY_US_EMP_COUNTY_TAX_RULES_F
3389: where assignment_id = p_assignment_id
3390: and state_code = p_state_code

Line 3388: delete PAY_US_EMP_COUNTY_TAX_RULES_F

3384: and county_code = p_county_code;
3385:
3386: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */
3387:
3388: delete PAY_US_EMP_COUNTY_TAX_RULES_F
3389: where assignment_id = p_assignment_id
3390: and state_code = p_state_code
3391: and county_code = p_county_code;
3392:

Line 4495: from PAY_US_EMP_COUNTY_TAX_RULES_F

4491:
4492:
4493: cursor csr_county_rec is
4494: select *
4495: from PAY_US_EMP_COUNTY_TAX_RULES_F
4496: where rowid = chartorowid(p_row_id)
4497: for update of emp_county_tax_rule_id nowait;
4498:
4499: county_rec csr_county_rec%rowtype;

Line 5797: from pay_us_emp_county_tax_rules_f pst

5793: cursor chk_county_exists is
5794: select 'Y'
5795: from dual
5796: where exists (select null
5797: from pay_us_emp_county_tax_rules_f pst
5798: where pst.assignment_id = p_assignment_id
5799: and state_code = p_state_code
5800: and county_code = p_county_code
5801: and business_group_id + 0 = p_business_group_id);

Line 7308: from PAY_US_EMP_COUNTY_TAX_RULES_F ctr

7304:
7305: cursor csr_get_counties is
7306: select state_code,
7307: county_code
7308: from PAY_US_EMP_COUNTY_TAX_RULES_F ctr
7309: where ctr.assignment_id = p_assignment_id
7310: and p_session_date between ctr.effective_start_date
7311: and ctr.effective_end_date;
7312:

Line 7616: from PAY_US_EMP_COUNTY_TAX_RULES_F ctr

7612:
7613: cursor csr_get_counties is
7614: select state_code,
7615: county_code
7616: from PAY_US_EMP_COUNTY_TAX_RULES_F ctr
7617: where ctr.assignment_id = p_assignment_id
7618: and p_session_date between
7619: ctr.effective_start_date and ctr.effective_end_date;
7620:

Line 10581: update PAY_US_EMP_COUNTY_TAX_RULES_F

10577: fnd_message.set_token('STEP','3');
10578: fnd_message.raise_error;
10579: end if;
10580:
10581: update PAY_US_EMP_COUNTY_TAX_RULES_F
10582: set effective_start_date = p_new_start_date
10583: where assignment_id = p_assignment_id
10584: and l_ef_date between effective_start_date and effective_end_date;
10585:

Line 10616: delete PAY_US_EMP_COUNTY_TAX_RULES_F

10612: delete PAY_US_EMP_STATE_TAX_RULES_F
10613: where assignment_id = p_assignment_id
10614: and p_new_start_date > effective_start_date;
10615:
10616: delete PAY_US_EMP_COUNTY_TAX_RULES_F
10617: where assignment_id = p_assignment_id
10618: and p_new_start_date > effective_start_date;
10619:
10620: delete PAY_US_EMP_CITY_TAX_RULES_F

Line 12067: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */

12063: delete PAY_US_EMP_CITY_TAX_RULES_F
12064: where assignment_id = p_assignment_id
12065: and business_group_id = p_business_group_id;
12066:
12067: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */
12068:
12069: delete PAY_US_EMP_COUNTY_TAX_RULES_F
12070: where assignment_id = p_assignment_id
12071: and business_group_id = p_business_group_id;

Line 12069: delete PAY_US_EMP_COUNTY_TAX_RULES_F

12065: and business_group_id = p_business_group_id;
12066:
12067: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */
12068:
12069: delete PAY_US_EMP_COUNTY_TAX_RULES_F
12070: where assignment_id = p_assignment_id
12071: and business_group_id = p_business_group_id;
12072:
12073: /* Delete records from PAY_US_EMP_STATE_TAX_RULES_F */