APPS.BEN_ELIG_DPNT_API dependencies on BEN_CRT_ORDR

Line 2068: FROM ben_crt_ordr crt,

2064: AND pln.pl_typ_id = typ.pl_typ_id
2065: AND p_effective_date between typ.effective_start_date
2066: and typ.effective_end_date
2067: AND EXISTS(SELECT null
2068: FROM ben_crt_ordr crt,
2069: ben_per_in_ler pil
2070: WHERE crt.crt_ordr_typ_cd IN ('QMCSO','QDRO')
2071: AND crt.person_id = pen.person_id
2072: AND (crt.pl_id = pln.pl_id or crt.pl_typ_id = typ.pl_typ_id)

Line 2637: FROM ben_crt_ordr crt

2633: l_crt_ordr_meaning out nocopy varchar2)
2634: IS
2635: cursor get_crt_ordr_typ
2636: is SELECT crt.CRT_ORDR_TYP_CD
2637: FROM ben_crt_ordr crt
2638: WHERE crt.crt_ordr_typ_cd IN ('QMCSO','QDRO')
2639: AND crt.person_id = p_person_id
2640: AND crt.pl_id = p_pl_id or crt.pl_typ_id = p_pl_typ_id;
2641:

Line 2648: (p_lookup_type => 'BEN_CRT_ORDR_TYP',

2644: open get_crt_ordr_typ;
2645: fetch get_crt_ordr_typ into l_crt_ordr_typ_cd;
2646: close get_crt_ordr_typ;
2647: l_crt_ordr_meaning := hr_general.decode_lookup
2648: (p_lookup_type => 'BEN_CRT_ORDR_TYP',
2649: p_lookup_code => l_crt_ordr_typ_cd
2650: );
2651: end get_crt_ordr_typ;
2652: --