DBA Data[Home] [Help]

APPS.PAY_LINK_INPUT_VALUES_API dependencies on PAY_ELEMENT_LINKS_F

Line 37: l_costable_type pay_element_links_f.costable_type%type;

33: l_effective_start_date date;
34: l_effective_end_date date;
35: l_exists varchar2(1);
36: l_rec pay_input_values_f%rowtype;
37: l_costable_type pay_element_links_f.costable_type%type;
38: l_default_value pay_link_input_values_f.default_value%type;
39: l_max_value pay_link_input_values_f.max_value%type;
40: l_min_value pay_link_input_values_f.min_value%type;
41: l_warning_or_error pay_link_input_values_f.warning_or_error%type;

Line 58: from pay_element_links_f

54:
55: Cursor C_costable_type
56: is
57: select costable_type
58: from pay_element_links_f
59: where element_link_id = p_element_link_id
60: and p_effective_date between effective_start_date
61: and effective_end_date;
62: