APPS.PQH_GSP_DEL_GRADE_LADDER_OBJ dependencies on BEN_PLIP_F

Line 33: From Ben_plip_F

29: Cursor csr_ben_plip (p_plip_id in Number) Is
30: Select plip_Id,
31: Effective_Start_Date, Effective_End_Date,
32: Object_version_number
33: From Ben_plip_F
34: Where plip_id = p_plip_id
35: and p_effective_date
36: between Effective_Start_Date and Effective_End_Date;
37: --

Line 38: l_plip_start_date ben_plip_f.effective_start_date%type;

34: Where plip_id = p_plip_id
35: and p_effective_date
36: between Effective_Start_Date and Effective_End_Date;
37: --
38: l_plip_start_date ben_plip_f.effective_start_date%type;
39: l_plip_end_date ben_plip_f.effective_end_date%type;
40: l_plip_id ben_plip_f.plip_id%type;
41: l_plip_ovn ben_plip_f.object_version_number%type;
42: --

Line 39: l_plip_end_date ben_plip_f.effective_end_date%type;

35: and p_effective_date
36: between Effective_Start_Date and Effective_End_Date;
37: --
38: l_plip_start_date ben_plip_f.effective_start_date%type;
39: l_plip_end_date ben_plip_f.effective_end_date%type;
40: l_plip_id ben_plip_f.plip_id%type;
41: l_plip_ovn ben_plip_f.object_version_number%type;
42: --
43: l_eot date;

Line 40: l_plip_id ben_plip_f.plip_id%type;

36: between Effective_Start_Date and Effective_End_Date;
37: --
38: l_plip_start_date ben_plip_f.effective_start_date%type;
39: l_plip_end_date ben_plip_f.effective_end_date%type;
40: l_plip_id ben_plip_f.plip_id%type;
41: l_plip_ovn ben_plip_f.object_version_number%type;
42: --
43: l_eot date;
44: l_datetrack_mode varchar2(30);

Line 41: l_plip_ovn ben_plip_f.object_version_number%type;

37: --
38: l_plip_start_date ben_plip_f.effective_start_date%type;
39: l_plip_end_date ben_plip_f.effective_end_date%type;
40: l_plip_id ben_plip_f.plip_id%type;
41: l_plip_ovn ben_plip_f.object_version_number%type;
42: --
43: l_eot date;
44: l_datetrack_mode varchar2(30);
45: --