View: PAY_SG_ASG_NET_PAYMENTS_V

Product:	PAY - Payroll
Description:	Singapore localisation view.
Implementation/DBA Data:	APPS.PAY_SG_ASG_NET_PAYMENTS_V

View Text

SELECT PAC.ROWID ROW_ID
, PAC.ASSIGNMENT_ACTION_ID PREPAY_SSIGNMENT_ACTION_ID
, NVL(DECODE(PPT.PAYMENT_TYPE_NAME
, 'DIRECT DEPOSIT'
, PEA.SEGMENT1
, POP.ORG_PAYMENT_METHOD_NAME)
, POP.ORG_PAYMENT_METHOD_NAME) ACCOUNT_NUMBER
, HL.MEANING ACCOUNT_TYPE
, PEA.SEGMENT5 BANK_NAME
, PPM.PERCENTAGE
, PPP.VALUE NET_PAY
, POP.CURRENCY_CODE
FROM HR_ORGANIZATION_UNITS HOU
, HR_ORGANIZATION_INFORMATION HOI
, PAY_EXTERNAL_ACCOUNTS PEA
, HR_LOOKUPS HL
, PAY_PERSONAL_PAYMENT_METHODS_F PPM
, PAY_PRE_PAYMENTS PPP
, PAY_ASSIGNMENT_ACTIONS PAC
, PAY_PAYROLL_ACTIONS PPA
, PAY_PAYMENT_TYPES PPT
, PAY_ORG_PAYMENT_METHODS_F POP
WHERE HOI.ORG_INFORMATION_CONTEXT = 'BUSINESS GROUP INFORMATION'
AND HOI.ORG_INFORMATION9 = 'SG'
AND HOU.ORGANIZATION_ID = HOI.ORGANIZATION_ID
AND HOU.BUSINESS_GROUP_ID = POP.BUSINESS_GROUP_ID
AND PPA.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('P'
, 'U')
AND PPA.ACTION_STATUS = 'C'
AND PPT.PAYMENT_TYPE_ID = POP.PAYMENT_TYPE_ID
AND (PPT.TERRITORY_CODE = 'SG' OR PPT.TERRITORY_CODE IS NULL)
AND PAC.ASSIGNMENT_ACTION_ID = PPP.ASSIGNMENT_ACTION_ID
AND POP.ORG_PAYMENT_METHOD_ID = PPP.ORG_PAYMENT_METHOD_ID
AND PPM.PERSONAL_PAYMENT_METHOD_ID(+) = PPP.PERSONAL_PAYMENT_METHOD_ID
AND PPA.EFFECTIVE_DATE BETWEEN NVL(PPM.EFFECTIVE_START_DATE
, TO_DATE('01-01-0001'
, 'DD-MM-YYYY'))
AND NVL(PPM.EFFECTIVE_END_DATE
, TO_DATE('31-12-4712'
, 'DD-MM-YYYY'))
AND PEA.SEGMENT3 = HL.LOOKUP_CODE (+)
AND HL.LOOKUP_TYPE(+) = 'SG_ACCOUNT_TYPE'
AND PEA.EXTERNAL_ACCOUNT_ID(+) = PPM.EXTERNAL_ACCOUNT_ID
AND PPA.EFFECTIVE_DATE BETWEEN POP.EFFECTIVE_START_DATE
AND POP.EFFECTIVE_END_DATE

Columns