APPS.PAY_US_TAX_INTERNAL dependencies on PAY_ELEMENT_LINKS_F

Line 331: pay_element_links_f pelf

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'
334: and petf.element_name = 'VERTEX'
335: and peevf.screen_entry_value like p_subordinate_jurisdiction||'%'

Line 468: pay_element_links_f pelf, pay_element_types_f petf

464: p_effective_date date
465: ) is
466: select peef.element_entry_id
467: from pay_element_entries_f peef, pay_element_entry_values_f peevf,
468: pay_element_links_f pelf, pay_element_types_f petf
469: where peef.assignment_id= p_assignment_id
470: and petf.element_name='VERTEX'
471: and peevf.screen_entry_value = p_jurisdiction
472: and p_effective_date between peef.effective_start_date

Line 519: l_element_link_id pay_element_links_f.element_link_id%TYPE := null;

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;
523: l_validate boolean;

Line 2100: ,pay_element_links_f pelf

2096: ) is
2097: select peef.element_entry_id
2098: from pay_element_entries_f peef
2099: ,pay_element_entry_values_f peevf
2100: ,pay_element_links_f pelf
2101: ,pay_element_types_f petf
2102: where peef.assignment_id= l_csr_assignment_id
2103: and petf.element_name = lc_workers_comp
2104: and l_csr_effective_date < peef.effective_end_date