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_EMP_DT_TAX_RULES dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 594: from PAY_US_EMP_FED_TAX_RULES_F

590: of the element entry */
591:
592: cursor csr_get_eff_date is
593: select min(effective_start_date)
594: from PAY_US_EMP_FED_TAX_RULES_F
595: where assignment_id = p_assignment_id;
596:
597: /* Since a change in location may have taken place before the default tax
598: rules criteria is met, we will consider only those locations whose

Line 926: update PAY_US_EMP_FED_TAX_RULES_F

922: /* Update the Federal tax record as of the p_effective_start_date */
923:
924: l_step := 2;
925:
926: update PAY_US_EMP_FED_TAX_RULES_F
927: set effective_end_date = l_new_date
928: where assignment_id = p_assignment_id
929: and effective_end_date = p_effective_end_date;
930:

Line 935: insert into PAY_US_EMP_FED_TAX_RULES_F

931: end if;
932:
933: l_step := 3;
934:
935: insert into PAY_US_EMP_FED_TAX_RULES_F
936: (emp_fed_tax_rule_id,
937: effective_start_date,
938: effective_end_date,
939: assignment_id,

Line 2417: update PAY_US_EMP_FED_TAX_RULES_F

2413: , p_effective_start_date
2414: , p_effective_end_date
2415: , lv_warning);
2416:
2417: update PAY_US_EMP_FED_TAX_RULES_F
2418: set emp_fed_tax_rule_id = p_emp_fed_tax_rule_id,
2419: effective_start_date = p_effective_start_date,
2420: effective_end_date = p_effective_end_date,
2421: assignment_id = p_assignment_id ,

Line 3219: from PAY_US_EMP_FED_TAX_RULES_F

3215: default tax rules criteria was satisfied. */
3216:
3217: cursor csr_get_eff_date is
3218: select min(effective_start_date)
3219: from PAY_US_EMP_FED_TAX_RULES_F
3220: where assignment_id = p_assignment_id;
3221:
3222: begin
3223:

Line 3526: from PAY_US_EMP_FED_TAX_RULES_F

3522: for update of assignment_id nowait;
3523:
3524: cursor csr_fed_rec is
3525: select *
3526: from PAY_US_EMP_FED_TAX_RULES_F
3527: where rowid = chartorowid(p_row_id)
3528: for update of emp_fed_tax_rule_id nowait;
3529:
3530: fed_rec csr_fed_rec%rowtype;

Line 6666: from PAY_US_EMP_FED_TAX_RULES_F

6662: /* End changes by lwthomps (588982)*/
6663:
6664: cursor csr_get_eff_date is
6665: select min(effective_start_date)
6666: from PAY_US_EMP_FED_TAX_RULES_F
6667: where assignment_id = p_assignment_id;
6668:
6669: /* Added cursor csr_get_max_assign_end_dt
6670: for bug 2535501 to get the max(effective_end_date)

Line 8005: from PAY_US_EMP_FED_TAX_RULES_F ftr

8001: satisfied */
8002:
8003: cursor csr_get_eff_date (passignment number) is
8004: select min(ftr.effective_start_date)
8005: from PAY_US_EMP_FED_TAX_RULES_F ftr
8006: where ftr.assignment_id = passignment;
8007:
8008: /* Cursor to get the changes in assignment which in turn will help us
8009: in identifying the change in locations that has taken place within

Line 9460: from PAY_US_EMP_FED_TAX_RULES_F pef

9456:
9457: cursor csr_get_fed_rows is
9458: select pef.effective_start_date, pef.effective_end_date,
9459: pef.sui_jurisdiction_code
9460: from PAY_US_EMP_FED_TAX_RULES_F pef
9461: where pef.assignment_id = p_assignment_id
9462: and p_effective_start_date <= pef.effective_end_date
9463: and p_effective_end_date >= pef.effective_start_date;
9464:

Line 9466: select * from pay_us_emp_fed_tax_rules_f

9462: and p_effective_start_date <= pef.effective_end_date
9463: and p_effective_end_date >= pef.effective_start_date;
9464:
9465: cursor csr_get_fed_details (p_start_date date, p_end_date date) is
9466: select * from pay_us_emp_fed_tax_rules_f
9467: where assignment_id = p_assignment_id
9468: and effective_start_date = p_start_date
9469: and effective_end_date = p_end_date;
9470:

Line 9473: from PAY_US_EMP_FED_TAX_RULES_F

9469: and effective_end_date = p_end_date;
9470:
9471: cursor csr_lck_fed_row (p_start_date date, p_end_date date)is
9472: select rowid
9473: from PAY_US_EMP_FED_TAX_RULES_F
9474: where assignment_id = p_assignment_id
9475: and effective_start_date = p_start_date
9476: and effective_end_date = p_end_date
9477: for update nowait;

Line 9486: l_fed_rec PAY_US_EMP_FED_TAX_RULES_F%rowtype;

9482: l_work_state_code varchar2(2);
9483: l_new_date date;
9484: l_jurisdiction_code varchar2(11);
9485: l_step number;
9486: l_fed_rec PAY_US_EMP_FED_TAX_RULES_F%rowtype;
9487:
9488: begin
9489:
9490: l_step := 1;

Line 9528: update PAY_US_EMP_FED_TAX_RULES_F

9524: close csr_lck_fed_row;
9525:
9526: /* Update the federal tax record for the SUI state */
9527: l_step := 6;
9528: update PAY_US_EMP_FED_TAX_RULES_F
9529: set sui_state_code = l_work_state_code,
9530: sui_jurisdiction_code = l_work_state_code ||'-000-0000'
9531: where rowid = l_row_id;
9532:

