DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on BEN_BENFTS_GRP

Line 804: from ben_benfts_grp bbg

800: l_benefit_group_id number;
801: begin
802: select bbg.benfts_grp_id
803: into l_benefit_group_id
804: from ben_benfts_grp bbg
805: where bbg.name = p_benefit_group
806: and bbg.business_group_id + 0 = p_business_group_id;
807: return(l_benefit_group_id);
808: exception

Line 1682: from ben_benfts_grp bng

1678: l_benefit_group_id number;
1679: begin
1680: select bng.benfts_grp_id
1681: into l_benefit_group_id
1682: from ben_benfts_grp bng
1683: where bng.name = p_benefits_group
1684: and bng.business_group_id + 0 = p_business_group_id;
1685: return(l_benefit_group_id);
1686: exception

Line 1701: from ben_benfts_grp bng

1697: l_ovn number;
1698: begin
1699: select bng.object_version_number
1700: into l_ovn
1701: from ben_benfts_grp bng
1702: where bng.name = p_benefits_group
1703: and bng.business_group_id + 0 = p_business_group_id;
1704: return(l_ovn);
1705: exception