View: PAY_JP_MAGTAPE_PACTS_V

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

View Text

SELECT PPA.BUSINESS_GROUP_ID + 0
, PPA.PAYROLL_ACTION_ID
, PPA.ACTION_SEQUENCE
, PPA.REQUEST_ID
, PPA.OVERRIDING_DD_DATE
, PPA.START_DATE
, PPA.EFFECTIVE_DATE
, PPA.PAYROLL_ID
, PP.PAYROLL_NAME
, PPA.CONSOLIDATION_SET_ID
, PCS.CONSOLIDATION_SET_NAME
, PPA.ORG_PAYMENT_METHOD_ID
, OPMTL.ORG_PAYMENT_METHOD_NAME
, OPM.CURRENCY_CODE
, OPM.PMETH_INFORMATION_CATEGORY
, OPM.PMETH_INFORMATION_CATEGORY
, OPM.PMETH_INFORMATION1
, OPM.PMETH_INFORMATION2
, OPM.PMETH_INFORMATION3
, OPM.PMETH_INFORMATION4
, OPM.PMETH_INFORMATION5
, OPM.PMETH_INFORMATION6
, OPM.PMETH_INFORMATION7
, OPM.PMETH_INFORMATION8
, OPM.PMETH_INFORMATION9
, OPM.PMETH_INFORMATION10
, OPM.PMETH_INFORMATION11
, OPM.PMETH_INFORMATION12
, OPM.PMETH_INFORMATION13
, OPM.PMETH_INFORMATION14
, OPM.PMETH_INFORMATION15
, OPM.PMETH_INFORMATION16
, OPM.PMETH_INFORMATION17
, OPM.PMETH_INFORMATION18
, OPM.PMETH_INFORMATION19
, OPM.PMETH_INFORMATION20
, OPM.EXTERNAL_ACCOUNT_ID
, PEA.SEGMENT1
, PEA.SEGMENT2
, PEA.SEGMENT3
, PEA.SEGMENT4
, PEA.SEGMENT5
, PEA.SEGMENT6
, PEA.SEGMENT7
, PEA.SEGMENT8
, PEA.SEGMENT9
, PEA.SEGMENT10
, PEA.SEGMENT11
, PEA.SEGMENT12
, PEA.SEGMENT13
, PEA.SEGMENT14
, PEA.SEGMENT15
, PEA.SEGMENT16
, PEA.SEGMENT17
, PEA.SEGMENT18
, PEA.SEGMENT19
, PEA.SEGMENT20
, PEA.SEGMENT21
, PEA.SEGMENT22
, PEA.SEGMENT23
, PEA.SEGMENT24
, PEA.SEGMENT25
, PEA.SEGMENT26
, PEA.SEGMENT27
, PEA.SEGMENT28
, PEA.SEGMENT29
, PEA.SEGMENT30 FROM PAY_EXTERNAL_ACCOUNTS PEA
, PAY_PAYROLLS_F PP
, PAY_ORG_PAYMENT_METHODS_F_TL OPMTL
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_CONSOLIDATION_SETS PCS
, PAY_PAYROLL_ACTIONS PPA WHERE PPA.ACTION_TYPE = 'M' AND PPA.ACTION_STATUS = 'C' AND PCS.CONSOLIDATION_SET_ID = PPA.CONSOLIDATION_SET_ID AND OPM.ORG_PAYMENT_METHOD_ID = PPA.ORG_PAYMENT_METHOD_ID AND PPA.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE AND OPMTL.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID AND OPMTL.LANGUAGE = USERENV('LANG') AND PP.PAYROLL_ID(+) = PPA.PAYROLL_ID AND PPA.EFFECTIVE_DATE BETWEEN PP.EFFECTIVE_START_DATE(+)
AND PP.EFFECTIVE_END_DATE(+) AND PEA.EXTERNAL_ACCOUNT_ID = OPM.EXTERNAL_ACCOUNT_ID

Columns