DBA Data[Home] [Help]

APPS.BEN_PRV_CTFN_PRVDD_API dependencies on BEN_PRTT_RT_VAL

Line 62: l_prtt_rt_val_ctfn_prvdd_id ben_prtt_rt_val_ctfn_prvdd.prtt_rt_val_ctfn_prvdd_id%TYPE;

58: ) is
59: --
60: -- Declare cursors and local variables
61: --
62: l_prtt_rt_val_ctfn_prvdd_id ben_prtt_rt_val_ctfn_prvdd.prtt_rt_val_ctfn_prvdd_id%TYPE;
63: l_proc varchar2(72) := g_package||'create_prv_ctfn_prvdd';
64: l_object_version_number ben_prtt_rt_val_ctfn_prvdd.object_version_number%TYPE;
65: --
66: begin

Line 64: l_object_version_number ben_prtt_rt_val_ctfn_prvdd.object_version_number%TYPE;

60: -- Declare cursors and local variables
61: --
62: l_prtt_rt_val_ctfn_prvdd_id ben_prtt_rt_val_ctfn_prvdd.prtt_rt_val_ctfn_prvdd_id%TYPE;
63: l_proc varchar2(72) := g_package||'create_prv_ctfn_prvdd';
64: l_object_version_number ben_prtt_rt_val_ctfn_prvdd.object_version_number%TYPE;
65: --
66: begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 358: l_object_version_number ben_prtt_rt_val_ctfn_prvdd.object_version_number%TYPE;

354: --
355: -- Declare cursors and local variables
356: --
357: l_proc varchar2(72) := g_package||'update_prv_ctfn_prvdd';
358: l_object_version_number ben_prtt_rt_val_ctfn_prvdd.object_version_number%TYPE;
359: --
360: cursor c_prv is
361: select prv.*, pil.person_id, abr.input_value_id, abr.element_type_id
362: from ben_prtt_rt_val prv,

Line 362: from ben_prtt_rt_val prv,

358: l_object_version_number ben_prtt_rt_val_ctfn_prvdd.object_version_number%TYPE;
359: --
360: cursor c_prv is
361: select prv.*, pil.person_id, abr.input_value_id, abr.element_type_id
362: from ben_prtt_rt_val prv,
363: ben_per_in_ler pil,
364: ben_acty_base_rt_f abr
365: where prv.prtt_rt_val_id = p_prtt_rt_val_id
366: and prv.business_group_id = p_business_group_id

Line 674: l_object_version_number ben_prtt_rt_val_ctfn_prvdd.object_version_number%TYPE;

670: --
671: -- Declare cursors and local variables
672: --
673: l_proc varchar2(72) := g_package||'delete_prv_ctfn_prvdd';
674: l_object_version_number ben_prtt_rt_val_ctfn_prvdd.object_version_number%TYPE;
675: --
676: l_prtt_rt_val_id number(15);
677: l_rslt_object_version_number number(15);
678: l_business_group_id number(15);