APPS.PAY_US_TAX_INTERNAL dependencies on PAY_CTY_SHD

Line 3759: l_cty_rec pay_cty_shd.g_rec_type;

3755: l_sta_rec pay_sta_shd.g_rec_type;
3756: l_sta_rec_dup pay_sta_shd.g_rec_type;
3757: l_cnt_rec pay_cnt_shd.g_rec_type;
3758: l_cnt_rec_dup pay_cnt_shd.g_rec_type;
3759: l_cty_rec pay_cty_shd.g_rec_type;
3760: l_cty_rec_dup pay_cty_shd.g_rec_type;
3761: l_exit_quietly exception;
3762: --
3763: cursor csr_fed_tax_dates is

Line 3760: l_cty_rec_dup pay_cty_shd.g_rec_type;

3756: l_sta_rec_dup pay_sta_shd.g_rec_type;
3757: l_cnt_rec pay_cnt_shd.g_rec_type;
3758: l_cnt_rec_dup pay_cnt_shd.g_rec_type;
3759: l_cty_rec pay_cty_shd.g_rec_type;
3760: l_cty_rec_dup pay_cty_shd.g_rec_type;
3761: l_exit_quietly exception;
3762: --
3763: cursor csr_fed_tax_dates is
3764: select min(effective_start_date), max(effective_end_date)

Line 5336: l_city_rec pay_cty_shd.g_rec_type;

5332: l_state_rec pay_sta_shd.g_rec_type;
5333: l_state_rec_dup pay_sta_shd.g_rec_type;
5334: l_county_rec pay_cnt_shd.g_rec_type;
5335: l_county_rec_dup pay_cnt_shd.g_rec_type;
5336: l_city_rec pay_cty_shd.g_rec_type;
5337: l_city_rec_dup pay_cty_shd.g_rec_type;
5338: l_exists varchar2(1);
5339: --
5340: l_exit_quietly exception;

Line 5337: l_city_rec_dup pay_cty_shd.g_rec_type;

5333: l_state_rec_dup pay_sta_shd.g_rec_type;
5334: l_county_rec pay_cnt_shd.g_rec_type;
5335: l_county_rec_dup pay_cnt_shd.g_rec_type;
5336: l_city_rec pay_cty_shd.g_rec_type;
5337: l_city_rec_dup pay_cty_shd.g_rec_type;
5338: l_exists varchar2(1);
5339: --
5340: l_exit_quietly exception;
5341: --

Line 5866: l_city_rec pay_cty_shd.g_rec_type;

5862: l_tmp_esd date;
5863: l_tmp_eed date;
5864: l_state_rec pay_sta_shd.g_rec_type;
5865: l_county_rec pay_cnt_shd.g_rec_type;
5866: l_city_rec pay_cty_shd.g_rec_type;
5867:
5868: begin
5869: update pay_us_emp_fed_tax_rules_f
5870: set effective_start_date = p_new_default_date

Line 5970: l_city_rec pay_cty_shd.g_rec_type;

5966: l_tmp_esd date;
5967: l_tmp_eed date;
5968: l_state_rec pay_sta_shd.g_rec_type;
5969: l_county_rec pay_cnt_shd.g_rec_type;
5970: l_city_rec pay_cty_shd.g_rec_type;
5971:
5972: begin
5973: maintain_wc(
5974: p_emp_fed_tax_rule_id => p_emp_fed_tax_rule_id

Line 6054: l_city_rec pay_cty_shd.g_rec_type;

6050: l_state_rec pay_sta_shd.g_rec_type;
6051: l_state_rec_dup pay_sta_shd.g_rec_type;
6052: l_county_rec pay_cnt_shd.g_rec_type;
6053: l_county_rec_dup pay_cnt_shd.g_rec_type;
6054: l_city_rec pay_cty_shd.g_rec_type;
6055: l_city_rec_dup pay_cty_shd.g_rec_type;
6056: l_exists varchar2(1);
6057:
6058: begin

Line 6055: l_city_rec_dup pay_cty_shd.g_rec_type;

6051: l_state_rec_dup pay_sta_shd.g_rec_type;
6052: l_county_rec pay_cnt_shd.g_rec_type;
6053: l_county_rec_dup pay_cnt_shd.g_rec_type;
6054: l_city_rec pay_cty_shd.g_rec_type;
6055: l_city_rec_dup pay_cty_shd.g_rec_type;
6056: l_exists varchar2(1);
6057:
6058: begin
6059: --