APPS.PAY_IN_FORM_24Q_WEB_ADI dependencies on PAY_INPUT_VALUES_F

Line 89: ,pay_input_values_f inputs

85: CURSOR c_entry_value
86: IS
87: SELECT val.screen_entry_value
88: FROM pay_element_entry_values_f val
89: ,pay_input_values_f inputs
90: WHERE val.input_value_id = inputs.input_value_id
91: AND val.element_entry_id = p_element_entry_id
92: AND inputs.name = p_input_name
93: AND inputs.legislation_code = 'IN'

Line 878: , pay_input_values_f inputs

874: IS
875: SELECT inputs.name name
876: , inputs.input_value_id id
877: FROM pay_element_types_f types
878: , pay_input_values_f inputs
879: WHERE types.element_type_id = p_element_type_id
880: AND inputs.element_type_id = types.element_type_id
881: AND inputs.legislation_code = 'IN'
882: AND p_effective_date BETWEEN types.effective_start_date AND types.effective_end_date

Line 917: (input_name pay_input_values_f.name%TYPE

913: AND p_effective_date BETWEEN entry.effective_start_date AND entry.effective_end_date;
914:
915: --Variables Initialization
916: TYPE t_input_values_rec IS RECORD
917: (input_name pay_input_values_f.name%TYPE
918: ,input_value_id pay_input_values_f.input_value_id%TYPE
919: );
920: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;
921:

Line 918: ,input_value_id pay_input_values_f.input_value_id%TYPE

914:
915: --Variables Initialization
916: TYPE t_input_values_rec IS RECORD
917: (input_name pay_input_values_f.name%TYPE
918: ,input_value_id pay_input_values_f.input_value_id%TYPE
919: );
920: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;
921:
922: l_assignment_id NUMBER;