VIEW: APPS.HRBV_TIME_PERIOD

Source

View Text - Preformatted

SELECT ptp.period_name period_name ,ptp.description description ,ptp.period_num period_num ,ptp.period_type period_type ,ptp.period_set_name period_set_name ,ptp.period_year period_year ,ptp.quarter_num quarter_num ,ptp.year_number year_number ,ptp.quickpay_display_number quickpay_display_number ,ptp.regular_payment_date regular_payment_date ,ptp.run_display_number run_display_number ,hr_bis.bis_decode_lookup('PROCESSING_PERIOD_STATUS',ptp.status) status ,hr_bis.bis_decode_lookup('PROC_PERIOD_TYPE',ptp.proc_period_type) proc_period_type ,ptp.start_date start_date ,ptp.end_date end_date ,ptp.cut_off_date cut_off_date ,ptp.default_dd_date default_dd_date ,ptp.pay_advice_date pay_advice_date ,ptp.regular_date_earned regular_date_earned ,ptp.status status_code ,ptp.proc_period_type proc_period_type_code ,ptp.prd_information_category prd_information_category ,ptp.prd_information1 prd_information1 ,ptp.prd_information2 prd_information2 ,ptp.prd_information3 prd_information3 ,ptp.prd_information4 prd_information4 ,ptp.prd_information5 prd_information5 ,ptp.prd_information6 prd_information6 ,ptp.prd_information7 prd_information7 ,ptp.prd_information8 prd_information8 ,ptp.prd_information9 prd_information9 ,ptp.prd_information10 prd_information10 ,ptp.prd_information11 prd_information11 ,ptp.prd_information12 prd_information12 ,ptp.prd_information13 prd_information13 ,ptp.prd_information14 prd_information14 ,ptp.prd_information15 prd_information15 ,ptp.prd_information16 prd_information16 ,ptp.prd_information17 prd_information17 ,ptp.prd_information18 prd_information18 ,ptp.prd_information19 prd_information19 ,ptp.prd_information20 prd_information20 ,ptp.prd_information21 prd_information21 ,ptp.prd_information22 prd_information22 ,ptp.prd_information23 prd_information23 ,ptp.prd_information24 prd_information24 ,ptp.prd_information25 prd_information25 ,ptp.prd_information26 prd_information26 ,ptp.prd_information27 prd_information27 ,ptp.prd_information28 prd_information28 ,ptp.prd_information29 prd_information29 ,ptp.prd_information30 prd_information30 ,'_DF:PER:PER_TIME_PERIODS:ptp' ,ptp.time_period_id time_period_id ,ptp.payroll_id payroll_id ,ptp.last_update_date last_update_date ,ptp.last_updated_by last_updated_by ,ptp.last_update_login last_update_login ,ptp.created_by created_by ,ptp.creation_date creation_date FROM per_time_periods ptp WITH READ ONLY

View Text - HTML Formatted

SELECT PTP.PERIOD_NAME PERIOD_NAME
, PTP.DESCRIPTION DESCRIPTION
, PTP.PERIOD_NUM PERIOD_NUM
, PTP.PERIOD_TYPE PERIOD_TYPE
, PTP.PERIOD_SET_NAME PERIOD_SET_NAME
, PTP.PERIOD_YEAR PERIOD_YEAR
, PTP.QUARTER_NUM QUARTER_NUM
, PTP.YEAR_NUMBER YEAR_NUMBER
, PTP.QUICKPAY_DISPLAY_NUMBER QUICKPAY_DISPLAY_NUMBER
, PTP.REGULAR_PAYMENT_DATE REGULAR_PAYMENT_DATE
, PTP.RUN_DISPLAY_NUMBER RUN_DISPLAY_NUMBER
, HR_BIS.BIS_DECODE_LOOKUP('PROCESSING_PERIOD_STATUS'
, PTP.STATUS) STATUS
, HR_BIS.BIS_DECODE_LOOKUP('PROC_PERIOD_TYPE'
, PTP.PROC_PERIOD_TYPE) PROC_PERIOD_TYPE
, PTP.START_DATE START_DATE
, PTP.END_DATE END_DATE
, PTP.CUT_OFF_DATE CUT_OFF_DATE
, PTP.DEFAULT_DD_DATE DEFAULT_DD_DATE
, PTP.PAY_ADVICE_DATE PAY_ADVICE_DATE
, PTP.REGULAR_DATE_EARNED REGULAR_DATE_EARNED
, PTP.STATUS STATUS_CODE
, PTP.PROC_PERIOD_TYPE PROC_PERIOD_TYPE_CODE
, PTP.PRD_INFORMATION_CATEGORY PRD_INFORMATION_CATEGORY
, PTP.PRD_INFORMATION1 PRD_INFORMATION1
, PTP.PRD_INFORMATION2 PRD_INFORMATION2
, PTP.PRD_INFORMATION3 PRD_INFORMATION3
, PTP.PRD_INFORMATION4 PRD_INFORMATION4
, PTP.PRD_INFORMATION5 PRD_INFORMATION5
, PTP.PRD_INFORMATION6 PRD_INFORMATION6
, PTP.PRD_INFORMATION7 PRD_INFORMATION7
, PTP.PRD_INFORMATION8 PRD_INFORMATION8
, PTP.PRD_INFORMATION9 PRD_INFORMATION9
, PTP.PRD_INFORMATION10 PRD_INFORMATION10
, PTP.PRD_INFORMATION11 PRD_INFORMATION11
, PTP.PRD_INFORMATION12 PRD_INFORMATION12
, PTP.PRD_INFORMATION13 PRD_INFORMATION13
, PTP.PRD_INFORMATION14 PRD_INFORMATION14
, PTP.PRD_INFORMATION15 PRD_INFORMATION15
, PTP.PRD_INFORMATION16 PRD_INFORMATION16
, PTP.PRD_INFORMATION17 PRD_INFORMATION17
, PTP.PRD_INFORMATION18 PRD_INFORMATION18
, PTP.PRD_INFORMATION19 PRD_INFORMATION19
, PTP.PRD_INFORMATION20 PRD_INFORMATION20
, PTP.PRD_INFORMATION21 PRD_INFORMATION21
, PTP.PRD_INFORMATION22 PRD_INFORMATION22
, PTP.PRD_INFORMATION23 PRD_INFORMATION23
, PTP.PRD_INFORMATION24 PRD_INFORMATION24
, PTP.PRD_INFORMATION25 PRD_INFORMATION25
, PTP.PRD_INFORMATION26 PRD_INFORMATION26
, PTP.PRD_INFORMATION27 PRD_INFORMATION27
, PTP.PRD_INFORMATION28 PRD_INFORMATION28
, PTP.PRD_INFORMATION29 PRD_INFORMATION29
, PTP.PRD_INFORMATION30 PRD_INFORMATION30
, '_DF:PER:PER_TIME_PERIODS:PTP'
, PTP.TIME_PERIOD_ID TIME_PERIOD_ID
, PTP.PAYROLL_ID PAYROLL_ID
, PTP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PTP.LAST_UPDATED_BY LAST_UPDATED_BY
, PTP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PTP.CREATED_BY CREATED_BY
, PTP.CREATION_DATE CREATION_DATE
FROM PER_TIME_PERIODS PTP WITH READ ONLY