APPS.PAY_US_TAX_INTERNAL dependencies on PAY_CTY_SHD

Line 3675: l_cty_rec pay_cty_shd.g_rec_type;

3671: l_sta_rec pay_sta_shd.g_rec_type;
3672: l_sta_rec_dup pay_sta_shd.g_rec_type;
3673: l_cnt_rec pay_cnt_shd.g_rec_type;
3674: l_cnt_rec_dup pay_cnt_shd.g_rec_type;
3675: l_cty_rec pay_cty_shd.g_rec_type;
3676: l_cty_rec_dup pay_cty_shd.g_rec_type;
3677: l_exit_quietly exception;
3678: --
3679: cursor csr_fed_tax_dates is

Line 3676: l_cty_rec_dup pay_cty_shd.g_rec_type;

3672: l_sta_rec_dup pay_sta_shd.g_rec_type;
3673: l_cnt_rec pay_cnt_shd.g_rec_type;
3674: l_cnt_rec_dup pay_cnt_shd.g_rec_type;
3675: l_cty_rec pay_cty_shd.g_rec_type;
3676: l_cty_rec_dup pay_cty_shd.g_rec_type;
3677: l_exit_quietly exception;
3678: --
3679: cursor csr_fed_tax_dates is
3680: select min(effective_start_date), max(effective_end_date)

Line 5252: l_city_rec pay_cty_shd.g_rec_type;

5248: l_state_rec pay_sta_shd.g_rec_type;
5249: l_state_rec_dup pay_sta_shd.g_rec_type;
5250: l_county_rec pay_cnt_shd.g_rec_type;
5251: l_county_rec_dup pay_cnt_shd.g_rec_type;
5252: l_city_rec pay_cty_shd.g_rec_type;
5253: l_city_rec_dup pay_cty_shd.g_rec_type;
5254: l_exists varchar2(1);
5255: --
5256: l_exit_quietly exception;

Line 5253: l_city_rec_dup pay_cty_shd.g_rec_type;

5249: l_state_rec_dup pay_sta_shd.g_rec_type;
5250: l_county_rec pay_cnt_shd.g_rec_type;
5251: l_county_rec_dup pay_cnt_shd.g_rec_type;
5252: l_city_rec pay_cty_shd.g_rec_type;
5253: l_city_rec_dup pay_cty_shd.g_rec_type;
5254: l_exists varchar2(1);
5255: --
5256: l_exit_quietly exception;
5257: --

Line 5782: l_city_rec pay_cty_shd.g_rec_type;

5778: l_tmp_esd date;
5779: l_tmp_eed date;
5780: l_state_rec pay_sta_shd.g_rec_type;
5781: l_county_rec pay_cnt_shd.g_rec_type;
5782: l_city_rec pay_cty_shd.g_rec_type;
5783:
5784: begin
5785: update pay_us_emp_fed_tax_rules_f
5786: set effective_start_date = p_new_default_date

Line 5886: l_city_rec pay_cty_shd.g_rec_type;

5882: l_tmp_esd date;
5883: l_tmp_eed date;
5884: l_state_rec pay_sta_shd.g_rec_type;
5885: l_county_rec pay_cnt_shd.g_rec_type;
5886: l_city_rec pay_cty_shd.g_rec_type;
5887:
5888: begin
5889: maintain_wc(
5890: p_emp_fed_tax_rule_id => p_emp_fed_tax_rule_id

Line 5970: l_city_rec pay_cty_shd.g_rec_type;

5966: l_state_rec pay_sta_shd.g_rec_type;
5967: l_state_rec_dup pay_sta_shd.g_rec_type;
5968: l_county_rec pay_cnt_shd.g_rec_type;
5969: l_county_rec_dup pay_cnt_shd.g_rec_type;
5970: l_city_rec pay_cty_shd.g_rec_type;
5971: l_city_rec_dup pay_cty_shd.g_rec_type;
5972: l_exists varchar2(1);
5973:
5974: begin

Line 5971: l_city_rec_dup pay_cty_shd.g_rec_type;

5967: l_state_rec_dup pay_sta_shd.g_rec_type;
5968: l_county_rec pay_cnt_shd.g_rec_type;
5969: l_county_rec_dup pay_cnt_shd.g_rec_type;
5970: l_city_rec pay_cty_shd.g_rec_type;
5971: l_city_rec_dup pay_cty_shd.g_rec_type;
5972: l_exists varchar2(1);
5973:
5974: begin
5975: --