APPS.PQH_GSP_DEL_GRADE_LADDER_OBJ dependencies on BEN_OPT_F

Line 497: From Ben_opt_F

493: Cursor csr_ben_opt (p_opt_id in Number) Is
494: Select opt_id,
495: Effective_Start_Date , Effective_End_Date,
496: Object_version_number
497: From Ben_opt_F
498: Where opt_id = p_opt_id
499: and p_effective_date
500: between Effective_Start_Date and Effective_End_Date
501: and Mapping_table_name = 'PER_SPINAL_POINTS';

Line 518: l_opt_start_date ben_opt_f.effective_start_date%type;

514: From Ben_Oipl_F
515: Where Opt_id = p_Opt_id;
516:
517: --
518: l_opt_start_date ben_opt_f.effective_start_date%type;
519: l_opt_end_date ben_opt_f.effective_end_date%type;
520: l_opt_id ben_opt_f.opt_id%type;
521: l_opt_ovn ben_opt_f.object_version_number%type;
522: l_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;

Line 519: l_opt_end_date ben_opt_f.effective_end_date%type;

515: Where Opt_id = p_Opt_id;
516:
517: --
518: l_opt_start_date ben_opt_f.effective_start_date%type;
519: l_opt_end_date ben_opt_f.effective_end_date%type;
520: l_opt_id ben_opt_f.opt_id%type;
521: l_opt_ovn ben_opt_f.object_version_number%type;
522: l_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
523:

Line 520: l_opt_id ben_opt_f.opt_id%type;

516:
517: --
518: l_opt_start_date ben_opt_f.effective_start_date%type;
519: l_opt_end_date ben_opt_f.effective_end_date%type;
520: l_opt_id ben_opt_f.opt_id%type;
521: l_opt_ovn ben_opt_f.object_version_number%type;
522: l_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
523:
524: --

Line 521: l_opt_ovn ben_opt_f.object_version_number%type;

517: --
518: l_opt_start_date ben_opt_f.effective_start_date%type;
519: l_opt_end_date ben_opt_f.effective_end_date%type;
520: l_opt_id ben_opt_f.opt_id%type;
521: l_opt_ovn ben_opt_f.object_version_number%type;
522: l_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
523:
524: --
525: --