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 PER_PHONES

Line 196: g_phone_home per_phones.phone_number%TYPE;

192: g_mail_county per_addresses.region_1%TYPE;
193: g_mail_region_3 per_addresses.region_3%TYPE;
194: g_mail_address_date per_addresses.date_from%TYPE;
195: --
196: g_phone_home per_phones.phone_number%TYPE;
197: g_phone_work per_phones.phone_number%TYPE;
198: g_phone_fax per_phones.phone_number%TYPE;
199: g_phone_mobile per_phones.phone_number%TYPE;
200: --

Line 197: g_phone_work per_phones.phone_number%TYPE;

193: g_mail_region_3 per_addresses.region_3%TYPE;
194: g_mail_address_date per_addresses.date_from%TYPE;
195: --
196: g_phone_home per_phones.phone_number%TYPE;
197: g_phone_work per_phones.phone_number%TYPE;
198: g_phone_fax per_phones.phone_number%TYPE;
199: g_phone_mobile per_phones.phone_number%TYPE;
200: --
201: g_last_hire_date per_periods_of_service.date_start%TYPE;

Line 198: g_phone_fax per_phones.phone_number%TYPE;

194: g_mail_address_date per_addresses.date_from%TYPE;
195: --
196: g_phone_home per_phones.phone_number%TYPE;
197: g_phone_work per_phones.phone_number%TYPE;
198: g_phone_fax per_phones.phone_number%TYPE;
199: g_phone_mobile per_phones.phone_number%TYPE;
200: --
201: g_last_hire_date per_periods_of_service.date_start%TYPE;
202: g_actual_term_date per_periods_of_service.actual_termination_date%TYPE;

Line 199: g_phone_mobile per_phones.phone_number%TYPE;

195: --
196: g_phone_home per_phones.phone_number%TYPE;
197: g_phone_work per_phones.phone_number%TYPE;
198: g_phone_fax per_phones.phone_number%TYPE;
199: g_phone_mobile per_phones.phone_number%TYPE;
200: --
201: g_last_hire_date per_periods_of_service.date_start%TYPE;
202: g_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
203: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;

Line 603: g_dpnt_home_phone per_phones.phone_number%TYPE;

599: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
600: g_dpnt_prim_country per_addresses.country%TYPE;
601: g_dpnt_prim_effect_date per_addresses.date_from%TYPE;
602: g_dpnt_prim_region per_addresses.region_3%TYPE;
603: g_dpnt_home_phone per_phones.phone_number%TYPE;
604: g_dpnt_fax per_phones.phone_number%TYPE;
605: g_dpnt_mobile per_phones.phone_number%TYPE;
606: g_dpnt_work_phone per_phones.phone_number%TYPE;
607: g_dpnt_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;

Line 604: g_dpnt_fax per_phones.phone_number%TYPE;

600: g_dpnt_prim_country per_addresses.country%TYPE;
601: g_dpnt_prim_effect_date per_addresses.date_from%TYPE;
602: g_dpnt_prim_region per_addresses.region_3%TYPE;
603: g_dpnt_home_phone per_phones.phone_number%TYPE;
604: g_dpnt_fax per_phones.phone_number%TYPE;
605: g_dpnt_mobile per_phones.phone_number%TYPE;
606: g_dpnt_work_phone per_phones.phone_number%TYPE;
607: g_dpnt_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;
608: --

Line 605: g_dpnt_mobile per_phones.phone_number%TYPE;

601: g_dpnt_prim_effect_date per_addresses.date_from%TYPE;
602: g_dpnt_prim_region per_addresses.region_3%TYPE;
603: g_dpnt_home_phone per_phones.phone_number%TYPE;
604: g_dpnt_fax per_phones.phone_number%TYPE;
605: g_dpnt_mobile per_phones.phone_number%TYPE;
606: g_dpnt_work_phone per_phones.phone_number%TYPE;
607: g_dpnt_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;
608: --
609: -- detail - eligible dependent

Line 606: g_dpnt_work_phone per_phones.phone_number%TYPE;

602: g_dpnt_prim_region per_addresses.region_3%TYPE;
603: g_dpnt_home_phone per_phones.phone_number%TYPE;
604: g_dpnt_fax per_phones.phone_number%TYPE;
605: g_dpnt_mobile per_phones.phone_number%TYPE;
606: g_dpnt_work_phone per_phones.phone_number%TYPE;
607: g_dpnt_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;
608: --
609: -- detail - eligible dependent
610: --

