APPS.PAY_US_ACTION_ARCH dependencies on PAY_GET_TAX_EXISTS_PKG

Line 43: pay_get_tax_exists_pkg.

39: to proc update_ytd_withheld
40: 26-JUN-2007 asasthan 115.109 5868672 Head Tax info retrieved from
41: JIT table.
42: 28-NOV-2006 saikrish 115.108 5683349 Corrected the signature of
43: pay_get_tax_exists_pkg.
44: 15-NOV-2006 ahanda 115.107 5264527 Changed select for action_creation
45: code to add hints.
46: Also, changed sql statement to
47: use base table instead secure

Line 4213: pay_get_tax_exists_pkg.get_tax_exists

4209: Purpose : This function checks whether does tax exist for given
4210: assignment_id, tax_unit_id, effective_date, jurisdiction
4211: for State, County and City.
4212: This function calls another function
4213: pay_get_tax_exists_pkg.get_tax_exists
4214: This function returns a 'Y' or 'N'.
4215: Arguments : IN
4216: p_assignment_id number;
4217: p_tax_unit_id number;

Line 4266: pay_get_tax_exists_pkg.get_tax_exists(p_juri_code => p_jurisdiction_code

4262: for i in 1..4 loop
4263:
4264: ln_step := 3;
4265: lv_tax_exists :=
4266: pay_get_tax_exists_pkg.get_tax_exists(p_juri_code => p_jurisdiction_code
4267: ,p_date_earned => p_run_effective_date
4268: ,p_tax_unit_id => p_tax_unit_id
4269: ,p_assign_id => p_assignment_id
4270: ,p_pact_id => NULL /** 5683349*/

Line 4295: pay_get_tax_exists_pkg.get_tax_exists(p_juri_code => p_jurisdiction_code

4291: for i in 1..2 loop
4292:
4293: ln_step := 6;
4294: lv_tax_exists :=
4295: pay_get_tax_exists_pkg.get_tax_exists(p_juri_code => p_jurisdiction_code
4296: ,p_date_earned => p_run_effective_date
4297: ,p_tax_unit_id => p_tax_unit_id
4298: ,p_assign_id => p_assignment_id
4299: ,p_pact_id => NULL /** 5683349*/

Line 4326: pay_get_tax_exists_pkg.get_tax_exists(p_juri_code => p_jurisdiction_code

4322:
4323: ln_step := 9;
4324: if i in (1,2) then
4325: lv_tax_exists :=
4326: pay_get_tax_exists_pkg.get_tax_exists(p_juri_code => p_jurisdiction_code
4327: ,p_date_earned => p_run_effective_date
4328: ,p_tax_unit_id => p_tax_unit_id
4329: ,p_assign_id => p_assignment_id
4330: ,p_pact_id => NULL /** 5683349*/