APPS.GHR_GENERAL dependencies on BEN_PTIP_F

Line 176: l_ptip_id ben_ptip_f.ptip_id%type;

172: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
173: l_plip_id ben_plip_f.plip_id%type;
174: l_oipl_id ben_oipl_f.oipl_id%type;
175: l_ler_id ben_ler_f.ler_id%type;
176: l_ptip_id ben_ptip_f.ptip_id%type;
177: l_exists boolean;
178: l_ptnl_ler_for_per_id number;
179: l_ovn number;
180: l_errbuf varchar2(2000);

Line 247: from ben_ptip_f

243:
244: -- Cursor to get the Ptip_id for the given Pgm and Plan Type.
245: Cursor get_ptip_id is
246: select ptip_id
247: from ben_ptip_f
248: where pl_typ_id = l_pl_typ_id
249: and pgm_id = l_pgm_id
250: and p_effective_date between effective_start_date and effective_end_date;
251:

Line 709: l_ptip_id ben_ptip_f.ptip_id%type;

705: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
706: l_plip_id ben_plip_f.plip_id%type;
707: l_oipl_id ben_oipl_f.oipl_id%type;
708: l_ler_id ben_ler_f.ler_id%type;
709: l_ptip_id ben_ptip_f.ptip_id%type;
710: l_assignment_id per_all_assignments_f.assignment_id%type;
711: l_exists boolean;
712: l_ovn number;
713: l_errbuf varchar2(2000);

Line 763: from ben_ptip_f

759:
760: -- Cursor to get the Ptip_id for the given Pgm and Plan Type.
761: Cursor c_get_ptip_id is
762: select ptip_id
763: from ben_ptip_f
764: where pl_typ_id = l_pl_typ_id
765: and pgm_id = l_pgm_id;
766:
767: -- Cursor to get the Plan Id

Line 1066: l_ptip_id ben_ptip_f.ptip_id%type;

1062: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
1063: l_plip_id ben_plip_f.plip_id%type;
1064: l_oipl_id ben_oipl_f.oipl_id%type;
1065: l_ler_id ben_ler_f.ler_id%type;
1066: l_ptip_id ben_ptip_f.ptip_id%type;
1067: l_exists boolean;
1068: l_ovn number;
1069: l_errbuf varchar2(2000);
1070: l_retcode number;

Line 1119: from ben_ptip_f

1115:
1116: -- Cursor to get the Ptip_id for the given Pgm and Plan Type.
1117: Cursor c_get_ptip_id is
1118: select ptip_id
1119: from ben_ptip_f
1120: where pl_typ_id = l_pl_typ_id
1121: and pgm_id = l_pgm_id;
1122:
1123: -- Cursor to get the Plan Id