View: PAY_WEBADI_BEE_CONTENT_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_WEBADI_BEE_CONTENT_V

View Text

SELECT PBL.BATCH_ID BATCH_ID
, PBL.BATCH_LINE_ID BATCH_LINE_ID
, DECODE(PBL.BATCH_LINE_STATUS
, NULL
, NULL
, (SELECT MEANING
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE='BATCH_STATUS' AND LOOKUP_CODE=PBL.BATCH_LINE_STATUS )) BATCH_LINE_STATUS
, PBL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PBL.ASSIGNMENT_ID ASSIGNMENT_ID
, PBL.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, PBL.ATTRIBUTE_CATEGORY ATTRIB_CATEGORY
, PBL.ATTRIBUTE1 ATTRIB1
, PBL.ATTRIBUTE2 ATTRIB2
, PBL.ATTRIBUTE3 ATTRIB3
, PBL.ATTRIBUTE4 ATTRIB4
, PBL.ATTRIBUTE5 ATTRIB5
, PBL.ATTRIBUTE6 ATTRIB6
, PBL.ATTRIBUTE7 ATTRIB7
, PBL.ATTRIBUTE8 ATTRIB8
, PBL.ATTRIBUTE9 ATTRIB9
, PBL.ATTRIBUTE10 ATTRIB10
, PBL.ATTRIBUTE11 ATTRIB11
, PBL.ATTRIBUTE12 ATTRIB12
, PBL.ATTRIBUTE13 ATTRIB13
, PBL.ATTRIBUTE14 ATTRIB14
, PBL.ATTRIBUTE15 ATTRIB15
, PBL.ATTRIBUTE16 ATTRIB16
, PBL.ATTRIBUTE17 ATTRIB17
, PBL.ATTRIBUTE18 ATTRIB18
, PBL.ATTRIBUTE19 ATTRIB19
, PBL.ATTRIBUTE20 ATTRIB20
, PBL.ENTRY_INFORMATION_CATEGORY ENT_INFO_CATEGORY
, PBL.ENTRY_INFORMATION1 ENT_INFO1
, PBL.ENTRY_INFORMATION2 ENT_INFO2
, PBL.ENTRY_INFORMATION3 ENT_INFO3
, PBL.ENTRY_INFORMATION4 ENT_INFO4
, PBL.ENTRY_INFORMATION5 ENT_INFO5
, PBL.ENTRY_INFORMATION6 ENT_INFO6
, PBL.ENTRY_INFORMATION7 ENT_INFO7
, PBL.ENTRY_INFORMATION8 ENT_INFO8
, PBL.ENTRY_INFORMATION9 ENT_INFO9
, PBL.ENTRY_INFORMATION10 ENT_INFO10
, PBL.ENTRY_INFORMATION11 ENT_INFO11
, PBL.ENTRY_INFORMATION12 ENT_INFO12
, PBL.ENTRY_INFORMATION13 ENT_INFO13
, PBL.ENTRY_INFORMATION14 ENT_INFO14
, PBL.ENTRY_INFORMATION15 ENT_INFO15
, PBL.ENTRY_INFORMATION16 ENT_INFO16
, PBL.ENTRY_INFORMATION17 ENT_INFO17
, PBL.ENTRY_INFORMATION18 ENT_INFO18
, PBL.ENTRY_INFORMATION19 ENT_INFO19
, PBL.ENTRY_INFORMATION20 ENT_INFO20
, PBL.ENTRY_INFORMATION21 ENT_INFO21
, PBL.ENTRY_INFORMATION22 ENT_INFO22
, PBL.ENTRY_INFORMATION23 ENT_INFO23
, PBL.ENTRY_INFORMATION24 ENT_INFO24
, PBL.ENTRY_INFORMATION25 ENT_INFO25
, PBL.ENTRY_INFORMATION26 ENT_INFO26
, PBL.ENTRY_INFORMATION27 ENT_INFO27
, PBL.ENTRY_INFORMATION28 ENT_INFO28
, PBL.ENTRY_INFORMATION29 ENT_INFO29
, PBL.ENTRY_INFORMATION30 ENT_INFO30
, PBL.DATE_EARNED DATE_EARNED
, DECODE( PPM.PAYEE_TYPE
, 'O'
, ( SELECT THIRD_PARTY.NAME||' '||OPMTL.ORG_PAYMENT_METHOD_NAME||' '|| PAY_TYPETL.PAYMENT_TYPE_NAME FROM PAY_ORG_PAYMENT_METHODS_F_TL OPMTL
, HR_ORGANIZATION_UNITS THIRD_PARTY
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_PERSONAL_PAYMENT_METHODS_F PPT
, PAY_PAYMENT_TYPES PAY_TYPE
, PAY_PAYMENT_TYPES_TL PAY_TYPETL WHERE PPT.PAYEE_TYPE = 'O' AND OPM.DEFINED_BALANCE_ID IS NULL AND OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID AND OPMTL.LANGUAGE= USERENV('LANG') AND PAY_TYPE.PAYMENT_TYPE_ID = PAY_TYPETL.PAYMENT_TYPE_ID AND PAY_TYPETL.LANGUAGE = USERENV('LANG') AND PPT.PAYEE_ID = THIRD_PARTY.ORGANIZATION_ID (+) AND PAY_TYPE.PAYMENT_TYPE_ID = OPM.PAYMENT_TYPE_ID AND OPM.ORG_PAYMENT_METHOD_ID = PPT.ORG_PAYMENT_METHOD_ID AND PBL.EFFECTIVE_DATE BETWEEN PPT.EFFECTIVE_START_DATE
AND PPT.EFFECTIVE_END_DATE AND PBL.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE AND PPT.ASSIGNMENT_ID = PBL.ASSIGNMENT_ID)
, 'P'
, (SELECT THIRD_PARTY.FULL_NAME ||' '|| OPMTL.ORG_PAYMENT_METHOD_NAME||' '|| PAY_TYPETL.PAYMENT_TYPE_NAME FROM PER_PEOPLE_F THIRD_PARTY
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_PERSONAL_PAYMENT_METHODS_F PPT
, PAY_ORG_PAYMENT_METHODS_F_TL OPMTL
, PAY_PAYMENT_TYPES PAY_TYPE
, PAY_PAYMENT_TYPES_TL PAY_TYPETL WHERE PPT.PAYEE_TYPE = 'P' AND OPM.DEFINED_BALANCE_ID IS NULL AND OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID AND OPMTL.LANGUAGE = USERENV('LANG') AND PAY_TYPE.PAYMENT_TYPE_ID = PAY_TYPETL.PAYMENT_TYPE_ID AND PAY_TYPETL.LANGUAGE = USERENV('LANG')
AND PPT.PAYEE_ID = THIRD_PARTY.PERSON_ID (+) AND PAY_TYPE.PAYMENT_TYPE_ID = OPM.PAYMENT_TYPE_ID AND OPM.ORG_PAYMENT_METHOD_ID = PPT.ORG_PAYMENT_METHOD_ID AND PBL.EFFECTIVE_DATE BETWEEN PPM.EFFECTIVE_START_DATE
AND PPM.EFFECTIVE_END_DATE AND PBL.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE AND (PBL.EFFECTIVE_DATE BETWEEN THIRD_PARTY.EFFECTIVE_START_DATE
AND THIRD_PARTY.EFFECTIVE_END_DATE OR THIRD_PARTY.PERSON_ID IS NULL) AND PPT.ASSIGNMENT_ID = PBL.ASSIGNMENT_ID )
, (SELECT OPMTL.ORG_PAYMENT_METHOD_NAME||' '|| PAY_TYPETL.PAYMENT_TYPE_NAME FROM PAY_ORG_PAYMENT_METHODS_F_TL OPMTL
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_PERSONAL_PAYMENT_METHODS_F PPT
, PAY_PAYMENT_TYPES PAY_TYPE
, PAY_PAYMENT_TYPES_TL PAY_TYPETL WHERE PPT.PAYEE_TYPE IS NULL AND OPM.DEFINED_BALANCE_ID IS NULL AND OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID AND OPMTL.LANGUAGE = USERENV('LANG') AND PAY_TYPE.PAYMENT_TYPE_ID = PAY_TYPETL.PAYMENT_TYPE_ID AND PAY_TYPETL.LANGUAGE = USERENV('LANG') AND PAY_TYPE.PAYMENT_TYPE_ID = OPM.PAYMENT_TYPE_ID AND OPM.ORG_PAYMENT_METHOD_ID = PPT.ORG_PAYMENT_METHOD_ID AND PBL.EFFECTIVE_DATE BETWEEN PPT.EFFECTIVE_START_DATE
AND PPM.EFFECTIVE_END_DATE AND PBL.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE AND PPT.ASSIGNMENT_ID = PBL.ASSIGNMENT_ID )) PERSONAL_PAYMENT_METHOD_ID
, PBL.SUBPRIORITY SUBPRIORITY
, PBL.BATCH_SEQUENCE BATCH_SEQUENCE
, PBL.CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS
, PBL.COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID
, PBL.EFFECTIVE_DATE EFFECTIVE_DATE
, PBL.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PBL.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PBL.ELEMENT_NAME ELEMENT_NAME
, PBL.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, PBL.ENTRY_TYPE ENTRY_TYPE
, DECODE(PBL.REASON
, NULL
, NULL
, (SELECT MEANING
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE='ELE_ENTRY_REASON'
AND LOOKUP_CODE=PBL.REASON )) REASON
, PBL.SEGMENT1 SEG1
, PBL.SEGMENT2 SEG2
, PBL.SEGMENT3 SEG3
, PBL.SEGMENT4 SEG4
, PBL.SEGMENT5 SEG5
, PBL.SEGMENT6 SEG6
, PBL.SEGMENT7 SEG7
, PBL.SEGMENT8 SEG8
, PBL.SEGMENT9 SEG9
, PBL.SEGMENT10 SEG10
, PBL.SEGMENT11 SEG11
, PBL.SEGMENT12 SEG12
, PBL.SEGMENT13 SEG13
, PBL.SEGMENT14 SEG14
, PBL.SEGMENT15 SEG15
, PBL.SEGMENT16 SEG16
, PBL.SEGMENT17 SEG17
, PBL.SEGMENT18 SEG18
, PBL.SEGMENT19 SEG19
, PBL.SEGMENT20 SEG20
, PBL.SEGMENT21 SEG21
, PBL.SEGMENT22 SEG22
, PBL.SEGMENT23 SEG23
, PBL.SEGMENT24 SEG24
, PBL.SEGMENT25 SEG25
, PBL.SEGMENT26 SEG26
, PBL.SEGMENT27 SEG27
, PBL.SEGMENT28 SEG28
, PBL.SEGMENT29 SEG29
, PBL.SEGMENT30 SEG30
, PAY_PAYWSQEE_PKG.CONVERT_INTERNAL_TO_DISPLAY(PBL.ELEMENT_TYPE_ID
, PBL.VALUE_1
, 1
, SYSDATE
, PBL.BATCH_ID) VAL1
, PAY_PAYWSQEE_PKG.CONVERT_INTERNAL_TO_DISPLAY(PBL.ELEMENT_TYPE_ID
, PBL.VALUE_2
, 2
, SYSDATE
, PBL.BATCH_ID) VAL2
, PAY_PAYWSQEE_PKG.CONVERT_INTERNAL_TO_DISPLAY(PBL.ELEMENT_TYPE_ID
, PBL.VALUE_3
, 3
, SYSDATE
, PBL.BATCH_ID) VAL3
, PAY_PAYWSQEE_PKG.CONVERT_INTERNAL_TO_DISPLAY(PBL.ELEMENT_TYPE_ID
, PBL.VALUE_4
, 4
, SYSDATE
, PBL.BATCH_ID) VAL4
, PAY_PAYWSQEE_PKG.CONVERT_INTERNAL_TO_DISPLAY(PBL.ELEMENT_TYPE_ID
, PBL.VALUE_5
, 5
, SYSDATE
, PBL.BATCH_ID) VAL5
, PAY_PAYWSQEE_PKG.CONVERT_INTERNAL_TO_DISPLAY(PBL.ELEMENT_TYPE_ID
, PBL.VALUE_6
, 6
, SYSDATE
, PBL.BATCH_ID) VAL6
, PAY_PAYWSQEE_PKG.CONVERT_INTERNAL_TO_DISPLAY(PBL.ELEMENT_TYPE_ID
, PBL.VALUE_7
, 7
, SYSDATE
, PBL.BATCH_ID) VAL7
, PAY_PAYWSQEE_PKG.CONVERT_INTERNAL_TO_DISPLAY(PBL.ELEMENT_TYPE_ID
, PBL.VALUE_8
, 8
, SYSDATE
, PBL.BATCH_ID) VAL8
, PAY_PAYWSQEE_PKG.CONVERT_INTERNAL_TO_DISPLAY(PBL.ELEMENT_TYPE_ID
, PBL.VALUE_9
, 9
, SYSDATE
, PBL.BATCH_ID) VAL9
, PAY_PAYWSQEE_PKG.CONVERT_INTERNAL_TO_DISPLAY(PBL.ELEMENT_TYPE_ID
, PBL.VALUE_10
, 10
, SYSDATE
, PBL.BATCH_ID) VAL10
, PAY_PAYWSQEE_PKG.CONVERT_INTERNAL_TO_DISPLAY(PBL.ELEMENT_TYPE_ID
, PBL.VALUE_11
, 11
, SYSDATE
, PBL.BATCH_ID) VAL11
, PAY_PAYWSQEE_PKG.CONVERT_INTERNAL_TO_DISPLAY(PBL.ELEMENT_TYPE_ID
, PBL.VALUE_12
, 12
, SYSDATE
, PBL.BATCH_ID) VAL12
, PAY_PAYWSQEE_PKG.CONVERT_INTERNAL_TO_DISPLAY(PBL.ELEMENT_TYPE_ID
, PBL.VALUE_13
, 13
, SYSDATE
, PBL.BATCH_ID) VAL13
, PAY_PAYWSQEE_PKG.CONVERT_INTERNAL_TO_DISPLAY(PBL.ELEMENT_TYPE_ID
, PBL.VALUE_14
, 14
, SYSDATE
, PBL.BATCH_ID) VAL14
, PAY_PAYWSQEE_PKG.CONVERT_INTERNAL_TO_DISPLAY(PBL.ELEMENT_TYPE_ID
, PBL.VALUE_15
, 15
, SYSDATE
, PBL.BATCH_ID) VAL15
, DECODE(PBL.BATCH_LINE_STATUS
, 'E'
, (SELECT LINE_TEXT
FROM PAY_MESSAGE_LINES
WHERE SOURCE_TYPE='L'
AND SOURCE_ID = PBL.BATCH_LINE_ID)
, NULL) ERROR_MESSAGE
FROM PAY_BATCH_LINES PBL
, PAY_PERSONAL_PAYMENT_METHODS_F PPM
WHERE PBL.PERSONAL_PAYMENT_METHOD_ID = PPM.PERSONAL_PAYMENT_METHOD_ID(+)

Columns