APPS.BEN_ELIG_CVRD_DPNT_API dependencies on BEN_PRTT_ENRT_ACTN_F

Line 513: ben_prtt_enrt_actn_f bpe

509: cursor dpnt_ctfn_c(x_datetrack_mode varchar2) is
510: select bcc.cvrd_dpnt_ctfn_prvdd_id,
511: bcc.object_version_number
512: from ben_cvrd_dpnt_ctfn_prvdd_f bcc ,
513: ben_prtt_enrt_actn_f bpe
514: where bcc.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
515: and bcc.business_group_id = p_business_group_id
516: and bcc.prtt_enrt_actn_id = bpe.prtt_enrt_actn_id
517: and bpe.per_in_ler_id = p_per_in_ler_id

Line 1296: from ben_prtt_enrt_actn_f pea,

1292: pea.effective_start_date,
1293: pea.effective_end_date,
1294: pea.object_version_number,
1295: pen.object_version_number rslt_object_version_number
1296: from ben_prtt_enrt_actn_f pea,
1297: ben_prtt_enrt_rslt_f pen
1298: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1299: and pea.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1300: and pen.prtt_enrt_rslt_stat_cd is null

Line 1408: from ben_prtt_enrt_actn_f

1404: l_previous_values dpnt_info_c%rowtype;
1405: --
1406: cursor parent_c(cp_prtt_enrt_actn_id number,cp_effective_date date) is
1407: select effective_end_date
1408: from ben_prtt_enrt_actn_f
1409: where prtt_enrt_actn_id = cp_prtt_enrt_actn_id
1410: and business_group_id + 0 = p_business_group_id
1411: and cp_effective_date between effective_start_date and effective_end_date
1412:

Line 1454: FROM ben_prtt_enrt_actn_f pea

1450: CURSOR c_dpnt_pcp_actn_item
1451: IS
1452: SELECT pea.object_version_number, pea.prtt_enrt_actn_id,
1453: pea.prtt_enrt_rslt_id, pea.effective_end_date -- 5096675
1454: FROM ben_prtt_enrt_actn_f pea
1455: WHERE pea.business_group_id = p_business_group_id
1456: AND p_effective_date BETWEEN pea.effective_start_date
1457: AND pea.effective_end_date
1458: AND pea.actn_typ_id = l_dpnt_pcp_actn_typ_id

Line 1827: from ben_prtt_enrt_actn_f

1823: l_previous_values dpnt_info_c%rowtype;
1824: --
1825: cursor parent_c(cp_prtt_enrt_actn_id number,cp_effective_date date) is
1826: select effective_end_date
1827: from ben_prtt_enrt_actn_f
1828: where prtt_enrt_actn_id = cp_prtt_enrt_actn_id
1829: and business_group_id + 0 = p_business_group_id
1830: and cp_effective_date between effective_start_date and effective_end_date
1831:

Line 1873: FROM ben_prtt_enrt_actn_f pea

1869: CURSOR c_dpnt_pcp_actn_item
1870: IS
1871: SELECT pea.object_version_number, pea.prtt_enrt_actn_id,
1872: pea.prtt_enrt_rslt_id, pea.effective_end_date -- 5096675
1873: FROM ben_prtt_enrt_actn_f pea
1874: WHERE pea.business_group_id = p_business_group_id
1875: AND p_effective_date BETWEEN pea.effective_start_date
1876: AND pea.effective_end_date
1877: AND pea.actn_typ_id = l_dpnt_pcp_actn_typ_id