VIEW: APPS.PAY_PDT_BATCH_HEADERS

Source

View Text - Preformatted

SELECT pbh.batch_id , TO_NUMBER( NULL ) payroll_id , pbh.business_group_id , decode( pbh.batch_status,'P','H','U','R',pbh.batch_status) batch_status , l.lookup_code batch_type , pbh.batch_reference reference_num , pbh.last_update_date , pbh.last_updated_by , pbh.last_update_login , pbh.created_by , pbh.creation_date , TO_DATE( NULL ) last_processed_date FROM pay_batch_headers pbh , hr_lookups l WHERE pbh.comments = l.meaning(+) AND l.lookup_type(+) = 'PAY_PDT_BATCH_TYPES' AND pbh.batch_name = 'Batch '||TO_CHAR( pbh.batch_id )

View Text - HTML Formatted

SELECT PBH.BATCH_ID
, TO_NUMBER( NULL ) PAYROLL_ID
, PBH.BUSINESS_GROUP_ID
, DECODE( PBH.BATCH_STATUS
, 'P'
, 'H'
, 'U'
, 'R'
, PBH.BATCH_STATUS) BATCH_STATUS
, L.LOOKUP_CODE BATCH_TYPE
, PBH.BATCH_REFERENCE REFERENCE_NUM
, PBH.LAST_UPDATE_DATE
, PBH.LAST_UPDATED_BY
, PBH.LAST_UPDATE_LOGIN
, PBH.CREATED_BY
, PBH.CREATION_DATE
, TO_DATE( NULL ) LAST_PROCESSED_DATE
FROM PAY_BATCH_HEADERS PBH
, HR_LOOKUPS L
WHERE PBH.COMMENTS = L.MEANING(+)
AND L.LOOKUP_TYPE(+) = 'PAY_PDT_BATCH_TYPES'
AND PBH.BATCH_NAME = 'BATCH '||TO_CHAR( PBH.BATCH_ID )