APPS.BEN_PBN_BUS dependencies on BEN_PER_IN_LER

Line 244: ben_per_in_ler pil

240: --
241: CURSOR c_pil is
242: SELECT pil.lf_evt_ocrd_dt
243: FROM ben_prtt_enrt_rslt_f pen,
244: ben_per_in_ler pil
245: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
246: -- AND pen.prtt_enrt_rslt_stat_cd is NULL -- bug 8901277
247: AND p_effective_date BETWEEN pen.effective_start_date
248: AND pen.effective_end_date

Line 768: ben_per_in_ler pil

764: --
765: cursor c3 is
766: select null
767: from ben_pl_bnf_f pbn,
768: ben_per_in_ler pil
769: where pbn.bnf_person_id = p_bnf_person_id
770: and pil.per_in_ler_id(+)=pbn.per_in_ler_id and
771: pil.business_group_id(+)=pbn.business_group_id
772: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 1059: from ben_per_in_ler pil

1055: and pen.prtt_enrt_rslt_stat_cd is null;
1056: --
1057: cursor c_bnf_person_self is
1058: select null
1059: from ben_per_in_ler pil
1060: where pil.per_in_ler_id = p_per_in_ler_id
1061: and pil.business_group_id = p_business_group_id
1062: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1063: or pil.per_in_ler_stat_cd is null )

Line 1071: , ben_per_in_ler pil

1067: cursor c_bnf_person_rel_typ (c_contact_type varchar2) is
1068: select pcr.contact_type,
1069: hll.meaning
1070: from per_contact_relationships pcr
1071: , ben_per_in_ler pil
1072: , hr_leg_lookups hll
1073: where pil.per_in_ler_id = p_per_in_ler_id
1074: and pil.business_group_id = p_business_group_id
1075: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 1364: , ben_per_in_ler pil

1360: --
1361: cursor c_opt_dsgn_rqmt is
1362: select null
1363: from per_contact_relationships pcr
1364: , ben_per_in_ler pil
1365: where pil.per_in_ler_id = p_per_in_ler_id
1366: and pil.business_group_id = p_business_group_id
1367: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1368: or pil.per_in_ler_stat_cd is null )

Line 1399: , ben_per_in_ler pil

1395: --
1396: cursor c_oipl_dsgn_rqmt is
1397: select null
1398: from per_contact_relationships pcr
1399: , ben_per_in_ler pil
1400: where pil.per_in_ler_id = p_per_in_ler_id
1401: and pil.business_group_id = p_business_group_id
1402: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1403: or pil.per_in_ler_stat_cd is null )

Line 1430: , ben_per_in_ler pil

1426: --
1427: cursor c_pl_dsgn_rqmt is
1428: select null
1429: from per_contact_relationships pcr
1430: , ben_per_in_ler pil
1431: where pil.per_in_ler_id = p_per_in_ler_id
1432: and pil.business_group_id = p_business_group_id
1433: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1434: or pil.per_in_ler_stat_cd is null )

Line 1460: from ben_per_in_ler pil

1456: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id ) ;
1457: --
1458: cursor c_bnf_person_self is
1459: select null
1460: from ben_per_in_ler pil
1461: where pil.per_in_ler_id = p_per_in_ler_id
1462: and pil.business_group_id = p_business_group_id
1463: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1464: or pil.per_in_ler_stat_cd is null )

Line 1470: , ben_per_in_ler pil

1466: --
1467: cursor c_bnf_person_rel_typ is
1468: select hll.meaning
1469: from per_contact_relationships pcr
1470: , ben_per_in_ler pil
1471: , hr_leg_lookups hll
1472: where pil.per_in_ler_id = p_per_in_ler_id
1473: and pil.business_group_id = p_business_group_id
1474: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 1761: ben_per_in_ler pil

1757: --
1758: cursor c1 is
1759: select null
1760: from ben_pl_bnf_f pbn,
1761: ben_per_in_ler pil
1762: where (pbn.bnf_person_id = p_bnf_person_id
1763: or pbn.organization_id = p_organization_id)
1764: and pil.per_in_ler_id (+) = pbn.per_in_ler_id
1765: and pil.business_group_id (+) = pbn.business_group_id