APPS.PQH_GSP_DEL_GRADE_LADDER_OBJ dependencies on BEN_PRTN_ELIG_PRFL_F

Line 306: From Ben_prtn_elig_prfl_f

302: Cursor csr_ben_cep (p_prtn_elig_prfl_id in Number) Is
303: Select prtn_elig_prfl_id,
304: Effective_Start_Date, Effective_End_Date,
305: Object_version_number
306: From Ben_prtn_elig_prfl_f
307: Where prtn_elig_prfl_id = p_prtn_elig_prfl_id
308: and p_effective_date
309: between Effective_Start_Date and Effective_End_Date;
310: --

Line 339: l_cep_start_date Ben_prtn_elig_prfl_f.effective_start_date%type;

335: From Ben_Copy_Entity_Results
336: Where Copy_Entity_Txn_Id = P_Copy_Entity_Txn_Id
337: and GS_MIRROR_SRC_ENTITY_RESULT_ID = P_Epa_Cer_id;
338: --
339: l_cep_start_date Ben_prtn_elig_prfl_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: --

Line 340: l_cep_end_date Ben_prtn_elig_prfl_f.effective_end_date%type;

336: Where Copy_Entity_Txn_Id = P_Copy_Entity_Txn_Id
337: and GS_MIRROR_SRC_ENTITY_RESULT_ID = P_Epa_Cer_id;
338: --
339: l_cep_start_date Ben_prtn_elig_prfl_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;

Line 341: l_cep_id Ben_prtn_elig_prfl_f.prtn_elig_prfl_id%type;

337: and GS_MIRROR_SRC_ENTITY_RESULT_ID = P_Epa_Cer_id;
338: --
339: l_cep_start_date Ben_prtn_elig_prfl_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;

Line 342: l_cep_ovn Ben_prtn_elig_prfl_f.object_version_number%type;

338: --
339: l_cep_start_date Ben_prtn_elig_prfl_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;