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 579: g_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;

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

Line 580: g_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;

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

Line 581: g_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;

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

Line 622: g_elig_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;

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

Line 623: g_elig_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;

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

Line 624: g_elig_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;

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

Line 694: g_contact_rlshp_type per_contact_relationships.contact_type%TYPE;

690: g_contact_home_phone per_phones.phone_number%TYPE;
691: g_contact_fax per_phones.phone_number%TYPE;
692: g_contact_mobile per_phones.phone_number%TYPE;
693: g_contact_work_phone per_phones.phone_number%TYPE;
694: g_contact_rlshp_type per_contact_relationships.contact_type%TYPE;
695: g_contact_rlshp_id per_contact_relationships.contact_relationship_id%TYPE;
696: g_contact_seq_num per_contact_relationships.sequence_number%TYPE;
697: g_contact_prmy_contact_flag per_contact_relationships.PRIMARY_CONTACT_FLAG%TYPE;
698: g_contact_shared_resd_flag per_contact_relationships.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE;

Line 695: g_contact_rlshp_id per_contact_relationships.contact_relationship_id%TYPE;

691: g_contact_fax per_phones.phone_number%TYPE;
692: g_contact_mobile per_phones.phone_number%TYPE;
693: g_contact_work_phone per_phones.phone_number%TYPE;
694: g_contact_rlshp_type per_contact_relationships.contact_type%TYPE;
695: g_contact_rlshp_id per_contact_relationships.contact_relationship_id%TYPE;
696: g_contact_seq_num per_contact_relationships.sequence_number%TYPE;
697: g_contact_prmy_contact_flag per_contact_relationships.PRIMARY_CONTACT_FLAG%TYPE;
698: g_contact_shared_resd_flag per_contact_relationships.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE;
699: g_contact_personal_flag per_contact_relationships.PERSONAL_FLAG%TYPE;

Line 696: g_contact_seq_num per_contact_relationships.sequence_number%TYPE;

692: g_contact_mobile per_phones.phone_number%TYPE;
693: g_contact_work_phone per_phones.phone_number%TYPE;
694: g_contact_rlshp_type per_contact_relationships.contact_type%TYPE;
695: g_contact_rlshp_id per_contact_relationships.contact_relationship_id%TYPE;
696: g_contact_seq_num per_contact_relationships.sequence_number%TYPE;
697: g_contact_prmy_contact_flag per_contact_relationships.PRIMARY_CONTACT_FLAG%TYPE;
698: g_contact_shared_resd_flag per_contact_relationships.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE;
699: g_contact_personal_flag per_contact_relationships.PERSONAL_FLAG%TYPE;
700: g_contact_pymts_rcpnt_flag per_contact_relationships.THIRD_PARTY_PAY_FLAG%TYPE;

Line 697: g_contact_prmy_contact_flag per_contact_relationships.PRIMARY_CONTACT_FLAG%TYPE;

693: g_contact_work_phone per_phones.phone_number%TYPE;
694: g_contact_rlshp_type per_contact_relationships.contact_type%TYPE;
695: g_contact_rlshp_id per_contact_relationships.contact_relationship_id%TYPE;
696: g_contact_seq_num per_contact_relationships.sequence_number%TYPE;
697: g_contact_prmy_contact_flag per_contact_relationships.PRIMARY_CONTACT_FLAG%TYPE;
698: g_contact_shared_resd_flag per_contact_relationships.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE;
699: g_contact_personal_flag per_contact_relationships.PERSONAL_FLAG%TYPE;
700: g_contact_pymts_rcpnt_flag per_contact_relationships.THIRD_PARTY_PAY_FLAG%TYPE;
701: g_contact_start_date per_contact_relationships.DATE_START%TYPE;

Line 698: g_contact_shared_resd_flag per_contact_relationships.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE;

694: g_contact_rlshp_type per_contact_relationships.contact_type%TYPE;
695: g_contact_rlshp_id per_contact_relationships.contact_relationship_id%TYPE;
696: g_contact_seq_num per_contact_relationships.sequence_number%TYPE;
697: g_contact_prmy_contact_flag per_contact_relationships.PRIMARY_CONTACT_FLAG%TYPE;
698: g_contact_shared_resd_flag per_contact_relationships.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE;
699: g_contact_personal_flag per_contact_relationships.PERSONAL_FLAG%TYPE;
700: g_contact_pymts_rcpnt_flag per_contact_relationships.THIRD_PARTY_PAY_FLAG%TYPE;
701: g_contact_start_date per_contact_relationships.DATE_START%TYPE;
702: g_contact_end_date per_contact_relationships.DATE_END%TYPE;

