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_CONTACT_RELATIONSHIPS

Line 576: g_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;

572: g_dpnt_full_name per_all_people_f.full_name%TYPE;
573: g_dpnt_suffix per_all_people_f.suffix%TYPE;
574: g_Dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
575: g_dpnt_title per_all_people_f.title%TYPE;
576: g_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
577: g_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
578: g_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
579: g_dpnt_sex per_all_people_f.sex%TYPE;
580: g_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;

Line 577: g_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;

573: g_dpnt_suffix per_all_people_f.suffix%TYPE;
574: g_Dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
575: g_dpnt_title per_all_people_f.title%TYPE;
576: g_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
577: g_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
578: g_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
579: g_dpnt_sex per_all_people_f.sex%TYPE;
580: g_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
581: g_dpnt_marital_status per_all_people_f.marital_status%TYPE;

Line 578: g_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;

574: g_Dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
575: g_dpnt_title per_all_people_f.title%TYPE;
576: g_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
577: g_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
578: g_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
579: g_dpnt_sex per_all_people_f.sex%TYPE;
580: g_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
581: g_dpnt_marital_status per_all_people_f.marital_status%TYPE;
582: g_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;

Line 619: g_elig_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;

615: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;
616: g_elig_dpnt_suffix per_all_people_f.suffix%TYPE;
617: g_elig_dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
618: g_elig_dpnt_title per_all_people_f.title%TYPE;
619: g_elig_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
620: g_elig_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
621: g_elig_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
622: g_elig_dpnt_sex per_all_people_f.sex%TYPE;
623: g_elig_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;

Line 620: g_elig_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;

616: g_elig_dpnt_suffix per_all_people_f.suffix%TYPE;
617: g_elig_dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
618: g_elig_dpnt_title per_all_people_f.title%TYPE;
619: g_elig_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
620: g_elig_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
621: g_elig_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
622: g_elig_dpnt_sex per_all_people_f.sex%TYPE;
623: g_elig_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
624: g_elig_dpnt_marital_status per_all_people_f.marital_status%TYPE;

Line 621: g_elig_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;

617: g_elig_dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
618: g_elig_dpnt_title per_all_people_f.title%TYPE;
619: g_elig_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
620: g_elig_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
621: g_elig_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
622: g_elig_dpnt_sex per_all_people_f.sex%TYPE;
623: g_elig_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
624: g_elig_dpnt_marital_status per_all_people_f.marital_status%TYPE;
625: g_elig_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;

Line 691: g_contact_rlshp_type per_contact_relationships.contact_type%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;
695: g_contact_shared_resd_flag per_contact_relationships.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE;

Line 692: g_contact_rlshp_id per_contact_relationships.contact_relationship_id%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;
695: g_contact_shared_resd_flag per_contact_relationships.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE;
696: g_contact_personal_flag per_contact_relationships.PERSONAL_FLAG%TYPE;

Line 693: g_contact_seq_num per_contact_relationships.sequence_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;
695: g_contact_shared_resd_flag per_contact_relationships.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE;
696: g_contact_personal_flag per_contact_relationships.PERSONAL_FLAG%TYPE;
697: g_contact_pymts_rcpnt_flag per_contact_relationships.THIRD_PARTY_PAY_FLAG%TYPE;

Line 694: g_contact_prmy_contact_flag per_contact_relationships.PRIMARY_CONTACT_FLAG%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;
695: g_contact_shared_resd_flag per_contact_relationships.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE;
696: g_contact_personal_flag per_contact_relationships.PERSONAL_FLAG%TYPE;
697: g_contact_pymts_rcpnt_flag per_contact_relationships.THIRD_PARTY_PAY_FLAG%TYPE;
698: g_contact_start_date per_contact_relationships.DATE_START%TYPE;

Line 695: g_contact_shared_resd_flag per_contact_relationships.RLTD_PER_RSDS_W_DSGNTR_FLAG%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;
695: g_contact_shared_resd_flag per_contact_relationships.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE;
696: g_contact_personal_flag per_contact_relationships.PERSONAL_FLAG%TYPE;
697: g_contact_pymts_rcpnt_flag per_contact_relationships.THIRD_PARTY_PAY_FLAG%TYPE;
698: g_contact_start_date per_contact_relationships.DATE_START%TYPE;
699: g_contact_end_date per_contact_relationships.DATE_END%TYPE;