Line 9568: update PAY_US_EMP_FED_TAX_RULES_F

9564:
9565: /* Update the Federal tax record as of the p_effective_start_date */
9566:
9567: l_step := 10;
9568: update PAY_US_EMP_FED_TAX_RULES_F
9569: set effective_end_date = l_new_date
9570: where assignment_id = p_assignment_id
9571: and effective_start_date = l_eff_start_date
9572: and effective_end_date = l_eff_end_date;

Line 9575: insert into PAY_US_EMP_FED_TAX_RULES_F

9571: and effective_start_date = l_eff_start_date
9572: and effective_end_date = l_eff_end_date;
9573:
9574: l_step := 11;
9575: insert into PAY_US_EMP_FED_TAX_RULES_F
9576: (emp_fed_tax_rule_id,
9577: effective_start_date,
9578: effective_end_date,
9579: assignment_id,

Line 9800: insert into PAY_US_EMP_FED_TAX_RULES_F

9796:
9797: /* Update the Federal tax record as of the p_effective_start_date */
9798: l_step := 15;
9799: /*
9800: insert into PAY_US_EMP_FED_TAX_RULES_F
9801: select * from pay_us_emp_fed_tax_rules_f
9802: where assignment_id = p_assignment_id
9803: and effective_start_date = l_eff_start_date
9804: and effective_end_date = l_eff_end_date;

Line 9801: select * from pay_us_emp_fed_tax_rules_f

9797: /* Update the Federal tax record as of the p_effective_start_date */
9798: l_step := 15;
9799: /*
9800: insert into PAY_US_EMP_FED_TAX_RULES_F
9801: select * from pay_us_emp_fed_tax_rules_f
9802: where assignment_id = p_assignment_id
9803: and effective_start_date = l_eff_start_date
9804: and effective_end_date = l_eff_end_date;
9805: */

Line 9808: update PAY_US_EMP_FED_TAX_RULES_F

9804: and effective_end_date = l_eff_end_date;
9805: */
9806:
9807: l_step := 16;
9808: update PAY_US_EMP_FED_TAX_RULES_F
9809: set effective_end_date = p_effective_end_date,
9810: sui_state_code = l_work_state_code,
9811: sui_jurisdiction_code = l_work_state_code || '-000-0000'
9812: where assignment_id = p_assignment_id

Line 9818: insert into PAY_US_EMP_FED_TAX_RULES_F

9814: and effective_end_date = l_eff_end_date
9815: and rownum < 2;
9816:
9817: l_step := 17;
9818: insert into PAY_US_EMP_FED_TAX_RULES_F
9819: (emp_fed_tax_rule_id,
9820: effective_start_date,
9821: effective_end_date,
9822: assignment_id,

Line 10051: update PAY_US_EMP_FED_TAX_RULES_F

10047:
10048: /* Update the Federal tax record as of the p_effective_end_date + 1 */
10049:
10050: l_step := 23;
10051: update PAY_US_EMP_FED_TAX_RULES_F
10052: set effective_end_date = p_effective_end_date
10053: where assignment_id = p_assignment_id
10054: and effective_start_date = l_eff_start_date
10055: and effective_end_date = l_eff_end_date;

Line 10058: insert into PAY_US_EMP_FED_TAX_RULES_F

10054: and effective_start_date = l_eff_start_date
10055: and effective_end_date = l_eff_end_date;
10056:
10057: l_step := 24;
10058: insert into PAY_US_EMP_FED_TAX_RULES_F
10059: (emp_fed_tax_rule_id,
10060: effective_start_date,
10061: effective_end_date,
10062: assignment_id,

Line 10284: update PAY_US_EMP_FED_TAX_RULES_F

10280:
10281: /* Update the Federal tax record as of the p_effective_start_date */
10282:
10283: l_step := 30;
10284: update PAY_US_EMP_FED_TAX_RULES_F
10285: set effective_end_date = l_new_date
10286: where assignment_id = p_assignment_id
10287: and effective_start_date = l_eff_start_date
10288: and effective_end_date = p_effective_end_date;

Line 10291: insert into PAY_US_EMP_FED_TAX_RULES_F

10287: and effective_start_date = l_eff_start_date
10288: and effective_end_date = p_effective_end_date;
10289:
10290: l_step := 31;
10291: insert into PAY_US_EMP_FED_TAX_RULES_F
10292: (emp_fed_tax_rule_id,
10293: effective_start_date,
10294: effective_end_date,
10295: assignment_id,

Line 10557: update PAY_US_EMP_FED_TAX_RULES_F

10553: end if;
10554:
10555: /* First update the tax rules records */
10556:
10557: update PAY_US_EMP_FED_TAX_RULES_F
10558: set effective_start_date = p_new_start_date
10559: where assignment_id = p_assignment_id
10560: and l_ef_date between effective_start_date and effective_end_date;
10561:

Line 10608: delete PAY_US_EMP_FED_TAX_RULES_F

10604:
10605: /* Next delete any orphaned rows */
10606: if p_new_start_date > p_default_date then
10607: hr_utility.set_location(l_proc, 10);
10608: delete PAY_US_EMP_FED_TAX_RULES_F
10609: where assignment_id = p_assignment_id
10610: and p_new_start_date > effective_start_date;
10611:
10612: delete PAY_US_EMP_STATE_TAX_RULES_F

Line 11114: from PAY_US_EMP_FED_TAX_RULES_F ftr

11110: cursor csr_chk_federal is
11111: select 'Y'
11112: from DUAL
11113: where exists ( select null
11114: from PAY_US_EMP_FED_TAX_RULES_F ftr
11115: where ftr.assignment_id = p_assignment_id);
11116:
11117: /* Cursor to get the max effective end date of the assignment */
11118:

Line 11352: from PAY_US_EMP_FED_TAX_RULES_F pef

11348: and pa.primary_flag = 'Y';
11349:
11350: cursor csr_get_default_date (p_assignment number) is
11351: select min(effective_start_date)
11352: from PAY_US_EMP_FED_TAX_RULES_F pef
11353: where pef.assignment_id = p_assignment;
11354:
11355: cursor csr_get_end_date (p_assignment number,p_default_date date) is
11356: select effective_end_date

Line 11357: from PAY_US_EMP_FED_TAX_RULES_F pef

11353: where pef.assignment_id = p_assignment;
11354:
11355: cursor csr_get_end_date (p_assignment number,p_default_date date) is
11356: select effective_end_date
11357: from PAY_US_EMP_FED_TAX_RULES_F pef
11358: where pef.assignment_id = p_assignment
11359: and pef.effective_start_date = p_default_date;
11360:
11361: cursor csr_chk_addr_ovrd(p_assignment number) is

Line 11457: from pay_us_emp_fed_tax_rules_f ftr

11453:
11454: cursor csr_fed_tax_loc(p_assignment_id NUMBER, p_min_date DATE
11455: ,p_max_date DATE) is
11456: select *
11457: from pay_us_emp_fed_tax_rules_f ftr
11458: where ftr.assignment_id = p_assignment_id
11459: and ftr.effective_start_date <= p_max_date
11460: and ftr.effective_end_date >= p_min_date;
11461:

Line 12079: /* Delete records from PAY_US_EMP_FED_TAX_RULES_F */

12075: delete PAY_US_EMP_STATE_TAX_RULES_F
12076: where assignment_id = p_assignment_id
12077: and business_group_id = p_business_group_id;
12078:
12079: /* Delete records from PAY_US_EMP_FED_TAX_RULES_F */
12080:
12081: delete PAY_US_EMP_FED_TAX_RULES_F
12082: where assignment_id = p_assignment_id
12083: and business_group_id = p_business_group_id;

Line 12081: delete PAY_US_EMP_FED_TAX_RULES_F

12077: and business_group_id = p_business_group_id;
12078:
12079: /* Delete records from PAY_US_EMP_FED_TAX_RULES_F */
12080:
12081: delete PAY_US_EMP_FED_TAX_RULES_F
12082: where assignment_id = p_assignment_id
12083: and business_group_id = p_business_group_id;
12084:
12085: else

Line 12291: update pay_us_emp_fed_tax_rules_f

12287: /* here we simply update the sui codes */
12288:
12289: hr_utility.set_location('pay_us_emp_dt_tax_rules.validate_default',125);
12290:
12291: update pay_us_emp_fed_tax_rules_f
12292: set sui_state_code = l_loc_state_code,
12293: sui_jurisdiction_code = l_loc_state_code || '-000-0000'
12294: where emp_fed_tax_rule_id = tax_rec.emp_fed_tax_rule_id
12295: and effective_start_date = tax_rec.effective_start_date;