DBA Data[Home] [Help]

APPS.PAY_US_TAX_API dependencies on PAY_ELEMENT_ENTRIES_F

Line 145: from pay_element_entries_f peef,

141: p_jurisdiction varchar2,
142: p_effective_date date
143: ) is
144: select count(*)
145: from pay_element_entries_f peef,
146: pay_element_entry_values_f peevf,
147: pay_element_types_f petf,
148: pay_element_links_f pelf
149: where peef.assignment_id=p_assignment_id

Line 176: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

172: l_emp_county_tax_rule_id
173: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE;
174: l_emp_state_tax_rule_id
175: pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
176: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
177: t_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
178: l_effective_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
179: l_vertex_exist number;
180: l_delete_jurisdiction number;