Line 699: g_contact_personal_flag per_contact_relationships.PERSONAL_FLAG%TYPE;

695: g_contact_rlshp_id per_contact_relationships.contact_relationship_id%TYPE;
696: g_contact_seq_num per_contact_relationships.sequence_number%TYPE;
697: g_contact_prmy_contact_flag per_contact_relationships.PRIMARY_CONTACT_FLAG%TYPE;
698: g_contact_shared_resd_flag per_contact_relationships.RLTD_PER_RSDS_W_DSGNTR_FLAG%TYPE;
699: g_contact_personal_flag per_contact_relationships.PERSONAL_FLAG%TYPE;
700: g_contact_pymts_rcpnt_flag per_contact_relationships.THIRD_PARTY_PAY_FLAG%TYPE;
701: g_contact_start_date per_contact_relationships.DATE_START%TYPE;
702: g_contact_end_date per_contact_relationships.DATE_END%TYPE;
703: g_contact_start_life_evt ben_ler_f.name%TYPE;

Line 700: g_contact_pymts_rcpnt_flag per_contact_relationships.THIRD_PARTY_PAY_FLAG%TYPE;

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

Line 701: g_contact_start_date per_contact_relationships.DATE_START%TYPE;

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

Line 702: g_contact_end_date per_contact_relationships.DATE_END%TYPE;

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

Line 1002: g_bnf_rlshp per_contact_relationships.contact_type%TYPE;

998: g_bnf_prmy_cont ben_pl_bnf_f.prmry_cntngnt_cd%TYPE;
999: g_bnf_pct_dsgd ben_pl_bnf_f.pct_dsgd_num%TYPE;
1000: g_bnf_amt_dsgd ben_pl_bnf_f.amt_dsgd_val%TYPE;
1001: g_bnf_amt_uom ben_pl_bnf_f.amt_dsgd_uom%TYPE;
1002: g_bnf_rlshp per_contact_relationships.contact_type%TYPE;
1003: g_bnf_contact_seq_num per_contact_relationships.sequence_number%TYPE;
1004: g_bnf_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
1005: g_bnf_home_phone per_phones.phone_number%TYPE;
1006: g_bnf_fax per_phones.phone_number%TYPE;

Line 1003: g_bnf_contact_seq_num per_contact_relationships.sequence_number%TYPE;

999: g_bnf_pct_dsgd ben_pl_bnf_f.pct_dsgd_num%TYPE;
1000: g_bnf_amt_dsgd ben_pl_bnf_f.amt_dsgd_val%TYPE;
1001: g_bnf_amt_uom ben_pl_bnf_f.amt_dsgd_uom%TYPE;
1002: g_bnf_rlshp per_contact_relationships.contact_type%TYPE;
1003: g_bnf_contact_seq_num per_contact_relationships.sequence_number%TYPE;
1004: g_bnf_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
1005: g_bnf_home_phone per_phones.phone_number%TYPE;
1006: g_bnf_fax per_phones.phone_number%TYPE;
1007: g_bnf_mobile per_phones.phone_number%TYPE;

Line 1004: g_bnf_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;

1000: g_bnf_amt_dsgd ben_pl_bnf_f.amt_dsgd_val%TYPE;
1001: g_bnf_amt_uom ben_pl_bnf_f.amt_dsgd_uom%TYPE;
1002: g_bnf_rlshp per_contact_relationships.contact_type%TYPE;
1003: g_bnf_contact_seq_num per_contact_relationships.sequence_number%TYPE;
1004: g_bnf_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
1005: g_bnf_home_phone per_phones.phone_number%TYPE;
1006: g_bnf_fax per_phones.phone_number%TYPE;
1007: g_bnf_mobile per_phones.phone_number%TYPE;
1008: g_bnf_work_phone per_phones.phone_number%TYPE;