DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on BEN_PER_CM_F

Line 710: g_per_cm_id ben_per_cm_f.per_cm_id%type;

706: g_contact_is_bnfcry_flag varchar2(30);
707:
708: -- communicaton
709: --
710: g_per_cm_id ben_per_cm_f.per_cm_id%type;
711: g_cm_eff_dt ben_per_cm_f.effective_start_date%type;
712: g_cm_type ben_cm_typ_f.name%type;
713: g_cm_type_id ben_cm_typ_f.cm_typ_id%type;
714: g_cm_short_name ben_cm_typ_f.shrt_name%type;

Line 711: g_cm_eff_dt ben_per_cm_f.effective_start_date%type;

707:
708: -- communicaton
709: --
710: g_per_cm_id ben_per_cm_f.per_cm_id%type;
711: g_cm_eff_dt ben_per_cm_f.effective_start_date%type;
712: g_cm_type ben_cm_typ_f.name%type;
713: g_cm_type_id ben_cm_typ_f.cm_typ_id%type;
714: g_cm_short_name ben_cm_typ_f.shrt_name%type;
715: g_cm_kit ben_cm_typ_f.pc_kit_cd%type;

Line 721: g_cm_per_in_ler_id ben_per_cm_f.per_in_ler_id%TYPE;

717: g_cm_lf_evt ben_ler_f.name%TYPE;
718: g_cm_lf_evt_id ben_ler_f.ler_id%TYPE;
719: g_cm_lf_evt_stat ben_per_in_ler.per_in_ler_stat_cd%TYPE;
720: g_cm_lf_evt_ntfn_dt ben_per_in_ler.ntfn_dt%TYPE;
721: g_cm_per_in_ler_id ben_per_cm_f.per_in_ler_id%TYPE;
722: g_cm_prtt_enrt_actn_id ben_per_cm_f.prtt_enrt_actn_id%TYPE;
723: g_cm_trgr_proc_name ben_cm_trgr.proc_cd%type;
724: g_cm_trgr_proc_dt ben_per_cm_trgr_f.effective_start_date%type;
725: g_cm_address_id ben_per_cm_prvdd_f.address_id%type;

Line 722: g_cm_prtt_enrt_actn_id ben_per_cm_f.prtt_enrt_actn_id%TYPE;

718: g_cm_lf_evt_id ben_ler_f.ler_id%TYPE;
719: g_cm_lf_evt_stat ben_per_in_ler.per_in_ler_stat_cd%TYPE;
720: g_cm_lf_evt_ntfn_dt ben_per_in_ler.ntfn_dt%TYPE;
721: g_cm_per_in_ler_id ben_per_cm_f.per_in_ler_id%TYPE;
722: g_cm_prtt_enrt_actn_id ben_per_cm_f.prtt_enrt_actn_id%TYPE;
723: g_cm_trgr_proc_name ben_cm_trgr.proc_cd%type;
724: g_cm_trgr_proc_dt ben_per_cm_trgr_f.effective_start_date%type;
725: g_cm_address_id ben_per_cm_prvdd_f.address_id%type;
726: g_cm_addr_line1 per_addresses.address_line1%type;

Line 740: g_cm_last_update_date ben_per_cm_f.last_update_date%TYPE;

736: g_cm_inspn_rqd_flag ben_per_cm_prvdd_f.inspn_rqd_flag%type;
737: g_cm_to_be_sent_dt ben_per_cm_prvdd_f.to_be_sent_dt%type;
738: g_cm_prvdd_eff_dt ben_per_cm_prvdd_f.effective_start_date%type;
739: g_cm_sent_dt ben_per_cm_prvdd_f.sent_dt%type;
740: g_cm_last_update_date ben_per_cm_f.last_update_date%TYPE;
741: g_cm_pvdd_last_update_date ben_per_cm_prvdd_f.last_update_date%type;
742: g_cm_address_date per_addresses.date_from%type;
743: --
744: g_ppr_name ben_prmry_care_prvdr_f.name%type;