VIEW: APPS.PO_POSITIONS_VAL_V

Source

View Text - Preformatted

SELECT pp.name, pou.name, pj.name, pp.position_id, pj.job_id, pp.organization_id, pp.business_group_id from per_jobs pj, per_organization_units pou, per_positions pp where pp.job_id = pj.job_id and pou.organization_id = pp.organization_id and sysdate between pp.date_effective and nvl(pp.date_end,sysdate+1)

View Text - HTML Formatted

SELECT PP.NAME
, POU.NAME
, PJ.NAME
, PP.POSITION_ID
, PJ.JOB_ID
, PP.ORGANIZATION_ID
, PP.BUSINESS_GROUP_ID
FROM PER_JOBS PJ
, PER_ORGANIZATION_UNITS POU
, PER_POSITIONS PP
WHERE PP.JOB_ID = PJ.JOB_ID
AND POU.ORGANIZATION_ID = PP.ORGANIZATION_ID
AND SYSDATE BETWEEN PP.DATE_EFFECTIVE
AND NVL(PP.DATE_END
, SYSDATE+1)