eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_PERSON dependencies on BEN_PER_CM_PRVDD_F

Line 728: g_cm_address_id ben_per_cm_prvdd_f.address_id%type;

724: g_cm_per_in_ler_id ben_per_cm_f.per_in_ler_id%TYPE;
725: g_cm_prtt_enrt_actn_id ben_per_cm_f.prtt_enrt_actn_id%TYPE;
726: g_cm_trgr_proc_name ben_cm_trgr.proc_cd%type;
727: g_cm_trgr_proc_dt ben_per_cm_trgr_f.effective_start_date%type;
728: g_cm_address_id ben_per_cm_prvdd_f.address_id%type;
729: g_cm_addr_line1 per_addresses.address_line1%type;
730: g_cm_addr_line2 per_addresses.address_line2%type;
731: g_cm_addr_line3 per_addresses.address_line3%type;
732: g_cm_city per_addresses.town_or_city%type;

Line 738: g_cm_dlvry_instn_txt ben_per_cm_prvdd_f.dlvry_instn_txt%type;

734: g_cm_postal_code per_addresses.postal_code%TYPE;
735: g_cm_country per_addresses.country%type;
736: g_cm_county per_addresses.region_1%type;
737: g_cm_region_3 per_addresses.region_3%type;
738: g_cm_dlvry_instn_txt ben_per_cm_prvdd_f.dlvry_instn_txt%type;
739: g_cm_inspn_rqd_flag ben_per_cm_prvdd_f.inspn_rqd_flag%type;
740: g_cm_to_be_sent_dt ben_per_cm_prvdd_f.to_be_sent_dt%type;
741: g_cm_prvdd_eff_dt ben_per_cm_prvdd_f.effective_start_date%type;
742: g_cm_sent_dt ben_per_cm_prvdd_f.sent_dt%type;

Line 739: g_cm_inspn_rqd_flag ben_per_cm_prvdd_f.inspn_rqd_flag%type;

735: g_cm_country per_addresses.country%type;
736: g_cm_county per_addresses.region_1%type;
737: g_cm_region_3 per_addresses.region_3%type;
738: g_cm_dlvry_instn_txt ben_per_cm_prvdd_f.dlvry_instn_txt%type;
739: g_cm_inspn_rqd_flag ben_per_cm_prvdd_f.inspn_rqd_flag%type;
740: g_cm_to_be_sent_dt ben_per_cm_prvdd_f.to_be_sent_dt%type;
741: g_cm_prvdd_eff_dt ben_per_cm_prvdd_f.effective_start_date%type;
742: g_cm_sent_dt ben_per_cm_prvdd_f.sent_dt%type;
743: g_cm_last_update_date ben_per_cm_f.last_update_date%TYPE;

Line 740: g_cm_to_be_sent_dt ben_per_cm_prvdd_f.to_be_sent_dt%type;

736: g_cm_county per_addresses.region_1%type;
737: g_cm_region_3 per_addresses.region_3%type;
738: g_cm_dlvry_instn_txt ben_per_cm_prvdd_f.dlvry_instn_txt%type;
739: g_cm_inspn_rqd_flag ben_per_cm_prvdd_f.inspn_rqd_flag%type;
740: g_cm_to_be_sent_dt ben_per_cm_prvdd_f.to_be_sent_dt%type;
741: g_cm_prvdd_eff_dt ben_per_cm_prvdd_f.effective_start_date%type;
742: g_cm_sent_dt ben_per_cm_prvdd_f.sent_dt%type;
743: g_cm_last_update_date ben_per_cm_f.last_update_date%TYPE;
744: g_cm_pvdd_last_update_date ben_per_cm_prvdd_f.last_update_date%type;

Line 741: g_cm_prvdd_eff_dt ben_per_cm_prvdd_f.effective_start_date%type;

737: g_cm_region_3 per_addresses.region_3%type;
738: g_cm_dlvry_instn_txt ben_per_cm_prvdd_f.dlvry_instn_txt%type;
739: g_cm_inspn_rqd_flag ben_per_cm_prvdd_f.inspn_rqd_flag%type;
740: g_cm_to_be_sent_dt ben_per_cm_prvdd_f.to_be_sent_dt%type;
741: g_cm_prvdd_eff_dt ben_per_cm_prvdd_f.effective_start_date%type;
742: g_cm_sent_dt ben_per_cm_prvdd_f.sent_dt%type;
743: g_cm_last_update_date ben_per_cm_f.last_update_date%TYPE;
744: g_cm_pvdd_last_update_date ben_per_cm_prvdd_f.last_update_date%type;
745: g_cm_address_date per_addresses.date_from%type;

Line 742: g_cm_sent_dt ben_per_cm_prvdd_f.sent_dt%type;

738: g_cm_dlvry_instn_txt ben_per_cm_prvdd_f.dlvry_instn_txt%type;
739: g_cm_inspn_rqd_flag ben_per_cm_prvdd_f.inspn_rqd_flag%type;
740: g_cm_to_be_sent_dt ben_per_cm_prvdd_f.to_be_sent_dt%type;
741: g_cm_prvdd_eff_dt ben_per_cm_prvdd_f.effective_start_date%type;
742: g_cm_sent_dt ben_per_cm_prvdd_f.sent_dt%type;
743: g_cm_last_update_date ben_per_cm_f.last_update_date%TYPE;
744: g_cm_pvdd_last_update_date ben_per_cm_prvdd_f.last_update_date%type;
745: g_cm_address_date per_addresses.date_from%type;
746: --

Line 744: g_cm_pvdd_last_update_date ben_per_cm_prvdd_f.last_update_date%type;

740: g_cm_to_be_sent_dt ben_per_cm_prvdd_f.to_be_sent_dt%type;
741: g_cm_prvdd_eff_dt ben_per_cm_prvdd_f.effective_start_date%type;
742: g_cm_sent_dt ben_per_cm_prvdd_f.sent_dt%type;
743: g_cm_last_update_date ben_per_cm_f.last_update_date%TYPE;
744: g_cm_pvdd_last_update_date ben_per_cm_prvdd_f.last_update_date%type;
745: g_cm_address_date per_addresses.date_from%type;
746: --
747: g_ppr_name ben_prmry_care_prvdr_f.name%type;
748: g_ppr_ident ben_prmry_care_prvdr_f.ext_ident%type;

Line 1052: -- for updating sent_dt in ben_per_cm_prvdd_f

1048: --
1049: g_prmy_sort_val varchar2(250);
1050: g_scnd_sort_val varchar2(250);
1051: --
1052: -- for updating sent_dt in ben_per_cm_prvdd_f
1053: g_per_cm_prvdd_id number(15);
1054: g_per_cm_object_version_number number(15);
1055: g_cm_flag varchar2(30);
1056: g_upd_cm_sent_dt_flag varchar2(30);