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 249: from ben_ptip_f

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

Line 721: l_ptip_id ben_ptip_f.ptip_id%type;

717: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
718: l_plip_id ben_plip_f.plip_id%type;
719: l_oipl_id ben_oipl_f.oipl_id%type;
720: l_ler_id ben_ler_f.ler_id%type;
721: l_ptip_id ben_ptip_f.ptip_id%type;
722: l_assignment_id per_all_assignments_f.assignment_id%type;
723: l_exists boolean;
724: l_ovn number;
725: l_errbuf varchar2(2000);

Line 777: from ben_ptip_f

773:
774: -- Cursor to get the Ptip_id for the given Pgm and Plan Type.
775: Cursor c_get_ptip_id is
776: select ptip_id
777: from ben_ptip_f
778: where pl_typ_id = l_pl_typ_id
779: and pgm_id = l_pgm_id;
780:
781: -- Cursor to get the Plan Id

Line 1090: l_ptip_id ben_ptip_f.ptip_id%type;

1086: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
1087: l_plip_id ben_plip_f.plip_id%type;
1088: l_oipl_id ben_oipl_f.oipl_id%type;
1089: l_ler_id ben_ler_f.ler_id%type;
1090: l_ptip_id ben_ptip_f.ptip_id%type;
1091: l_exists boolean;
1092: l_ovn number;
1093: l_errbuf varchar2(2000);
1094: l_retcode number;

Line 1145: from ben_ptip_f

1141:
1142: -- Cursor to get the Ptip_id for the given Pgm and Plan Type.
1143: Cursor c_get_ptip_id is
1144: select ptip_id
1145: from ben_ptip_f
1146: where pl_typ_id = l_pl_typ_id
1147: and pgm_id = l_pgm_id;
1148:
1149: -- Cursor to get the Plan Id