APPS.PAY_LINK_INPUT_VALUES_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 291: from pay_element_links_f

287: p_warning_or_error varchar2) is
288: --
289: cursor csr_links is
290: select *
291: from pay_element_links_f
292: where element_type_id = p_element_type_id
293: and effective_start_date <= p_effective_end_date
294: and effective_end_date >= p_effective_start_date
295: order by element_link_id,effective_start_date;

Line 481: 'PAY_ELEMENT_LINKS_F',element_link_id)

477: select rowid,pay_link_input_values_f.*
478: from pay_link_input_values_f
479: where p_parent_id = decode (p_parent_name,
480: 'PAY_INPUT_VALUES_F',input_value_id,
481: 'PAY_ELEMENT_LINKS_F',element_link_id)
482: for update;
483: --
484: c_end_of_time constant date := to_date('31/12/4712','DD/MM/YYYY');
485: --

Line 541: from pay_element_links_f

537: v_link_end_date date;
538: --
539: cursor csr_link is
540: select max(effective_end_date)
541: from pay_element_links_f
542: where element_link_id = p_link_id;
543: --
544: begin
545: open csr_link;