Line 649: g_elig_dpnt_home_phone per_phones.phone_number%TYPE;

645: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
646: g_elig_dpnt_prim_country per_addresses.country%TYPE;
647: g_elig_dpnt_prim_effect_date per_addresses.date_from%TYPE;
648: g_elig_dpnt_prim_region per_addresses.region_3%TYPE;
649: g_elig_dpnt_home_phone per_phones.phone_number%TYPE;
650: g_elig_dpnt_fax per_phones.phone_number%TYPE;
651: g_elig_dpnt_mobile per_phones.phone_number%TYPE;
652: g_elig_dpnt_work_phone per_phones.phone_number%TYPE;
653: g_elig_dpnt_id ben_elig_dpnt.elig_dpnt_id%TYPE;

Line 650: g_elig_dpnt_fax per_phones.phone_number%TYPE;

646: g_elig_dpnt_prim_country per_addresses.country%TYPE;
647: g_elig_dpnt_prim_effect_date per_addresses.date_from%TYPE;
648: g_elig_dpnt_prim_region per_addresses.region_3%TYPE;
649: g_elig_dpnt_home_phone per_phones.phone_number%TYPE;
650: g_elig_dpnt_fax per_phones.phone_number%TYPE;
651: g_elig_dpnt_mobile per_phones.phone_number%TYPE;
652: g_elig_dpnt_work_phone per_phones.phone_number%TYPE;
653: g_elig_dpnt_id ben_elig_dpnt.elig_dpnt_id%TYPE;
654: --

Line 651: g_elig_dpnt_mobile per_phones.phone_number%TYPE;

647: g_elig_dpnt_prim_effect_date per_addresses.date_from%TYPE;
648: g_elig_dpnt_prim_region per_addresses.region_3%TYPE;
649: g_elig_dpnt_home_phone per_phones.phone_number%TYPE;
650: g_elig_dpnt_fax per_phones.phone_number%TYPE;
651: g_elig_dpnt_mobile per_phones.phone_number%TYPE;
652: g_elig_dpnt_work_phone per_phones.phone_number%TYPE;
653: g_elig_dpnt_id ben_elig_dpnt.elig_dpnt_id%TYPE;
654: --
655: -- contacts

Line 652: g_elig_dpnt_work_phone per_phones.phone_number%TYPE;

648: g_elig_dpnt_prim_region per_addresses.region_3%TYPE;
649: g_elig_dpnt_home_phone per_phones.phone_number%TYPE;
650: g_elig_dpnt_fax per_phones.phone_number%TYPE;
651: g_elig_dpnt_mobile per_phones.phone_number%TYPE;
652: g_elig_dpnt_work_phone per_phones.phone_number%TYPE;
653: g_elig_dpnt_id ben_elig_dpnt.elig_dpnt_id%TYPE;
654: --
655: -- contacts
656: --

Line 687: g_contact_home_phone per_phones.phone_number%TYPE;

683: g_contact_prim_postal_code per_addresses.postal_code%TYPE;
684: g_contact_prim_country per_addresses.country%TYPE;
685: g_contact_prim_effect_date per_addresses.date_from%TYPE;
686: g_contact_prim_region per_addresses.region_3%TYPE;
687: g_contact_home_phone per_phones.phone_number%TYPE;
688: g_contact_fax per_phones.phone_number%TYPE;
689: g_contact_mobile per_phones.phone_number%TYPE;
690: g_contact_work_phone per_phones.phone_number%TYPE;
691: g_contact_rlshp_type per_contact_relationships.contact_type%TYPE;

Line 688: g_contact_fax per_phones.phone_number%TYPE;

684: g_contact_prim_country per_addresses.country%TYPE;
685: g_contact_prim_effect_date per_addresses.date_from%TYPE;
686: g_contact_prim_region per_addresses.region_3%TYPE;
687: g_contact_home_phone per_phones.phone_number%TYPE;
688: g_contact_fax per_phones.phone_number%TYPE;
689: g_contact_mobile per_phones.phone_number%TYPE;
690: g_contact_work_phone per_phones.phone_number%TYPE;
691: g_contact_rlshp_type per_contact_relationships.contact_type%TYPE;
692: g_contact_rlshp_id per_contact_relationships.contact_relationship_id%TYPE;

