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 DUAL

Line 886: from sys.DUAL;

882:
883: l_new_date date;
884: cursor csr_fed_tax_rule_id is
885: select PAY_US_EMP_FED_TAX_RULES_S.nextval
886: from sys.DUAL;
887:
888: begin
889:
890:

Line 920: from DUAL;

916: if p_mode = 'UPDATE' then
917:
918: select p_effective_start_date -1
919: into l_new_date
920: from DUAL;
921:
922: /* Update the Federal tax record as of the p_effective_start_date */
923:
924: l_step := 2;

Line 1248: from sys.DUAL;

1244: ) is
1245:
1246: cursor csr_state_tax_rule_id is
1247: select PAY_US_EMP_STATE_TAX_RULES_S.nextval
1248: from sys.DUAL;
1249:
1250: cursor csr_get_row_id is
1251: select rowidtochar(rowid)
1252: from PAY_US_EMP_STATE_TAX_RULES_F str

Line 1620: from sys.DUAL;

1616: p_cnt_information30 in varchar2) is
1617:
1618: cursor csr_county_tax_rule_id is
1619: select PAY_US_EMP_COUNTY_TAX_RULES_S.nextval
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

Line 2003: from sys.DUAL;

1999: p_cty_information30 in varchar2) is
2000:
2001: cursor csr_city_tax_rule_id is
2002: select PAY_US_EMP_CITY_TAX_RULES_S.nextval
2003: from sys.DUAL;
2004:
2005: cursor csr_get_row_id is
2006: select rowidtochar(rowid)
2007: from PAY_US_EMP_CITY_TAX_RULES_F ctr

Line 5586: from dual

5582:
5583:
5584: cursor chk_state_exists is
5585: select 'Y'
5586: from dual
5587: where exists (select null
5588: from pay_us_emp_state_tax_rules_f pst
5589: where pst.assignment_id = p_assignment_id
5590: and state_code = p_state_code

Line 5795: from dual

5791: and language = 'US';
5792:
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

Line 5966: from dual

5962: and language = 'US';
5963:
5964: cursor chk_city_exists is
5965: select 'Y'
5966: from dual
5967: where exists (select null
5968: from pay_us_emp_city_tax_rules_f pst
5969: where pst.assignment_id = p_assignment_id
5970: and state_code = p_state_code

Line 8128: from dual;

8124: /* Get the effective_end_date of the previous
8125: assignment record */
8126: select p_eff_start_date -1
8127: into l_eff_prev_date
8128: from dual;
8129:
8130: /* get the previous location of the assignment */
8131:
8132: open csr_get_prev_location(l_eff_prev_date);

Line 8405: from sys.DUAL;

8401:
8402: /* Get the effective start date of the next assignment record */
8403: select p_effective_end_date + 1
8404: into l_pef_new_start_date
8405: from sys.DUAL;
8406:
8407: /* Do an update insert for the same %age as of the l_pef_new_start_date */
8408: change_entries(p_assignment_id => p_assignment_id,
8409: p_session_date => l_pef_new_start_date,

Line 8530: from SYS.DUAL;

8526: if l_pef_end_date <> l_end_of_time then
8527:
8528: select l_validation_end_date + 1
8529: into l_pef_next_date
8530: from SYS.DUAL;
8531:
8532: /* Get the next location of the assignment */
8533: open csr_get_next_location(l_pef_next_date);
8534: fetch csr_get_next_location into l_next_location;

Line 9248: from DUAL;

9244: existing jurisdictions as of the p_effective_end_date + 1 */
9245:
9246: select p_effective_end_date + 1
9247: into l_new_session_date
9248: from DUAL;
9249:
9250: change_entries(p_assignment_id => p_assignment_id,
9251: p_session_date => l_new_session_date,
9252: p_start_date => l_pef_start_date,

Line 9355: from SYS.DUAL;

9351: l_validation_start_date -1 */
9352:
9353: select l_validation_start_date - 1
9354: into l_prev_end_date
9355: from SYS.DUAL;
9356:
9357: upd_del_entries(p_assignment_id => p_assignment_id,
9358: p_session_date => p_session_date,
9359: p_new_start_date => null,

Line 9550: from DUAL;

9546:
9547: l_step := 8;
9548: select p_effective_start_date -1
9549: into l_new_date
9550: from DUAL;
9551:
9552: l_step := 9;
9553: open csr_get_fed_details(l_eff_start_date, l_eff_end_date);
9554: fetch csr_get_fed_details into l_fed_rec;

Line 9783: from DUAL;

9779:
9780: l_step := 14;
9781: select p_effective_end_date +1
9782: into l_new_date
9783: from DUAL;
9784:
9785: open csr_get_fed_details(l_eff_start_date, l_eff_end_date);
9786: fetch csr_get_fed_details into l_fed_rec;
9787: if csr_get_fed_details%NOTFOUND then

Line 10034: from DUAL;

10030:
10031: l_step := 21;
10032: select p_effective_end_date +1
10033: into l_new_date
10034: from DUAL;
10035:
10036: open csr_get_fed_details(l_eff_start_date, l_eff_end_date);
10037: fetch csr_get_fed_details into l_fed_rec;
10038: if csr_get_fed_details%NOTFOUND then

Line 10263: from DUAL;

10259:
10260: l_step := 28;
10261: select p_effective_start_date -1
10262: into l_new_date
10263: from DUAL;
10264:
10265: /* We do not ned to get the federal record again since we haev already got
10266: it above.
10267:

Line 11112: from DUAL

11108:
11109: /* Cursor to check if a federal record exists or not */
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:

Line 11902: from SYS.DUAL;

11898: if p_effective_end_date < l_default_date then
11899:
11900: select p_effective_end_date + 1
11901: into l_next_date
11902: from SYS.DUAL;
11903:
11904: if l_next_date < l_default_date then
11905:
11906: /* There are some more assignment records without the

Line 12089: from DUAL;

12085: else
12086:
12087: select l_default_date + 1
12088: into l_next_start_date
12089: from DUAL;
12090:
12091: pull_tax_records(p_assignment_id => p_assignment_id,
12092: p_new_start_date => l_next_start_date,
12093: p_default_date => l_default_date);