DBA Data[Home] [Help]

APPS.PQH_GSP_HR_TO_STAGE dependencies on BEN_ELIGY_PRFL_F

Line 604: l_Elg_Ovn Ben_Eligy_Prfl_F.Object_Version_Number%TYPE;

600: l_perf_rating varchar2(240);
601: l_dml_oper varchar2(30);
602: l_eot date := to_date('31-12-4712','DD-MM-RRRR');
603: l_crs_eed date;
604: l_Elg_Ovn Ben_Eligy_Prfl_F.Object_Version_Number%TYPE;
605: begin
606: get_table_route_details(p_table_alias => 'CRSET',
607: p_table_route_id => l_crs_tr_id,
608: p_table_name => l_crs_tr_name);

Line 632: l_Elg_Ovn := Pqh_Gsp_Stage_To_Ben.Get_ovn(p_table_name => 'BEN_ELIGY_PRFL_F',

628: l_crs_eed := p_elp_eed;
629: end if;
630: Begin
631: If P_Elp_Id is NOT NULL Then
632: l_Elg_Ovn := Pqh_Gsp_Stage_To_Ben.Get_ovn(p_table_name => 'BEN_ELIGY_PRFL_F',
633: p_key_column_name => 'ELIGY_PRFL_ID',
634: p_key_column_value => p_elp_id,
635: P_effective_date => P_effective_date);
636: Else