APPS.HR_PUMP_GET dependencies on BEN_PL_TYP_F

Line 1721: from ben_pl_typ_f ptp

1717: l_plan_type_id number;
1718: begin
1719: select ptp.pl_typ_id
1720: into l_plan_type_id
1721: from ben_pl_typ_f ptp
1722: where ptp.name = p_plan_type
1723: and ptp.business_group_id + 0 = p_business_group_id
1724: and p_effective_date between
1725: ptp.effective_start_date and ptp.effective_end_date;

Line 1743: from ben_pl_typ_f ptp

1739: l_ovn number;
1740: begin
1741: select ptp.object_version_number
1742: into l_ovn
1743: from ben_pl_typ_f ptp
1744: where ptp.name = p_plan_type
1745: and ptp.business_group_id + 0 = p_business_group_id
1746: and p_effective_date between
1747: ptp.effective_start_date and ptp.effective_end_date;