Line 696: g_contact_personal_flag per_contact_relationships.PERSONAL_FLAG%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;
695: g_contact_shared_resd_flag per_contact_relationships.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE;
696: g_contact_personal_flag per_contact_relationships.PERSONAL_FLAG%TYPE;
697: g_contact_pymts_rcpnt_flag per_contact_relationships.THIRD_PARTY_PAY_FLAG%TYPE;
698: g_contact_start_date per_contact_relationships.DATE_START%TYPE;
699: g_contact_end_date per_contact_relationships.DATE_END%TYPE;
700: g_contact_start_life_evt ben_ler_f.name%TYPE;

Line 697: g_contact_pymts_rcpnt_flag per_contact_relationships.THIRD_PARTY_PAY_FLAG%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;
695: g_contact_shared_resd_flag per_contact_relationships.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE;
696: g_contact_personal_flag per_contact_relationships.PERSONAL_FLAG%TYPE;
697: g_contact_pymts_rcpnt_flag per_contact_relationships.THIRD_PARTY_PAY_FLAG%TYPE;
698: g_contact_start_date per_contact_relationships.DATE_START%TYPE;
699: g_contact_end_date per_contact_relationships.DATE_END%TYPE;
700: g_contact_start_life_evt ben_ler_f.name%TYPE;
701: g_contact_start_ler_id ben_ler_f.ler_id%TYPE;

Line 698: g_contact_start_date per_contact_relationships.DATE_START%TYPE;

694: g_contact_prmy_contact_flag per_contact_relationships.PRIMARY_CONTACT_FLAG%TYPE;
695: g_contact_shared_resd_flag per_contact_relationships.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE;
696: g_contact_personal_flag per_contact_relationships.PERSONAL_FLAG%TYPE;
697: g_contact_pymts_rcpnt_flag per_contact_relationships.THIRD_PARTY_PAY_FLAG%TYPE;
698: g_contact_start_date per_contact_relationships.DATE_START%TYPE;
699: g_contact_end_date per_contact_relationships.DATE_END%TYPE;
700: g_contact_start_life_evt ben_ler_f.name%TYPE;
701: g_contact_start_ler_id ben_ler_f.ler_id%TYPE;
702: g_contact_end_life_evt ben_ler_f.name%TYPE;

Line 699: g_contact_end_date per_contact_relationships.DATE_END%TYPE;

695: g_contact_shared_resd_flag per_contact_relationships.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE;
696: g_contact_personal_flag per_contact_relationships.PERSONAL_FLAG%TYPE;
697: g_contact_pymts_rcpnt_flag per_contact_relationships.THIRD_PARTY_PAY_FLAG%TYPE;
698: g_contact_start_date per_contact_relationships.DATE_START%TYPE;
699: g_contact_end_date per_contact_relationships.DATE_END%TYPE;
700: g_contact_start_life_evt ben_ler_f.name%TYPE;
701: g_contact_start_ler_id ben_ler_f.ler_id%TYPE;
702: g_contact_end_life_evt ben_ler_f.name%TYPE;
703: g_contact_end_ler_id ben_ler_f.ler_id%TYPE;

Line 999: g_bnf_rlshp per_contact_relationships.contact_type%TYPE;

995: g_bnf_prmy_cont ben_pl_bnf_f.prmry_cntngnt_cd%TYPE;
996: g_bnf_pct_dsgd ben_pl_bnf_f.pct_dsgd_num%TYPE;
997: g_bnf_amt_dsgd ben_pl_bnf_f.amt_dsgd_val%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;

Line 1000: g_bnf_contact_seq_num per_contact_relationships.sequence_number%TYPE;

996: g_bnf_pct_dsgd ben_pl_bnf_f.pct_dsgd_num%TYPE;
997: g_bnf_amt_dsgd ben_pl_bnf_f.amt_dsgd_val%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;

Line 1001: g_bnf_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;

997: g_bnf_amt_dsgd ben_pl_bnf_f.amt_dsgd_val%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;