VIEW: APPS.HRI_CS_AGE_X_V

Source

View Text - Preformatted

SELECT months_between(TRUNC(SYSDATE),per.date_of_birth)/12 age_in_years , months_between(TRUNC(SYSDATE),per.date_of_birth) age_in_months , TRUNC(sysdate) effective_date , per.person_id person_id , to_char(bnds.band_min_total_months) || '-' || NVL(to_char(bnds.band_max_total_months), 'NA_EDW') age_band_id , per.date_of_birth date_of_birth , per.business_group_id business_group_id FROM hri_age_bands bnds , per_all_people_f per WHERE ROUND(MONTHS_BETWEEN(TRUNC(sysdate),per.date_of_birth)) BETWEEN bnds.band_min_total_months AND bnds.band_max_total_months WITH READ ONLY

View Text - HTML Formatted

SELECT MONTHS_BETWEEN(TRUNC(SYSDATE)
, PER.DATE_OF_BIRTH)/12 AGE_IN_YEARS
, MONTHS_BETWEEN(TRUNC(SYSDATE)
, PER.DATE_OF_BIRTH) AGE_IN_MONTHS
, TRUNC(SYSDATE) EFFECTIVE_DATE
, PER.PERSON_ID PERSON_ID
, TO_CHAR(BNDS.BAND_MIN_TOTAL_MONTHS) || '-' || NVL(TO_CHAR(BNDS.BAND_MAX_TOTAL_MONTHS)
, 'NA_EDW') AGE_BAND_ID
, PER.DATE_OF_BIRTH DATE_OF_BIRTH
, PER.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM HRI_AGE_BANDS BNDS
, PER_ALL_PEOPLE_F PER
WHERE ROUND(MONTHS_BETWEEN(TRUNC(SYSDATE)
, PER.DATE_OF_BIRTH)) BETWEEN BNDS.BAND_MIN_TOTAL_MONTHS
AND BNDS.BAND_MAX_TOTAL_MONTHS WITH READ ONLY