DBA Data[Home] [Help]

APPS.PQP_GB_PSI_SCH dependencies on PQP_CONFIGURATION_VALUES

Line 303: l_pension_category pqp_configuration_values.pcv_information1%TYPE;

299: AND p_effective_date BETWEEN pel.effective_start_date AND pel.effective_end_date
300: ORDER BY pee.effective_start_date DESC;
301: l_proc_name VARCHAR2(80) := g_proc_name || 'get_pen_scheme_memb';
302: l_proc_step PLS_INTEGER;
303: l_pension_category pqp_configuration_values.pcv_information1%TYPE;
304: l_rec_ele_ent_details r_ele_ent_details;
305: l_element_type_id NUMBER;
306: i NUMBER;
307: l_eff_start_date DATE := TO_DATE('01-01-0001', 'DD-MM-YYYY');