View: HRFV_PAY_METH_NOT_DIR_DEPOSITS

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PER.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
, HR_BIS.BIS_DECODE_LOOKUP('PAYEE_TYPE'
, PPM.PAYEE_TYPE) PAYEE_TYPE
, DECODE(PPM.PAYEE_TYPE
, 'O'
, PORGT.NAME
, 'P'
, PER.FULL_NAME
, NULL) PAYEE_NAME
, 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
, PER.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, '_DF:PAY:PAY_PERSONAL_PAYMENT_METHODS:PPM'
, PA.ASSIGNMENT_ID ASSIGNMENT_ID
, PA.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, OPM.ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID
, PA.PERSON_ID PERSON_ID
, PPM.PERSONAL_PAYMENT_METHOD_ID PERSONAL_PAYMENT_METHOD_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL PORGT
, 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_TL PTT
, PER_PEOPLE_X PER
, PAY_ORG_PAYMENT_METHODS_F OPM
, PER_ASSIGNMENTS_X PA
, PAY_PERSONAL_PAYMENT_METHODS_F PPM
WHERE PPM.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID
AND OPM.PAYMENT_TYPE_ID = PTT.PAYMENT_TYPE_ID
AND PTT.LANGUAGE = USERENV('LANG')
AND PPM.PAYEE_ID = PORGT.ORGANIZATION_ID(+)
AND PORGT.LANGUAGE (+) = USERENV('LANG')
AND PPM.PAYEE_ID = PER.PERSON_ID(+)
AND PPM.ASSIGNMENT_ID = PA.ASSIGNMENT_ID
AND PA.PERSON_ID = PER.PERSON_ID
AND PPM.EXTERNAL_ACCOUNT_ID IS NULL
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 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