Line 689: g_contact_mobile per_phones.phone_number%TYPE;

685: g_contact_prim_effect_date per_addresses.date_from%TYPE;
686: g_contact_prim_region per_addresses.region_3%TYPE;
687: g_contact_home_phone per_phones.phone_number%TYPE;
688: g_contact_fax per_phones.phone_number%TYPE;
689: g_contact_mobile per_phones.phone_number%TYPE;
690: g_contact_work_phone per_phones.phone_number%TYPE;
691: g_contact_rlshp_type per_contact_relationships.contact_type%TYPE;
692: g_contact_rlshp_id per_contact_relationships.contact_relationship_id%TYPE;
693: g_contact_seq_num per_contact_relationships.sequence_number%TYPE;

Line 690: g_contact_work_phone per_phones.phone_number%TYPE;

686: g_contact_prim_region per_addresses.region_3%TYPE;
687: g_contact_home_phone per_phones.phone_number%TYPE;
688: g_contact_fax per_phones.phone_number%TYPE;
689: g_contact_mobile per_phones.phone_number%TYPE;
690: g_contact_work_phone per_phones.phone_number%TYPE;
691: g_contact_rlshp_type per_contact_relationships.contact_type%TYPE;
692: g_contact_rlshp_id per_contact_relationships.contact_relationship_id%TYPE;
693: g_contact_seq_num per_contact_relationships.sequence_number%TYPE;
694: g_contact_prmy_contact_flag per_contact_relationships.PRIMARY_CONTACT_FLAG%TYPE;

Line 1002: g_bnf_home_phone per_phones.phone_number%TYPE;

998: g_bnf_amt_uom ben_pl_bnf_f.amt_dsgd_uom%TYPE;
999: g_bnf_rlshp per_contact_relationships.contact_type%TYPE;
1000: g_bnf_contact_seq_num per_contact_relationships.sequence_number%TYPE;
1001: g_bnf_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
1002: g_bnf_home_phone per_phones.phone_number%TYPE;
1003: g_bnf_fax per_phones.phone_number%TYPE;
1004: g_bnf_mobile per_phones.phone_number%TYPE;
1005: g_bnf_work_phone per_phones.phone_number%TYPE;
1006: g_bnf_pl_bnf_id ben_pl_bnf_f.pl_bnf_id%TYPE;

Line 1003: g_bnf_fax per_phones.phone_number%TYPE;

999: g_bnf_rlshp per_contact_relationships.contact_type%TYPE;
1000: g_bnf_contact_seq_num per_contact_relationships.sequence_number%TYPE;
1001: g_bnf_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
1002: g_bnf_home_phone per_phones.phone_number%TYPE;
1003: g_bnf_fax per_phones.phone_number%TYPE;
1004: g_bnf_mobile per_phones.phone_number%TYPE;
1005: g_bnf_work_phone per_phones.phone_number%TYPE;
1006: g_bnf_pl_bnf_id ben_pl_bnf_f.pl_bnf_id%TYPE;
1007: --

Line 1004: g_bnf_mobile per_phones.phone_number%TYPE;

1000: g_bnf_contact_seq_num per_contact_relationships.sequence_number%TYPE;
1001: g_bnf_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
1002: g_bnf_home_phone per_phones.phone_number%TYPE;
1003: g_bnf_fax per_phones.phone_number%TYPE;
1004: g_bnf_mobile per_phones.phone_number%TYPE;
1005: g_bnf_work_phone per_phones.phone_number%TYPE;
1006: g_bnf_pl_bnf_id ben_pl_bnf_f.pl_bnf_id%TYPE;
1007: --
1008: --

Line 1005: g_bnf_work_phone per_phones.phone_number%TYPE;

1001: g_bnf_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
1002: g_bnf_home_phone per_phones.phone_number%TYPE;
1003: g_bnf_fax per_phones.phone_number%TYPE;
1004: g_bnf_mobile per_phones.phone_number%TYPE;
1005: g_bnf_work_phone per_phones.phone_number%TYPE;
1006: g_bnf_pl_bnf_id ben_pl_bnf_f.pl_bnf_id%TYPE;
1007: --
1008: --
1009: -- Action Items