View: HRFV_US_DIRECT_DEPOSITS

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_US_DIRECT_DEPOSITS

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PP.FULL_NAME PERSON_NAME
, OPM.ORG_PAYMENT_METHOD_NAME PAYMENT_METHOD
, PPM.AMOUNT AMOUNT
, PPM.PERCENTAGE PERCENTAGE
, PPM.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, HR_DISCOVERER.CHECK_END_DATE(PPM.EFFECTIVE_END_DATE) EFFECTIVE_END_DATE
, PPM.PRIORITY PRIORITY
, DECODE(PT.TERRITORY_CODE
, 'US'
, PEA.SEGMENT1
, NULL) ACCOUNT_NAME
, DECODE(PT.TERRITORY_CODE
, 'US'
, HR_BIS.BIS_DECODE_LOOKUP('US_ACCOUNT_TYPE'
, PEA.SEGMENT2)
, NULL) ACCOUNT_TYPE
, DECODE(PT.TERRITORY_CODE
, 'US'
, PEA.SEGMENT3
, NULL) ACCOUNT_NUMBER
, DECODE(PT.TERRITORY_CODE
, 'US'
, PEA.SEGMENT4
, NULL) TRANSIT_CODE
, DECODE(PT.TERRITORY_CODE
, 'US'
, PEA.SEGMENT5
, NULL) BANK_NAME
, DECODE(PT.TERRITORY_CODE
, 'US'
, PEA.SEGMENT6
, NULL) BRANCH
, PTT.PAYMENT_TYPE_NAME PAYMENT_TYPE
, OPM.CURRENCY_CODE CURRENCY_CODE
, PA.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, ORGT.NAME ORGANIZATION_NAME
, JOB.NAME JOB_NAME
, POS.NAME POSITION_NAME
, GRD.NAME GRADE_NAME
, LOCT.LOCATION_CODE LOCATION_NAME
, PP.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, '_DF:PAY:PAY_PERSONAL_PAYMENT_METHODS:PPM'
, PA.ASSIGNMENT_ID ASSIGNMENT_ID
, PA.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEA.EXTERNAL_ACCOUNT_ID EXTERNAL_ACCOUNT_ID
, GRD.GRADE_ID GRADE_ID
, JOB.JOB_ID JOB_ID
, OPM.ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID
, PA.PERSON_ID PERSON_ID
, PPM.PERSONAL_PAYMENT_METHOD_ID PERSONAL_PAYMENT_METHOD_ID
, POS.POSITION_ID POSITION_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_JOBS JOB
, PER_ALL_POSITIONS POS
, PER_GRADES GRD
, HR_LOCATIONS_ALL_TL LOCT
, PAY_PAYMENT_TYPES PT
, PAY_PAYMENT_TYPES_TL PTT
, PER_PEOPLE_X PP
, PAY_ORG_PAYMENT_METHODS_F OPM
, PER_ASSIGNMENTS_X PA
, PAY_EXTERNAL_ACCOUNTS PEA
, PAY_PERSONAL_PAYMENT_METHODS_F PPM
WHERE PPM.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID
AND OPM.PAYMENT_TYPE_ID = PT.PAYMENT_TYPE_ID
AND PT.PAYMENT_TYPE_ID = PTT.PAYMENT_TYPE_ID
AND PTT.LANGUAGE = USERENV('LANG')
AND PPM.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID
AND PPM.ASSIGNMENT_ID = PA.ASSIGNMENT_ID
AND PA.PERSON_ID = PP.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE
AND PA.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND PA.JOB_ID = JOB.JOB_ID(+)
AND PA.POSITION_ID = POS.POSITION_ID(+)
AND PA.GRADE_ID = GRD.GRADE_ID(+)
AND PA.LOCATION_ID = LOCT.LOCATION_ID(+)
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND PT.TERRITORY_CODE = 'US'
AND PA.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PA.BUSINESS_GROUP_ID) WITH READ ONLY

Columns