APPS.PQP_GB_OSP_TEMPLATE dependencies on BEN_LER_PER_INFO_CS_LER_F

Line 437: INSERT INTO ben_ler_per_info_cs_ler_f

433: IF g_debug THEN
434: debug(l_proc_name,l_proc_step);
435: END IF;
436:
437: INSERT INTO ben_ler_per_info_cs_ler_f
438: (ler_per_info_cs_ler_id -- NOT NULL NUMBER(15)
439: ,effective_start_date -- NOT NULL DATE
440: ,effective_end_date -- NOT NULL DATE
441: ,business_group_id -- NOT NULL NUMBER(15)

Line 446: SELECT ben_ler_per_info_cs_ler_f_s.NEXTVAL

442: ,ler_id -- NOT NULL NUMBER(15)
443: ,per_info_chg_cs_ler_id -- NOT NULL NUMBER(15)
444: ,object_version_number -- NUMBER(9)
445: )
446: SELECT ben_ler_per_info_cs_ler_f_s.NEXTVAL
447: ,p_effective_date
448: ,ler.effective_end_date
449: ,p_business_group_id
450: ,ler.ler_id

Line 465: FROM ben_ler_per_info_cs_ler_f pchg

461: AND p_effective_date BETWEEN pcd.effective_start_date
462: AND pcd.effective_end_date
463: AND NOT EXISTS -- do not insert if there a person change allready for this ler
464: (SELECT 1
465: FROM ben_ler_per_info_cs_ler_f pchg
466: WHERE pchg.ler_id = ler.ler_id -- no need to check effectiveness
467: );
468:
469: debug_exit(l_proc_name);