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 519: l_input_value_id pay_input_values_f.input_value_id%TYPE := null;

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

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

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

Line 2059: PAY_INPUT_VALUES_F piv

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