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 1959: from PAY_US_EMP_CITY_TAX_RULES_F ctr

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
1960: where ctr.emp_city_tax_rule_id = p_emp_city_tax_rule_id
1961: and ctr.effective_start_date = p_effective_start_date
1962: and ctr.effective_end_date = p_effective_end_date;
1963:

Line 1999: insert into PAY_US_EMP_CITY_TAX_RULES_F

1995:
1996: hr_utility.set_location('pay_us_emp_dt_tax_rules.insert_city_tax_row'||
1997: ' - inserting row', 4);
1998:
1999: insert into PAY_US_EMP_CITY_TAX_RULES_F
2000: (emp_city_tax_rule_id,
2001: effective_start_date,
2002: effective_end_date,
2003: assignment_id,

Line 2977: update PAY_US_EMP_CITY_TAX_RULES_F

2973:
2974: hr_utility.set_location('pay_us_emp_dt_tax_rules.update_city_tax_row'||
2975: ' - updating row', 2);
2976:
2977: update PAY_US_EMP_CITY_TAX_RULES_F
2978: set emp_city_tax_rule_id = p_emp_city_tax_rule_id,
2979: effective_start_date = p_effective_start_date,
2980: effective_end_date = p_effective_end_date,
2981: assignment_id = p_assignment_id,

Line 3125: from PAY_US_EMP_CITY_TAX_RULES_F puc

3121:
3122: /* Cursor to get the cities for the state */
3123: cursor csr_state_cities is
3124: select puc.jurisdiction_code
3125: from PAY_US_EMP_CITY_TAX_RULES_F puc
3126: where puc.assignment_id = p_assignment_id
3127: and puc.state_code = p_state_code;
3128:
3129: /* Cursor to get the cities for the county */

Line 3132: from PAY_US_EMP_CITY_TAX_RULES_F puc

3128:
3129: /* Cursor to get the cities for the county */
3130: cursor csr_county_cities is
3131: select puc.jurisdiction_code
3132: from PAY_US_EMP_CITY_TAX_RULES_F puc
3133: where puc.assignment_id = p_assignment_id
3134: and puc.state_code = p_state_code
3135: and puc.county_code = p_county_code;
3136:

Line 3243: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */

3239: p_percentage_time => 0,
3240: p_mode => 'ZAP');
3241: end if;
3242:
3243: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */
3244:
3245: delete PAY_US_EMP_CITY_TAX_RULES_F
3246: where assignment_id = p_assignment_id
3247: and state_code = p_state_code;

Line 3245: delete PAY_US_EMP_CITY_TAX_RULES_F

3241: end if;
3242:
3243: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */
3244:
3245: delete PAY_US_EMP_CITY_TAX_RULES_F
3246: where assignment_id = p_assignment_id
3247: and state_code = p_state_code;
3248:
3249: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */

Line 3303: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */

3299: p_percentage_time => 0,
3300: p_mode => 'ZAP');
3301: end if;
3302:
3303: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */
3304:
3305: delete PAY_US_EMP_CITY_TAX_RULES_F
3306: where assignment_id = p_assignment_id
3307: and state_code = p_state_code

Line 3305: delete PAY_US_EMP_CITY_TAX_RULES_F

3301: end if;
3302:
3303: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */
3304:
3305: delete PAY_US_EMP_CITY_TAX_RULES_F
3306: where assignment_id = p_assignment_id
3307: and state_code = p_state_code
3308: and county_code = p_county_code;
3309:

Line 3335: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */

3331: p_mode => 'ZAP');
3332:
3333: end if;
3334:
3335: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */
3336:
3337: delete PAY_US_EMP_CITY_TAX_RULES_F
3338: where assignment_id = p_assignment_id
3339: and state_code = p_state_code

Line 3337: delete PAY_US_EMP_CITY_TAX_RULES_F

3333: end if;
3334:
3335: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */
3336:
3337: delete PAY_US_EMP_CITY_TAX_RULES_F
3338: where assignment_id = p_assignment_id
3339: and state_code = p_state_code
3340: and county_code = p_county_code
3341: and city_code = p_city_code;

Line 4885: from PAY_US_EMP_CITY_TAX_RULES_F

4881:
4882:
4883: cursor csr_city_rec is
4884: select *
4885: from PAY_US_EMP_CITY_TAX_RULES_F
4886: where rowid = chartorowid(p_row_id)
4887: for update of emp_city_tax_rule_id nowait;
4888:
4889: city_rec csr_city_rec%rowtype;

Line 5892: from pay_us_emp_city_tax_rules_f pst

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
5895: and county_code = p_county_code
5896: and city_code = p_city_code

Line 7241: from PAY_US_EMP_CITY_TAX_RULES_F ctr

7237: cursor csr_get_cities is
7238: select state_code,
7239: county_code,
7240: city_code
7241: from PAY_US_EMP_CITY_TAX_RULES_F ctr
7242: where ctr.assignment_id = p_assignment_id
7243: and p_session_date between ctr.effective_start_date
7244: and ctr.effective_end_date;
7245:

Line 7549: from PAY_US_EMP_CITY_TAX_RULES_F ctr

7545: cursor csr_get_cities is
7546: select state_code,
7547: county_code,
7548: city_code
7549: from PAY_US_EMP_CITY_TAX_RULES_F ctr
7550: where ctr.assignment_id = p_assignment_id
7551: and p_session_date between
7552: ctr.effective_start_date and ctr.effective_end_date;
7553:

Line 10517: update PAY_US_EMP_CITY_TAX_RULES_F

10513: fnd_message.set_token('STEP','4');
10514: fnd_message.raise_error;
10515: end if;
10516:
10517: update PAY_US_EMP_CITY_TAX_RULES_F
10518: set effective_start_date = p_new_start_date
10519: where assignment_id = p_assignment_id
10520: and l_ef_date between effective_start_date and effective_end_date;
10521:

Line 10544: delete PAY_US_EMP_CITY_TAX_RULES_F

10540: delete PAY_US_EMP_COUNTY_TAX_RULES_F
10541: where assignment_id = p_assignment_id
10542: and p_new_start_date > effective_start_date;
10543:
10544: delete PAY_US_EMP_CITY_TAX_RULES_F
10545: where assignment_id = p_assignment_id
10546: and p_new_start_date > effective_start_date;
10547:
10548: end if;

Line 11985: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */

11981: p_effective_start_date => p_session_date,
11982: p_business_group_id => p_business_group_id)
11983: then
11984:
11985: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */
11986:
11987: delete PAY_US_EMP_CITY_TAX_RULES_F
11988: where assignment_id = p_assignment_id
11989: and business_group_id = p_business_group_id;

Line 11987: delete PAY_US_EMP_CITY_TAX_RULES_F

11983: then
11984:
11985: /* Delete records from PAY_US_EMP_CITY_TAX_RULES_F */
11986:
11987: delete PAY_US_EMP_CITY_TAX_RULES_F
11988: where assignment_id = p_assignment_id
11989: and business_group_id = p_business_group_id;
11990:
11991: /* Delete records from PAY_US_EMP_COUNTY_TAX_RULES_F */