DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_PEN_REPORTING dependencies on PAY_INPUT_VALUES_F

Line 33: (SELECT input_value_id, name from pay_input_values_f);

29: MAX(DECODE ( name , 'Opt in Date', INPUT_VALUE_ID )) opt_in_Date,
30: MAX(DECODE ( name , 'Eligible Job Holder Date', INPUT_VALUE_ID )) first_found_elig_date,
31: MAX(DECODE ( name , 'Postponement End Date', INPUT_VALUE_ID )) post_period_end_date
32: FROM
33: (SELECT input_value_id, name from pay_input_values_f);
34:
35:
36: cursor cur_input_id_value(p_input_id cur_input_id%rowtype,p_elem_entry_id pay_element_entry_values_f.element_entry_id%type,p_end_date date) is
37: select