APPS.BEN_PDP_BUS dependencies on BEN_CRT_ORDR

Line 762: from ben_crt_ordr crt,

758: l_dummy varchar2(1);
759: --
760: cursor c1 is
761: select null
762: from ben_crt_ordr crt,
763: ben_crt_ordr_cvrd_per crc
764: where crc.person_id = p_dpnt_person_id
765: and crc.business_group_id = p_business_group_id
766: and crc.crt_ordr_id = crt.crt_ordr_id;

Line 763: ben_crt_ordr_cvrd_per crc

759: --
760: cursor c1 is
761: select null
762: from ben_crt_ordr crt,
763: ben_crt_ordr_cvrd_per crc
764: where crc.person_id = p_dpnt_person_id
765: and crc.business_group_id = p_business_group_id
766: and crc.crt_ordr_id = crt.crt_ordr_id;
767: --

Line 918: FROM ben_crt_ordr crt,

914: CURSOR c_crt_ordr
915: IS
916: SELECT per.first_name || ' ' || per.last_name NAME, lkp.meaning,
917: cvr.person_id, bpl.NAME, crt.CRT_ORDR_TYP_CD
918: FROM ben_crt_ordr crt,
919: ben_crt_ordr_cvrd_per cvr,
920: per_all_people_f per,
921: per_contact_relationships con,
922: hr_lookups lkp,

Line 919: ben_crt_ordr_cvrd_per cvr,

915: IS
916: SELECT per.first_name || ' ' || per.last_name NAME, lkp.meaning,
917: cvr.person_id, bpl.NAME, crt.CRT_ORDR_TYP_CD
918: FROM ben_crt_ordr crt,
919: ben_crt_ordr_cvrd_per cvr,
920: per_all_people_f per,
921: per_contact_relationships con,
922: hr_lookups lkp,
923: ben_pl_f bpl

Line 965: FROM ben_crt_ordr crt,

961: )
962: UNION
963: SELECT per.first_name || ' ' || per.last_name NAME, lkp.meaning,
964: cvr.person_id, bpt.NAME, crt.CRT_ORDR_TYP_CD
965: FROM ben_crt_ordr crt,
966: ben_crt_ordr_cvrd_per cvr,
967: per_all_people_f per,
968: per_contact_relationships con,
969: hr_lookups lkp,

Line 966: ben_crt_ordr_cvrd_per cvr,

962: UNION
963: SELECT per.first_name || ' ' || per.last_name NAME, lkp.meaning,
964: cvr.person_id, bpt.NAME, crt.CRT_ORDR_TYP_CD
965: FROM ben_crt_ordr crt,
966: ben_crt_ordr_cvrd_per cvr,
967: per_all_people_f per,
968: per_contact_relationships con,
969: hr_lookups lkp,
970: ben_pl_typ_f bpt

Line 1223: (p_lookup_type => 'BEN_CRT_ORDR_TYP',

1219: --
1220: hr_utility.set_location('C_ELIG_DPNT Returned No Rows', 9999);
1221: --
1222: l_crt_ordr_meaning := hr_general.decode_lookup
1223: (p_lookup_type => 'BEN_CRT_ORDR_TYP',
1224: p_lookup_code => l_crt_ordr_typ_cd
1225: );
1226: --
1227: ben_warnings.load_warning

Line 1295: from ben_crt_ordr crt,

1291: where per_in_ler_id = p_per_in_ler_id;
1292: --
1293: cursor c_crt_ordr(p_lf_evt_ocrd_dt date) is
1294: select 'Y'
1295: from ben_crt_ordr crt,
1296: ben_crt_ordr_cvrd_per cvr
1297: where crt.crt_ordr_typ_cd in ('QMCSO','QDRO')
1298: and crt.person_id = p_person_id
1299: and (crt.pl_id = p_pl_id or crt.pl_typ_id = p_pl_typ_id)

Line 1296: ben_crt_ordr_cvrd_per cvr

1292: --
1293: cursor c_crt_ordr(p_lf_evt_ocrd_dt date) is
1294: select 'Y'
1295: from ben_crt_ordr crt,
1296: ben_crt_ordr_cvrd_per cvr
1297: where crt.crt_ordr_typ_cd in ('QMCSO','QDRO')
1298: and crt.person_id = p_person_id
1299: and (crt.pl_id = p_pl_id or crt.pl_typ_id = p_pl_typ_id)
1300: and crt.crt_ordr_id = cvr.crt_ordr_id