APPS.PAY_LINK_INPUT_VALUES_PKG dependencies on PAY_INPUT_VALUES_F

Line 144: from pay_input_values_f

140: -- This selects all input values for an element type
141: --
142: cursor csr_input_value is
143: select *
144: from pay_input_values_f
145: where element_type_id = p_element_type_id
146: and effective_start_date <= p_effective_end_date
147: and effective_end_date >= p_effective_start_date
148: order by input_value_id,effective_start_date;

Line 381: from pay_input_values_f TYPE,

377: p_session_date date) is
378: --
379: cursor csr_defaults is
380: select 1
381: from pay_input_values_f TYPE,
382: pay_link_input_values_f LINK
383: where p_session_date between type.effective_start_date
384: and type.effective_end_date
385: and p_session_date between link.effective_start_date

Line 429: from pay_input_values_f

425: p_error_if_true boolean default FALSE ) return boolean is
426: --
427: cursor csr_link is
428: select 1
429: from pay_input_values_f
430: where input_value_id = p_input_value_id
431: and effective_start_date <=p_effective_end_date
432: and effective_end_date >=p_effective_start_date
433: and default_value is null;

Line 480: 'PAY_INPUT_VALUES_F',input_value_id,

476: cursor csr_rows_owned_by_parent is
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');