DBA Data[Home] [Help]

APPS.HR_CAGR_ENT_LINES_API dependencies on BEN_OIPL_F

Line 153: l_order_number ben_oipl_f.ordr_num%TYPE;

149: l_proc VARCHAR2(72) := g_package||'create_entitlement_line';
150: l_object_version_number per_cagr_entitlement_lines_f.object_version_number%TYPE;
151: l_business_group_id NUMBER;
152: l_opt_id ben_opt_f.opt_id%TYPE;
153: l_order_number ben_oipl_f.ordr_num%TYPE;
154: --
155: l_pl_typ_opt_typ_id NUMBER;
156: l_pl_typ_opt_typ_ovn NUMBER;
157: l_pl_id NUMBER;

Line 705: ben_oipl_f bof,

701: bep.prtn_elig_prfl_id,
702: bep.object_version_number
703: FROM ben_prtn_elig_prfl_f bep,
704: ben_prtn_elig_f bpe,
705: ben_oipl_f bof,
706: per_cagr_entitlement_lines_f pcl
707: WHERE bep.prtn_elig_id = bpe.prtn_elig_id
708: AND bpe.oipl_id = bof.oipl_id
709: AND bof.oipl_id = pcl.oipl_id