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_CITY_TAX_RULES_F

Line 2007: from PAY_US_EMP_CITY_TAX_RULES_F ctr

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
2008: where ctr.emp_city_tax_rule_id = p_emp_city_tax_rule_id
2009: and ctr.effective_start_date = p_effective_start_date
2010: and ctr.effective_end_date = p_effective_end_date;
2011:

Line 2015: from pay_us_emp_city_tax_rules_f sta

2011:
2012: /** added for bug 13872151 **/
2013: cursor csr_city_tax_rule is
2014: select null
2015: from pay_us_emp_city_tax_rules_f sta
2016: where sta.assignment_id = p_assignment_id
2017: and sta.state_code = p_state_code
2018: and sta.county_code= p_county_code
2019: and sta.city_code= p_city_code;

Line 2074: insert into PAY_US_EMP_CITY_TAX_RULES_F

2070: end if;
2071: close csr_city_tax_rule;
2072: -- End of changes for bug 13872151
2073:
2074: insert into PAY_US_EMP_CITY_TAX_RULES_F
2075: (emp_city_tax_rule_id,
2076: effective_start_date,
2077: effective_end_date,
2078: assignment_id,

Line 3053: update PAY_US_EMP_CITY_TAX_RULES_F

3049:
3050: hr_utility.set_location('pay_us_emp_dt_tax_rules.update_city_tax_row'||
3051: ' - updating row', 2);
3052:
3053: update PAY_US_EMP_CITY_TAX_RULES_F
3054: set emp_city_tax_rule_id = p_emp_city_tax_rule_id,
3055: effective_start_date = p_effective_start_date,
3056: effective_end_date = p_effective_end_date,
3057: assignment_id = p_assignment_id,

Line 3201: from PAY_US_EMP_CITY_TAX_RULES_F puc

3197:
3198: /* Cursor to get the cities for the state */
3199: cursor csr_state_cities is
3200: select puc.jurisdiction_code
3201: from PAY_US_EMP_CITY_TAX_RULES_F puc
3202: where puc.assignment_id = p_assignment_id
3203: and puc.state_code = p_state_code;
3204:
3205: /* Cursor to get the cities for the county */

Line 3208: from PAY_US_EMP_CITY_TAX_RULES_F puc

3204:
3205: /* Cursor to get the cities for the county */
3206: cursor csr_county_cities is
3207: select puc.jurisdiction_code
3208: from PAY_US_EMP_CITY_TAX_RULES_F puc
3209: where puc.assignment_id = p_assignment_id
3210: and puc.state_code = p_state_code
3211: and puc.county_code = p_county_code;
3212:

Line 3319: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */

3315: p_percentage_time => 0,
3316: p_mode => 'ZAP');
3317: end if;
3318:
3319: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */
3320:
3321: delete PAY_US_EMP_CITY_TAX_RULES_F
3322: where assignment_id = p_assignment_id
3323: and state_code = p_state_code;

Line 3321: delete PAY_US_EMP_CITY_TAX_RULES_F

3317: end if;
3318:
3319: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */
3320:
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 */

Line 3379: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */

3375: p_percentage_time => 0,
3376: p_mode => 'ZAP');
3377: end if;
3378:
3379: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */
3380:
3381: delete PAY_US_EMP_CITY_TAX_RULES_F
3382: where assignment_id = p_assignment_id
3383: and state_code = p_state_code

Line 3381: delete PAY_US_EMP_CITY_TAX_RULES_F

3377: end if;
3378:
3379: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */
3380:
3381: delete PAY_US_EMP_CITY_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:

Line 3411: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */

3407: p_mode => 'ZAP');
3408:
3409: end if;
3410:
3411: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */
3412:
3413: delete PAY_US_EMP_CITY_TAX_RULES_F
3414: where assignment_id = p_assignment_id
3415: and state_code = p_state_code

Line 3413: delete PAY_US_EMP_CITY_TAX_RULES_F

3409: end if;
3410:
3411: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */
3412:
3413: delete PAY_US_EMP_CITY_TAX_RULES_F
3414: where assignment_id = p_assignment_id
3415: and state_code = p_state_code
3416: and county_code = p_county_code
3417: and city_code = p_city_code;

Line 4961: from PAY_US_EMP_CITY_TAX_RULES_F

4957:
4958:
4959: cursor csr_city_rec is
4960: select *
4961: from PAY_US_EMP_CITY_TAX_RULES_F
4962: where rowid = chartorowid(p_row_id)
4963: for update of emp_city_tax_rule_id nowait;
4964:
4965: city_rec csr_city_rec%rowtype;

Line 5968: from pay_us_emp_city_tax_rules_f pst

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
5971: and county_code = p_county_code
5972: and city_code = p_city_code

Line 7317: from PAY_US_EMP_CITY_TAX_RULES_F ctr

7313: cursor csr_get_cities is
7314: select state_code,
7315: county_code,
7316: city_code
7317: from PAY_US_EMP_CITY_TAX_RULES_F ctr
7318: where ctr.assignment_id = p_assignment_id
7319: and p_session_date between ctr.effective_start_date
7320: and ctr.effective_end_date;
7321:

Line 7625: from PAY_US_EMP_CITY_TAX_RULES_F ctr

7621: cursor csr_get_cities is
7622: select state_code,
7623: county_code,
7624: city_code
7625: from PAY_US_EMP_CITY_TAX_RULES_F ctr
7626: where ctr.assignment_id = p_assignment_id
7627: and p_session_date between
7628: ctr.effective_start_date and ctr.effective_end_date;
7629:

Line 10593: update PAY_US_EMP_CITY_TAX_RULES_F

10589: fnd_message.set_token('STEP','4');
10590: fnd_message.raise_error;
10591: end if;
10592:
10593: update PAY_US_EMP_CITY_TAX_RULES_F
10594: set effective_start_date = p_new_start_date
10595: where assignment_id = p_assignment_id
10596: and l_ef_date between effective_start_date and effective_end_date;
10597:

Line 10620: delete PAY_US_EMP_CITY_TAX_RULES_F

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
10621: where assignment_id = p_assignment_id
10622: and p_new_start_date > effective_start_date;
10623:
10624: end if;

Line 12061: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */

12057: p_effective_start_date => p_session_date,
12058: p_business_group_id => p_business_group_id)
12059: then
12060:
12061: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */
12062:
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;

Line 12063: delete PAY_US_EMP_CITY_TAX_RULES_F

12059: then
12060:
12061: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */
12062:
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 */