VIEW: APPS.HRBV_DEPLOYMENT_FACTORS_V

Source

View Text - Preformatted

SELECT DPF.WORK_ANY_COUNTRY, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',DPF.WORK_ANY_COUNTRY), DPF.WORK_ANY_LOCATION, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',DPF.WORK_ANY_LOCATION), DPF.RELOCATE_DOMESTICALLY, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',DPF.RELOCATE_DOMESTICALLY), DPF.RELOCATE_INTERNATIONALLY, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',DPF.RELOCATE_INTERNATIONALLY), DPF.TRAVEL_REQUIRED, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',DPF.TRAVEL_REQUIRED), DPF.COUNTRY1, DPF.COUNTRY2, DPF.COUNTRY3, DPF.WORK_DURATION, HR_BIS.BIS_DECODE_LOOKUP('PER_TIME_SCALES',DPF.WORK_DURATION), DPF.WORK_SCHEDULE, HR_BIS.BIS_DECODE_LOOKUP('PER_WORK_SCHEDULE',DPF.WORK_SCHEDULE), DPF.WORK_HOURS, HR_BIS.BIS_DECODE_LOOKUP('PER_WORK_HOURS',DPF.WORK_HOURS), DPF.FTE_CAPACITY, HR_BIS.BIS_DECODE_LOOKUP('PER_FTE_CAPACITY',DPF.FTE_CAPACITY), DPF.VISIT_INTERNATIONALLY, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',DPF.VISIT_INTERNATIONALLY), DPF.ONLY_CURRENT_LOCATION, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',DPF.ONLY_CURRENT_LOCATION), DPF.NO_COUNTRY1, DPF.NO_COUNTRY2, DPF.NO_COUNTRY3, DPF.COMMENTS, DPF.EARLIEST_AVAILABLE_DATE, DPF.AVAILABLE_FOR_TRANSFER, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',DPF.AVAILABLE_FOR_TRANSFER), DPF.RELOCATION_PREFERENCE, HR_BIS.BIS_DECODE_LOOKUP('PER_RELOCATION_PREFERENCES',DPF.RELOCATION_PREFERENCE), DPF.RELOCATION_REQUIRED, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',DPF.RELOCATION_REQUIRED), DPF.PASSPORT_REQUIRED, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',DPF.PASSPORT_REQUIRED), DPF.LOCATION1, DPF.LOCATION2, DPF.LOCATION3, DPF.OTHER_REQUIREMENTS, DPF.SERVICE_MINIMUM, HR_BIS.BIS_DECODE_LOOKUP('PER_LENGTHS_OF_SERVICE',DPF.SERVICE_MINIMUM), '_DF:PER:PER_DEPLOYMENT_FACTORS:DPF', DPF.DEPLOYMENT_FACTOR_ID, DPF.POSITION_ID, DPF.PERSON_ID, DPF.JOB_ID, DPF.BUSINESS_GROUP_ID, DPF.LAST_UPDATE_DATE, DPF.LAST_UPDATED_BY, DPF.CREATED_BY, DPF.CREATION_DATE, CASE WHEN DPF.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, DPF.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_DEPLOYMENT_FACTORS DPF WITH READ ONLY

View Text - HTML Formatted

SELECT DPF.WORK_ANY_COUNTRY
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, DPF.WORK_ANY_COUNTRY)
, DPF.WORK_ANY_LOCATION
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, DPF.WORK_ANY_LOCATION)
, DPF.RELOCATE_DOMESTICALLY
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, DPF.RELOCATE_DOMESTICALLY)
, DPF.RELOCATE_INTERNATIONALLY
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, DPF.RELOCATE_INTERNATIONALLY)
, DPF.TRAVEL_REQUIRED
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, DPF.TRAVEL_REQUIRED)
, DPF.COUNTRY1
, DPF.COUNTRY2
, DPF.COUNTRY3
, DPF.WORK_DURATION
, HR_BIS.BIS_DECODE_LOOKUP('PER_TIME_SCALES'
, DPF.WORK_DURATION)
, DPF.WORK_SCHEDULE
, HR_BIS.BIS_DECODE_LOOKUP('PER_WORK_SCHEDULE'
, DPF.WORK_SCHEDULE)
, DPF.WORK_HOURS
, HR_BIS.BIS_DECODE_LOOKUP('PER_WORK_HOURS'
, DPF.WORK_HOURS)
, DPF.FTE_CAPACITY
, HR_BIS.BIS_DECODE_LOOKUP('PER_FTE_CAPACITY'
, DPF.FTE_CAPACITY)
, DPF.VISIT_INTERNATIONALLY
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, DPF.VISIT_INTERNATIONALLY)
, DPF.ONLY_CURRENT_LOCATION
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, DPF.ONLY_CURRENT_LOCATION)
, DPF.NO_COUNTRY1
, DPF.NO_COUNTRY2
, DPF.NO_COUNTRY3
, DPF.COMMENTS
, DPF.EARLIEST_AVAILABLE_DATE
, DPF.AVAILABLE_FOR_TRANSFER
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, DPF.AVAILABLE_FOR_TRANSFER)
, DPF.RELOCATION_PREFERENCE
, HR_BIS.BIS_DECODE_LOOKUP('PER_RELOCATION_PREFERENCES'
, DPF.RELOCATION_PREFERENCE)
, DPF.RELOCATION_REQUIRED
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, DPF.RELOCATION_REQUIRED)
, DPF.PASSPORT_REQUIRED
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, DPF.PASSPORT_REQUIRED)
, DPF.LOCATION1
, DPF.LOCATION2
, DPF.LOCATION3
, DPF.OTHER_REQUIREMENTS
, DPF.SERVICE_MINIMUM
, HR_BIS.BIS_DECODE_LOOKUP('PER_LENGTHS_OF_SERVICE'
, DPF.SERVICE_MINIMUM)
, '_DF:PER:PER_DEPLOYMENT_FACTORS:DPF'
, DPF.DEPLOYMENT_FACTOR_ID
, DPF.POSITION_ID
, DPF.PERSON_ID
, DPF.JOB_ID
, DPF.BUSINESS_GROUP_ID
, DPF.LAST_UPDATE_DATE
, DPF.LAST_UPDATED_BY
, DPF.CREATED_BY
, DPF.CREATION_DATE
, CASE WHEN DPF.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, DPF.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_DEPLOYMENT_FACTORS DPF WITH READ ONLY