APPS.PQP_GB_OSP_TEMPLATE dependencies on BEN_EXTRA_INPUT_VALUES

Line 200: DELETE FROM ben_extra_input_values

196: END IF;
197:
198:
199: -- delete all extra inputs for this standard rate
200: DELETE FROM ben_extra_input_values
201: WHERE acty_base_rt_id = l_acty_base_rt_id;
202:
203:
204: -- 2a) remove the link of the base element from the standard rate

Line 350: INSERT INTO ben_extra_input_values

346:
347: -- 2. setting up standard rates b) insert extra inputs
348:
349: IF p_plan_class='OSP' OR p_plan_class='UNP' THEN
350: INSERT INTO ben_extra_input_values
351: (extra_input_value_id -- NOT NULL NUMBER(15)
352: ,acty_base_rt_id -- NOT NULL NUMBER(15)
353: ,input_value_id -- NOT NULL NUMBER(15)
354: ,input_text -- VARCHAR2(240)

Line 361: ben_extra_input_values_s.NEXTVAL

357: ,business_group_id -- NOT NULL NUMBER(15)
358: ,object_version_number
359: )
360: (SELECT
361: ben_extra_input_values_s.NEXTVAL
362: ,l_acty_base_rt_id
363: ,input_value_id
364: ,NULL
365: ,DECODE(UPPER(name),'ABSENCE END DATE','U','C')

Line 375: INSERT INTO ben_extra_input_values

371: AND p_effective_date BETWEEN effective_start_date AND effective_end_date
372: AND UPPER(name) in ('ABSENCE TYPE','ABSENCE END DATE','ABSENCE START DATE','PLAN ID','ABSENCE ID')
373: );
374: ELSE
375: INSERT INTO ben_extra_input_values
376: (extra_input_value_id -- NOT NULL NUMBER(15)
377: ,acty_base_rt_id -- NOT NULL NUMBER(15)
378: ,input_value_id -- NOT NULL NUMBER(15)
379: ,input_text -- VARCHAR2(240)

Line 386: ben_extra_input_values_s.NEXTVAL

382: ,business_group_id -- NOT NULL NUMBER(15)
383: ,object_version_number
384: )
385: (SELECT
386: ben_extra_input_values_s.NEXTVAL
387: ,l_acty_base_rt_id
388: ,input_value_id
389: ,NULL
390: ,DECODE(UPPER(name),'MATERNITY END DATE','U','C')