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 2342: update PAY_US_EMP_FED_TAX_RULES_F

2338: , p_effective_start_date
2339: , p_effective_end_date
2340: , lv_warning);
2341:
2342: update PAY_US_EMP_FED_TAX_RULES_F
2343: set emp_fed_tax_rule_id = p_emp_fed_tax_rule_id,
2344: effective_start_date = p_effective_start_date,
2345: effective_end_date = p_effective_end_date,
2346: assignment_id = p_assignment_id ,

Line 3143: from PAY_US_EMP_FED_TAX_RULES_F

3139: default tax rules criteria was satisfied. */
3140:
3141: cursor csr_get_eff_date is
3142: select min(effective_start_date)
3143: from PAY_US_EMP_FED_TAX_RULES_F
3144: where assignment_id = p_assignment_id;
3145:
3146: begin
3147:

Line 3450: from PAY_US_EMP_FED_TAX_RULES_F

3446: for update of assignment_id nowait;
3447:
3448: cursor csr_fed_rec is
3449: select *
3450: from PAY_US_EMP_FED_TAX_RULES_F
3451: where rowid = chartorowid(p_row_id)
3452: for update of emp_fed_tax_rule_id nowait;
3453:
3454: fed_rec csr_fed_rec%rowtype;

Line 6590: from PAY_US_EMP_FED_TAX_RULES_F

6586: /* End changes by lwthomps (588982)*/
6587:
6588: cursor csr_get_eff_date is
6589: select min(effective_start_date)
6590: from PAY_US_EMP_FED_TAX_RULES_F
6591: where assignment_id = p_assignment_id;
6592:
6593: /* Added cursor csr_get_max_assign_end_dt
6594: for bug 2535501 to get the max(effective_end_date)

Line 7929: from PAY_US_EMP_FED_TAX_RULES_F ftr

7925: satisfied */
7926:
7927: cursor csr_get_eff_date (passignment number) is
7928: select min(ftr.effective_start_date)
7929: from PAY_US_EMP_FED_TAX_RULES_F ftr
7930: where ftr.assignment_id = passignment;
7931:
7932: /* Cursor to get the changes in assignment which in turn will help us
7933: in identifying the change in locations that has taken place within

Line 9384: from PAY_US_EMP_FED_TAX_RULES_F pef

9380:
9381: cursor csr_get_fed_rows is
9382: select pef.effective_start_date, pef.effective_end_date,
9383: pef.sui_jurisdiction_code
9384: from PAY_US_EMP_FED_TAX_RULES_F pef
9385: where pef.assignment_id = p_assignment_id
9386: and p_effective_start_date <= pef.effective_end_date
9387: and p_effective_end_date >= pef.effective_start_date;
9388:

Line 9390: select * from pay_us_emp_fed_tax_rules_f

9386: and p_effective_start_date <= pef.effective_end_date
9387: and p_effective_end_date >= pef.effective_start_date;
9388:
9389: cursor csr_get_fed_details (p_start_date date, p_end_date date) is
9390: select * from pay_us_emp_fed_tax_rules_f
9391: where assignment_id = p_assignment_id
9392: and effective_start_date = p_start_date
9393: and effective_end_date = p_end_date;
9394:

Line 9397: from PAY_US_EMP_FED_TAX_RULES_F

9393: and effective_end_date = p_end_date;
9394:
9395: cursor csr_lck_fed_row (p_start_date date, p_end_date date)is
9396: select rowid
9397: from PAY_US_EMP_FED_TAX_RULES_F
9398: where assignment_id = p_assignment_id
9399: and effective_start_date = p_start_date
9400: and effective_end_date = p_end_date
9401: for update nowait;

Line 9410: l_fed_rec PAY_US_EMP_FED_TAX_RULES_F%rowtype;

9406: l_work_state_code varchar2(2);
9407: l_new_date date;
9408: l_jurisdiction_code varchar2(11);
9409: l_step number;
9410: l_fed_rec PAY_US_EMP_FED_TAX_RULES_F%rowtype;
9411:
9412: begin
9413:
9414: l_step := 1;

Line 9452: update PAY_US_EMP_FED_TAX_RULES_F

9448: close csr_lck_fed_row;
9449:
9450: /* Update the federal tax record for the SUI state */
9451: l_step := 6;
9452: update PAY_US_EMP_FED_TAX_RULES_F
9453: set sui_state_code = l_work_state_code,
9454: sui_jurisdiction_code = l_work_state_code ||'-000-0000'
9455: where rowid = l_row_id;
9456:

