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 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 1596: from sys.DUAL;

1592: p_cnt_information30 in varchar2) is
1593:
1594: cursor csr_county_tax_rule_id is
1595: select PAY_US_EMP_COUNTY_TAX_RULES_S.nextval
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

Line 1955: from sys.DUAL;

1951: p_cty_information30 in varchar2) is
1952:
1953: cursor csr_city_tax_rule_id is
1954: select PAY_US_EMP_CITY_TAX_RULES_S.nextval
1955: from sys.DUAL;
1956:
1957: cursor csr_get_row_id is
1958: select rowidtochar(rowid)
1959: from PAY_US_EMP_CITY_TAX_RULES_F ctr

Line 5510: from dual

5506:
5507:
5508: cursor chk_state_exists is
5509: select 'Y'
5510: from dual
5511: where exists (select null
5512: from pay_us_emp_state_tax_rules_f pst
5513: where pst.assignment_id = p_assignment_id
5514: and state_code = p_state_code

Line 5719: from dual

5715: and language = 'US';
5716:
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

Line 5890: from dual

5886: and language = 'US';
5887:
5888: cursor chk_city_exists is
5889: select 'Y'
5890: from dual
5891: where exists (select null
5892: from pay_us_emp_city_tax_rules_f pst
5893: where pst.assignment_id = p_assignment_id
5894: and state_code = p_state_code

Line 8052: from dual;

8048: /* Get the effective_end_date of the previous
8049: assignment record */
8050: select p_eff_start_date -1
8051: into l_eff_prev_date
8052: from dual;
8053:
8054: /* get the previous location of the assignment */
8055:
8056: open csr_get_prev_location(l_eff_prev_date);

Line 8329: from sys.DUAL;

8325:
8326: /* Get the effective start date of the next assignment record */
8327: select p_effective_end_date + 1
8328: into l_pef_new_start_date
8329: from sys.DUAL;
8330:
8331: /* Do an update insert for the same %age as of the l_pef_new_start_date */
8332: change_entries(p_assignment_id => p_assignment_id,
8333: p_session_date => l_pef_new_start_date,

Line 8454: from SYS.DUAL;

8450: if l_pef_end_date <> l_end_of_time then
8451:
8452: select l_validation_end_date + 1
8453: into l_pef_next_date
8454: from SYS.DUAL;
8455:
8456: /* Get the next location of the assignment */
8457: open csr_get_next_location(l_pef_next_date);
8458: fetch csr_get_next_location into l_next_location;

Line 9172: from DUAL;

9168: existing jurisdictions as of the p_effective_end_date + 1 */
9169:
9170: select p_effective_end_date + 1
9171: into l_new_session_date
9172: from DUAL;
9173:
9174: change_entries(p_assignment_id => p_assignment_id,
9175: p_session_date => l_new_session_date,
9176: p_start_date => l_pef_start_date,

Line 9279: from SYS.DUAL;

9275: l_validation_start_date -1 */
9276:
9277: select l_validation_start_date - 1
9278: into l_prev_end_date
9279: from SYS.DUAL;
9280:
9281: upd_del_entries(p_assignment_id => p_assignment_id,
9282: p_session_date => p_session_date,
9283: p_new_start_date => null,

Line 9474: from DUAL;

9470:
9471: l_step := 8;
9472: select p_effective_start_date -1
9473: into l_new_date
9474: from DUAL;
9475:
9476: l_step := 9;
9477: open csr_get_fed_details(l_eff_start_date, l_eff_end_date);
9478: fetch csr_get_fed_details into l_fed_rec;

Line 9707: from DUAL;

9703:
9704: l_step := 14;
9705: select p_effective_end_date +1
9706: into l_new_date
9707: from DUAL;
9708:
9709: open csr_get_fed_details(l_eff_start_date, l_eff_end_date);
9710: fetch csr_get_fed_details into l_fed_rec;
9711: if csr_get_fed_details%NOTFOUND then

Line 9958: from DUAL;

9954:
9955: l_step := 21;
9956: select p_effective_end_date +1
9957: into l_new_date
9958: from DUAL;
9959:
9960: open csr_get_fed_details(l_eff_start_date, l_eff_end_date);
9961: fetch csr_get_fed_details into l_fed_rec;
9962: if csr_get_fed_details%NOTFOUND then

Line 10187: from DUAL;

10183:
10184: l_step := 28;
10185: select p_effective_start_date -1
10186: into l_new_date
10187: from DUAL;
10188:
10189: /* We do not ned to get the federal record again since we haev already got
10190: it above.
10191:

Line 11036: from DUAL

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

Line 11826: from SYS.DUAL;

11822: if p_effective_end_date < l_default_date then
11823:
11824: select p_effective_end_date + 1
11825: into l_next_date
11826: from SYS.DUAL;
11827:
11828: if l_next_date < l_default_date then
11829:
11830: /* There are some more assignment records without the

Line 12013: from DUAL;

12009: else
12010:
12011: select l_default_date + 1
12012: into l_next_start_date
12013: from DUAL;
12014:
12015: pull_tax_records(p_assignment_id => p_assignment_id,
12016: p_new_start_date => l_next_start_date,
12017: p_default_date => l_default_date);