VIEW: APPS.PAY_WEBADI_BEE_CONTENT_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)