APPS.BEN_PEN_BUS dependencies on BEN_CRT_ORDR

Line 902: FROM ben_crt_ordr crt,

898: CURSOR c_crt_ordr
899: IS
900: SELECT per.first_name || ' ' || per.last_name NAME, lkp.meaning,
901: cvr.person_id, bpl.NAME, crt.crt_ordr_typ_cd
902: FROM ben_crt_ordr crt,
903: ben_crt_ordr_cvrd_per cvr,
904: per_all_people_f per,
905: per_contact_relationships con,
906: hr_lookups lkp,

Line 903: ben_crt_ordr_cvrd_per cvr,

899: IS
900: SELECT per.first_name || ' ' || per.last_name NAME, lkp.meaning,
901: cvr.person_id, bpl.NAME, crt.crt_ordr_typ_cd
902: FROM ben_crt_ordr crt,
903: ben_crt_ordr_cvrd_per cvr,
904: per_all_people_f per,
905: per_contact_relationships con,
906: hr_lookups lkp,
907: ben_pl_f bpl

Line 948: FROM ben_crt_ordr crt,

944: )
945: UNION
946: SELECT per.first_name || ' ' || per.last_name NAME, lkp.meaning,
947: cvr.person_id, bpt.NAME, crt.crt_ordr_typ_cd
948: FROM ben_crt_ordr crt,
949: ben_crt_ordr_cvrd_per cvr,
950: per_all_people_f per,
951: per_contact_relationships con,
952: hr_lookups lkp,

Line 949: ben_crt_ordr_cvrd_per cvr,

945: UNION
946: SELECT per.first_name || ' ' || per.last_name NAME, lkp.meaning,
947: cvr.person_id, bpt.NAME, crt.crt_ordr_typ_cd
948: FROM ben_crt_ordr crt,
949: ben_crt_ordr_cvrd_per cvr,
950: per_all_people_f per,
951: per_contact_relationships con,
952: hr_lookups lkp,
953: ben_pl_typ_f bpt

Line 1149: (p_lookup_type => 'BEN_CRT_ORDR_TYP',

1145: --
1146: hr_utility.set_location ('C_ELIG_DPNT Not Found', 9999);
1147: --
1148: l_crt_ordr_meaning := hr_general.decode_lookup
1149: (p_lookup_type => 'BEN_CRT_ORDR_TYP',
1150: p_lookup_code => l_crt_ordr_typ_cd
1151: );
1152: --
1153: ben_warnings.load_warning