APPS.BEN_PRTT_ENRT_CTFN_PRVDD_API dependencies on BEN_PRTT_ENRT_ACTN_F

Line 30: ben_prtt_enrt_actn_f pea

26: pea.rqd_flag,
27: pen.object_version_number rslt_ovn,
28: pea.object_version_number
29: from ben_prtt_enrt_rslt_f pen,
30: ben_prtt_enrt_actn_f pea
31: where pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
32: and pea.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
33: and pea.business_group_id = p_business_group_id
34: and pen.prtt_enrt_rslt_stat_cd is null

Line 249: from ben_per_in_ler pil1, ben_prtt_enrt_actn_f actn

245: cursor c_pil(p_PRTT_ENRT_ACTN_ID number) is
246: select pil1.lf_evt_ocrd_dt lf_evt_ocrd_dt,
247: pil1.person_id person_id,
248: pil1.business_group_id business_group_id
249: from ben_per_in_ler pil1, ben_prtt_enrt_actn_f actn
250: where pil1.per_in_ler_id = actn.per_in_ler_id
251: and actn.PRTT_ENRT_ACTN_ID = p_PRTT_ENRT_ACTN_ID
252: and p_effective_date
253: between actn.effective_start_date

Line 342: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type;

338: l_effective_start_date ben_prtt_enrt_ctfn_prvdd_f.effective_start_date%TYPE;
339: l_effective_end_date ben_prtt_enrt_ctfn_prvdd_f.effective_end_date%TYPE;
340: l_proc varchar2(72) := g_package||'create_PRTT_ENRT_CTFN_PRVDD';
341: l_object_version_number ben_prtt_enrt_ctfn_prvdd_f.object_version_number%TYPE;
342: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type;
343: --
344: begin
345: --
346: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 968: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type := null;

964: l_object_version_number ben_prtt_enrt_ctfn_prvdd_f.object_version_number%TYPE;
965: l_effective_start_date ben_prtt_enrt_ctfn_prvdd_f.effective_start_date%TYPE;
966: l_effective_end_date ben_prtt_enrt_ctfn_prvdd_f.effective_end_date%TYPE;
967: --
968: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type := null;
969: l_prtt_enrt_rslt_id number(15);
970: l_rslt_object_version_number number(15);
971: l_business_group_id number(15);
972: l_exist varchar2(1) := 'N';

Line 973: l1_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;

969: l_prtt_enrt_rslt_id number(15);
970: l_rslt_object_version_number number(15);
971: l_business_group_id number(15);
972: l_exist varchar2(1) := 'N';
973: l1_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
974: l1_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
975: l1_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
976: l_env_rec ben_env_object.g_global_env_rec_type;
977: --

Line 974: l1_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;

970: l_rslt_object_version_number number(15);
971: l_business_group_id number(15);
972: l_exist varchar2(1) := 'N';
973: l1_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
974: l1_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
975: l1_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
976: l_env_rec ben_env_object.g_global_env_rec_type;
977: --
978: cursor get_actn_c is

Line 975: l1_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;

971: l_business_group_id number(15);
972: l_exist varchar2(1) := 'N';
973: l1_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
974: l1_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
975: l1_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
976: l_env_rec ben_env_object.g_global_env_rec_type;
977: --
978: cursor get_actn_c is
979: select prtt_enrt_actn_id,

Line 997: from ben_prtt_enrt_actn_f pea,

993: cursor actn_info_c is
994: select pea.object_version_number,
995: pea.prtt_enrt_rslt_id,
996: pen.object_version_number
997: from ben_prtt_enrt_actn_f pea,
998: ben_prtt_enrt_rslt_f pen
999: where pea.prtt_enrt_actn_id = l_prtt_enrt_actn_id
1000: and pea.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1001: and pen.prtt_enrt_rslt_stat_cd is null