APPS.PAY_US_ACTION_ARCH dependencies on PAY_GET_TAX_EXISTS_PKG

Line 127: pay_get_tax_exists_pkg.

123: to proc update_ytd_withheld
124: 26-JUN-2007 asasthan 115.109 5868672 Head Tax info retrieved from
125: JIT table.
126: 28-NOV-2006 saikrish 115.108 5683349 Corrected the signature of
127: pay_get_tax_exists_pkg.
128: 15-NOV-2006 ahanda 115.107 5264527 Changed select for action_creation
129: code to add hints.
130: Also, changed sql statement to
131: use base table instead secure

Line 5152: pay_get_tax_exists_pkg.get_tax_exists

5148: Purpose : This function checks whether does tax exist for given
5149: assignment_id, tax_unit_id, effective_date, jurisdiction
5150: for State, County and City.
5151: This function calls another function
5152: pay_get_tax_exists_pkg.get_tax_exists
5153: This function returns a 'Y' or 'N'.
5154: Arguments : IN
5155: p_assignment_id number;
5156: p_tax_unit_id number;

Line 5205: pay_get_tax_exists_pkg.get_tax_exists(p_juri_code => p_jurisdiction_code

5201: for i in 1..4 loop
5202:
5203: ln_step := 3;
5204: lv_tax_exists :=
5205: pay_get_tax_exists_pkg.get_tax_exists(p_juri_code => p_jurisdiction_code
5206: ,p_date_earned => p_run_effective_date
5207: ,p_tax_unit_id => p_tax_unit_id
5208: ,p_assign_id => p_assignment_id
5209: ,p_pact_id => NULL /** 5683349*/

Line 5234: pay_get_tax_exists_pkg.get_tax_exists(p_juri_code => p_jurisdiction_code

5230: for i in 1..2 loop
5231:
5232: ln_step := 6;
5233: lv_tax_exists :=
5234: pay_get_tax_exists_pkg.get_tax_exists(p_juri_code => p_jurisdiction_code
5235: ,p_date_earned => p_run_effective_date
5236: ,p_tax_unit_id => p_tax_unit_id
5237: ,p_assign_id => p_assignment_id
5238: ,p_pact_id => NULL /** 5683349*/

Line 5265: pay_get_tax_exists_pkg.get_tax_exists(p_juri_code => p_jurisdiction_code

5261:
5262: ln_step := 9;
5263: if i in (1,2) then
5264: lv_tax_exists :=
5265: pay_get_tax_exists_pkg.get_tax_exists(p_juri_code => p_jurisdiction_code
5266: ,p_date_earned => p_run_effective_date
5267: ,p_tax_unit_id => p_tax_unit_id
5268: ,p_assign_id => p_assignment_id
5269: ,p_pact_id => NULL /** 5683349*/