APPS.PQH_GSP_DEL_GRADE_LADDER_OBJ dependencies on BEN_PRTN_ELIG_F

Line 328: From Ben_prtn_elig_f

324: Cursor csr_ben_epa (p_prtn_elig_id in Number) Is
325: Select prtn_elig_id,
326: Effective_Start_Date, Effective_End_Date,
327: Object_version_number
328: From Ben_prtn_elig_f
329: Where prtn_elig_id = p_prtn_elig_id
330: and p_effective_date
331: between Effective_Start_Date and Effective_End_Date;
332:

Line 344: l_epa_start_date Ben_prtn_elig_f.effective_start_date%type;

340: l_cep_end_date Ben_prtn_elig_prfl_f.effective_end_date%type;
341: l_cep_id Ben_prtn_elig_prfl_f.prtn_elig_prfl_id%type;
342: l_cep_ovn Ben_prtn_elig_prfl_f.object_version_number%type;
343: --
344: l_epa_start_date Ben_prtn_elig_f.effective_start_date%type;
345: l_epa_end_date Ben_prtn_elig_f.effective_end_date%type;
346: l_epa_id Ben_prtn_elig_f.prtn_elig_id%type;
347: l_epa_ovn Ben_prtn_elig_f.object_version_number%type;
348: --

Line 345: l_epa_end_date Ben_prtn_elig_f.effective_end_date%type;

341: l_cep_id Ben_prtn_elig_prfl_f.prtn_elig_prfl_id%type;
342: l_cep_ovn Ben_prtn_elig_prfl_f.object_version_number%type;
343: --
344: l_epa_start_date Ben_prtn_elig_f.effective_start_date%type;
345: l_epa_end_date Ben_prtn_elig_f.effective_end_date%type;
346: l_epa_id Ben_prtn_elig_f.prtn_elig_id%type;
347: l_epa_ovn Ben_prtn_elig_f.object_version_number%type;
348: --
349: l_eot date;

Line 346: l_epa_id Ben_prtn_elig_f.prtn_elig_id%type;

342: l_cep_ovn Ben_prtn_elig_prfl_f.object_version_number%type;
343: --
344: l_epa_start_date Ben_prtn_elig_f.effective_start_date%type;
345: l_epa_end_date Ben_prtn_elig_f.effective_end_date%type;
346: l_epa_id Ben_prtn_elig_f.prtn_elig_id%type;
347: l_epa_ovn Ben_prtn_elig_f.object_version_number%type;
348: --
349: l_eot date;
350: l_datetrack_mode varchar2(30);

Line 347: l_epa_ovn Ben_prtn_elig_f.object_version_number%type;

343: --
344: l_epa_start_date Ben_prtn_elig_f.effective_start_date%type;
345: l_epa_end_date Ben_prtn_elig_f.effective_end_date%type;
346: l_epa_id Ben_prtn_elig_f.prtn_elig_id%type;
347: l_epa_ovn Ben_prtn_elig_f.object_version_number%type;
348: --
349: l_eot date;
350: l_datetrack_mode varchar2(30);
351: l_Effective_Date Date;