Line 9492: update PAY_US_EMP_FED_TAX_RULES_F

9488:
9489: /* Update the Federal tax record as of the p_effective_start_date */
9490:
9491: l_step := 10;
9492: update PAY_US_EMP_FED_TAX_RULES_F
9493: set effective_end_date = l_new_date
9494: where assignment_id = p_assignment_id
9495: and effective_start_date = l_eff_start_date
9496: and effective_end_date = l_eff_end_date;

Line 9499: insert into PAY_US_EMP_FED_TAX_RULES_F

9495: and effective_start_date = l_eff_start_date
9496: and effective_end_date = l_eff_end_date;
9497:
9498: l_step := 11;
9499: insert into PAY_US_EMP_FED_TAX_RULES_F
9500: (emp_fed_tax_rule_id,
9501: effective_start_date,
9502: effective_end_date,
9503: assignment_id,

Line 9724: insert into PAY_US_EMP_FED_TAX_RULES_F

9720:
9721: /* Update the Federal tax record as of the p_effective_start_date */
9722: l_step := 15;
9723: /*
9724: insert into PAY_US_EMP_FED_TAX_RULES_F
9725: select * from pay_us_emp_fed_tax_rules_f
9726: where assignment_id = p_assignment_id
9727: and effective_start_date = l_eff_start_date
9728: and effective_end_date = l_eff_end_date;

Line 9725: select * from pay_us_emp_fed_tax_rules_f

9721: /* Update the Federal tax record as of the p_effective_start_date */
9722: l_step := 15;
9723: /*
9724: insert into PAY_US_EMP_FED_TAX_RULES_F
9725: select * from pay_us_emp_fed_tax_rules_f
9726: where assignment_id = p_assignment_id
9727: and effective_start_date = l_eff_start_date
9728: and effective_end_date = l_eff_end_date;
9729: */

Line 9732: update PAY_US_EMP_FED_TAX_RULES_F

9728: and effective_end_date = l_eff_end_date;
9729: */
9730:
9731: l_step := 16;
9732: update PAY_US_EMP_FED_TAX_RULES_F
9733: set effective_end_date = p_effective_end_date,
9734: sui_state_code = l_work_state_code,
9735: sui_jurisdiction_code = l_work_state_code || '-000-0000'
9736: where assignment_id = p_assignment_id

Line 9742: insert into PAY_US_EMP_FED_TAX_RULES_F

9738: and effective_end_date = l_eff_end_date
9739: and rownum < 2;
9740:
9741: l_step := 17;
9742: insert into PAY_US_EMP_FED_TAX_RULES_F
9743: (emp_fed_tax_rule_id,
9744: effective_start_date,
9745: effective_end_date,
9746: assignment_id,

Line 9975: update PAY_US_EMP_FED_TAX_RULES_F

9971:
9972: /* Update the Federal tax record as of the p_effective_end_date + 1 */
9973:
9974: l_step := 23;
9975: update PAY_US_EMP_FED_TAX_RULES_F
9976: set effective_end_date = p_effective_end_date
9977: where assignment_id = p_assignment_id
9978: and effective_start_date = l_eff_start_date
9979: and effective_end_date = l_eff_end_date;

Line 9982: insert into PAY_US_EMP_FED_TAX_RULES_F

9978: and effective_start_date = l_eff_start_date
9979: and effective_end_date = l_eff_end_date;
9980:
9981: l_step := 24;
9982: insert into PAY_US_EMP_FED_TAX_RULES_F
9983: (emp_fed_tax_rule_id,
9984: effective_start_date,
9985: effective_end_date,
9986: assignment_id,

Line 10208: update PAY_US_EMP_FED_TAX_RULES_F

10204:
10205: /* Update the Federal tax record as of the p_effective_start_date */
10206:
10207: l_step := 30;
10208: update PAY_US_EMP_FED_TAX_RULES_F
10209: set effective_end_date = l_new_date
10210: where assignment_id = p_assignment_id
10211: and effective_start_date = l_eff_start_date
10212: and effective_end_date = p_effective_end_date;

Line 10215: insert into PAY_US_EMP_FED_TAX_RULES_F

10211: and effective_start_date = l_eff_start_date
10212: and effective_end_date = p_effective_end_date;
10213:
10214: l_step := 31;
10215: insert into PAY_US_EMP_FED_TAX_RULES_F
10216: (emp_fed_tax_rule_id,
10217: effective_start_date,
10218: effective_end_date,
10219: assignment_id,

Line 10481: update PAY_US_EMP_FED_TAX_RULES_F

10477: end if;
10478:
10479: /* First update the tax rules records */
10480:
10481: update PAY_US_EMP_FED_TAX_RULES_F
10482: set effective_start_date = p_new_start_date
10483: where assignment_id = p_assignment_id
10484: and l_ef_date between effective_start_date and effective_end_date;
10485:

Line 10532: delete PAY_US_EMP_FED_TAX_RULES_F

10528:
10529: /* Next delete any orphaned rows */
10530: if p_new_start_date > p_default_date then
10531: hr_utility.set_location(l_proc, 10);
10532: delete PAY_US_EMP_FED_TAX_RULES_F
10533: where assignment_id = p_assignment_id
10534: and p_new_start_date > effective_start_date;
10535:
10536: delete PAY_US_EMP_STATE_TAX_RULES_F

Line 11038: from PAY_US_EMP_FED_TAX_RULES_F ftr

11034: cursor csr_chk_federal is
11035: select 'Y'
11036: from DUAL
11037: where exists ( select null
11038: from PAY_US_EMP_FED_TAX_RULES_F ftr
11039: where ftr.assignment_id = p_assignment_id);
11040:
11041: /* Cursor to get the max effective end date of the assignment */
11042:

Line 11276: from PAY_US_EMP_FED_TAX_RULES_F pef

11272: and pa.primary_flag = 'Y';
11273:
11274: cursor csr_get_default_date (p_assignment number) is
11275: select min(effective_start_date)
11276: from PAY_US_EMP_FED_TAX_RULES_F pef
11277: where pef.assignment_id = p_assignment;
11278:
11279: cursor csr_get_end_date (p_assignment number,p_default_date date) is
11280: select effective_end_date

Line 11281: from PAY_US_EMP_FED_TAX_RULES_F pef

11277: where pef.assignment_id = p_assignment;
11278:
11279: cursor csr_get_end_date (p_assignment number,p_default_date date) is
11280: select effective_end_date
11281: from PAY_US_EMP_FED_TAX_RULES_F pef
11282: where pef.assignment_id = p_assignment
11283: and pef.effective_start_date = p_default_date;
11284:
11285: cursor csr_chk_addr_ovrd(p_assignment number) is

Line 11381: from pay_us_emp_fed_tax_rules_f ftr

11377:
11378: cursor csr_fed_tax_loc(p_assignment_id NUMBER, p_min_date DATE
11379: ,p_max_date DATE) is
11380: select *
11381: from pay_us_emp_fed_tax_rules_f ftr
11382: where ftr.assignment_id = p_assignment_id
11383: and ftr.effective_start_date <= p_max_date
11384: and ftr.effective_end_date >= p_min_date;
11385:

Line 12003: /* Delete records from PAY_US_EMP_FED_TAX_RULES_F */

11999: delete PAY_US_EMP_STATE_TAX_RULES_F
12000: where assignment_id = p_assignment_id
12001: and business_group_id = p_business_group_id;
12002:
12003: /* Delete records from PAY_US_EMP_FED_TAX_RULES_F */
12004:
12005: delete PAY_US_EMP_FED_TAX_RULES_F
12006: where assignment_id = p_assignment_id
12007: and business_group_id = p_business_group_id;

Line 12005: delete PAY_US_EMP_FED_TAX_RULES_F

12001: and business_group_id = p_business_group_id;
12002:
12003: /* Delete records from PAY_US_EMP_FED_TAX_RULES_F */
12004:
12005: delete PAY_US_EMP_FED_TAX_RULES_F
12006: where assignment_id = p_assignment_id
12007: and business_group_id = p_business_group_id;
12008:
12009: else

Line 12215: update pay_us_emp_fed_tax_rules_f

12211: /* here we simply update the sui codes */
12212:
12213: hr_utility.set_location('pay_us_emp_dt_tax_rules.validate_default',125);
12214:
12215: update pay_us_emp_fed_tax_rules_f
12216: set sui_state_code = l_loc_state_code,
12217: sui_jurisdiction_code = l_loc_state_code || '-000-0000'
12218: where emp_fed_tax_rule_id = tax_rec.emp_fed_tax_rule_id
12219: and effective_start_date = tax_rec.effective_start_date;