VIEW: APPS.BEN_PL_BNF_D

Source

View Text - Preformatted

SELECT pbn.ROWID row_id, pbn.pl_bnf_id, pbn.effective_start_date, pbn.effective_end_date, bnf_person.full_name bnf_person_full_name, ORGANIZATION.NAME organization_name, ttee_person.full_name ttee_person_full_name, prmry_cntngnt.meaning prmry_cntngnt_meaning, pbn.pct_dsgd_num, pbn.amt_dsgd_val, pbn.amt_dsgd_uom, pbn.addl_instrn_txt, pbn.dsgn_strt_dt, pbn.dsgn_thru_dt, pbn.last_update_date, fuser.user_name FROM ben_pl_bnf_f pbn, ben_per_in_ler pil, per_all_people_f bnf_person, per_all_people_f ttee_person, hr_all_organization_units_vl ORGANIZATION, hr_lookups prmry_cntngnt, fnd_user fuser WHERE fuser.user_id(+) = pbn.last_updated_by AND bnf_person.person_id(+) = pbn.bnf_person_id AND pbn.effective_start_date BETWEEN bnf_person.effective_start_date(+) AND bnf_person.effective_end_date(+) AND ttee_person.person_id(+) = pbn.ttee_person_id AND pbn.effective_start_date BETWEEN ttee_person.effective_start_date(+) AND ttee_person.effective_end_date(+) AND ORGANIZATION.organization_id(+) = pbn.organization_id AND prmry_cntngnt.lookup_code(+) = pbn.prmry_cntngnt_cd AND prmry_cntngnt.lookup_type(+) = 'BEN_PRMRY_CNTNGNT' AND pil.per_in_ler_id(+) = pbn.per_in_ler_id AND pil.business_group_id(+) = pbn.business_group_id + 0 AND ( pil.per_in_ler_stat_cd NOT IN ('VOIDD', 'BCKDT') OR pil.per_in_ler_stat_cd IS NULL )

View Text - HTML Formatted

SELECT PBN.ROWID ROW_ID
, PBN.PL_BNF_ID
, PBN.EFFECTIVE_START_DATE
, PBN.EFFECTIVE_END_DATE
, BNF_PERSON.FULL_NAME BNF_PERSON_FULL_NAME
, ORGANIZATION.NAME ORGANIZATION_NAME
, TTEE_PERSON.FULL_NAME TTEE_PERSON_FULL_NAME
, PRMRY_CNTNGNT.MEANING PRMRY_CNTNGNT_MEANING
, PBN.PCT_DSGD_NUM
, PBN.AMT_DSGD_VAL
, PBN.AMT_DSGD_UOM
, PBN.ADDL_INSTRN_TXT
, PBN.DSGN_STRT_DT
, PBN.DSGN_THRU_DT
, PBN.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_PL_BNF_F PBN
, BEN_PER_IN_LER PIL
, PER_ALL_PEOPLE_F BNF_PERSON
, PER_ALL_PEOPLE_F TTEE_PERSON
, HR_ALL_ORGANIZATION_UNITS_VL ORGANIZATION
, HR_LOOKUPS PRMRY_CNTNGNT
, FND_USER FUSER
WHERE FUSER.USER_ID(+) = PBN.LAST_UPDATED_BY
AND BNF_PERSON.PERSON_ID(+) = PBN.BNF_PERSON_ID
AND PBN.EFFECTIVE_START_DATE BETWEEN BNF_PERSON.EFFECTIVE_START_DATE(+)
AND BNF_PERSON.EFFECTIVE_END_DATE(+)
AND TTEE_PERSON.PERSON_ID(+) = PBN.TTEE_PERSON_ID
AND PBN.EFFECTIVE_START_DATE BETWEEN TTEE_PERSON.EFFECTIVE_START_DATE(+)
AND TTEE_PERSON.EFFECTIVE_END_DATE(+)
AND ORGANIZATION.ORGANIZATION_ID(+) = PBN.ORGANIZATION_ID
AND PRMRY_CNTNGNT.LOOKUP_CODE(+) = PBN.PRMRY_CNTNGNT_CD
AND PRMRY_CNTNGNT.LOOKUP_TYPE(+) = 'BEN_PRMRY_CNTNGNT'
AND PIL.PER_IN_LER_ID(+) = PBN.PER_IN_LER_ID
AND PIL.BUSINESS_GROUP_ID(+) = PBN.BUSINESS_GROUP_ID + 0
AND ( PIL.PER_IN_LER_STAT_CD NOT IN ('VOIDD'
, 'BCKDT') OR PIL.PER_IN_LER_STAT_CD IS NULL )