DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on BEN_CVG_AMT_CALC_MTHD_F

Line 1936: from ben_cvg_amt_calc_mthd_f ccm

1932: l_cvg_amt_calc_mthd_id number;
1933: begin
1934: select ccm.cvg_amt_calc_mthd_id
1935: into l_cvg_amt_calc_mthd_id
1936: from ben_cvg_amt_calc_mthd_f ccm
1937: where ccm.name = p_cvg_amt_calc
1938: and ccm.business_group_id + 0 = p_business_group_id
1939: and p_effective_date between
1940: ccm.effective_start_date and ccm.effective_end_date;

Line 1958: from ben_cvg_amt_calc_mthd_f ccm

1954: l_ovn number;
1955: begin
1956: select ccm.object_version_number
1957: into l_ovn
1958: from ben_cvg_amt_calc_mthd_f ccm
1959: where ccm.name = p_cvg_amt_calc
1960: and ccm.business_group_id + 0 = p_business_group_id
1961: and p_effective_date between
1962: ccm.effective_start_date and ccm.effective_end_date;