DBA Data[Home] [Help]

APPS.PAY_US_TAX_INTERNAL dependencies on PAY_INPUT_VALUES_F

Line 329: pay_input_values_f pivf,

325: peef.effective_end_date,
326: peevf.screen_entry_value
327: from pay_element_entries_f peef,
328: pay_element_entry_values_f peevf,
329: pay_input_values_f pivf,
330: pay_element_types_f petf,
331: pay_element_links_f pelf
332: where peef.assignment_id = p_assignment_id
333: and peef.creator_type = 'UT'

Line 359: PAY_INPUT_VALUES_F pivf

355: select petf.element_type_id,
356: pivf.input_value_id,
357: pivf.name
358: from PAY_ELEMENT_TYPES_F petf,
359: PAY_INPUT_VALUES_F pivf
360: where petf.element_name = 'VERTEX'
361: and p_effective_date between petf.effective_start_date
362: and petf.effective_end_date
363: and petf.element_type_id = pivf.element_type_id

Line 517: l_input_value_id pay_input_values_f.input_value_id%TYPE := null;

513: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
514: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
515: l_assignment_id per_assignments_f.assignment_id%TYPE := null;
516: l_effective_date per_assignments_f.effective_start_date%TYPE := null;
517: l_input_value_id pay_input_values_f.input_value_id%TYPE := null;
518: l_input_name pay_input_values_f.name%TYPE := null;
519: l_element_link_id pay_element_links_f.element_link_id%TYPE := null;
520: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE := null;
521: l_io boolean;

Line 518: l_input_name pay_input_values_f.name%TYPE := null;

514: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
515: l_assignment_id per_assignments_f.assignment_id%TYPE := null;
516: l_effective_date per_assignments_f.effective_start_date%TYPE := null;
517: l_input_value_id pay_input_values_f.input_value_id%TYPE := null;
518: l_input_name pay_input_values_f.name%TYPE := null;
519: l_element_link_id pay_element_links_f.element_link_id%TYPE := null;
520: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE := null;
521: l_io boolean;
522: l_modified_correction boolean := FALSE;

Line 2057: PAY_INPUT_VALUES_F piv

2053: select pet.element_type_id,
2054: piv.input_value_id,
2055: piv.name
2056: from PAY_ELEMENT_TYPES_F pet,
2057: PAY_INPUT_VALUES_F piv
2058: where pet.element_name = lc_workers_comp
2059: and l_get_old_value_date between pet.effective_start_date
2060: and pet.effective_end_date
2061: and pet.element_type_id = piv.element_type_id