Product: | CE - Cash Management |
---|---|
Description: | A supplementary view used to simplify forms coding. Used by Bank Account Signatory form |
Implementation/DBA Data: | APPS.CE_BA_SIGNATORIES_V |
SELECT BASIG.ROWID
, BASIG.SIGNATORY_ID
, BASIG.BANK_ACCOUNT_ID
, BASIG.PERSON_ID
, PPF.FULL_NAME
, HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE (SYSDATE
, PPF.PERSON_ID) PERSON_TYPE
, DECODE(PAAF.ORGANIZATION_ID
, NULL
, NULL
, HR_GENERAL.DECODE_ORGANIZATION(PAAF.ORGANIZATION_ID))
, DECODE(PAAF.JOB_ID
, NULL
, NULL
, HR_GENERAL.DECODE_JOB (PAAF.JOB_ID))
, PPF.INTERNAL_LOCATION
, PPF.EMAIL_ADDRESS
, BASIG.SINGLE_LIMIT_AMOUNT
, BASIG.JOINT_LIMIT_AMOUNT
, BASIG.SIGNER_GROUP
, BASIG.OTHER_LIMITS
, BASIG.START_DATE
, BASIG.END_DATE
, BASIG.STATUS
, BASIG.APPROVAL_TYPE_FLAG
, BASIG.REQUESTER_ID
, BASIG.CREATED_BY
, BASIG.CREATION_DATE
, BASIG.LAST_UPDATED_BY
, BASIG.LAST_UPDATE_DATE
, BASIG.LAST_UPDATE_LOGIN
, BASIG.ATTRIBUTE_CATEGORY
, BASIG.ATTRIBUTE1
, BASIG.ATTRIBUTE2
, BASIG.ATTRIBUTE3
, BASIG.ATTRIBUTE4
, BASIG.ATTRIBUTE5
, BASIG.ATTRIBUTE6
, BASIG.ATTRIBUTE7
, BASIG.ATTRIBUTE8
, BASIG.ATTRIBUTE9
, BASIG.ATTRIBUTE10
, BASIG.ATTRIBUTE11
, BASIG.ATTRIBUTE12
, BASIG.ATTRIBUTE13
, BASIG.ATTRIBUTE14
, BASIG.ATTRIBUTE15
FROM CE_BA_SIGNATORIES BASIG
, PER_PEOPLE_F PPF
, PER_ALL_ASSIGNMENTS_F PAAF
WHERE BASIG.PERSON_ID = PPF.PERSON_ID
AND BASIG.DELETED_FLAG = 'N'
AND PPF.PERSON_ID = PAAF.PERSON_ID(+)
AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN PAAF.EFFECTIVE_START_DATE(+)
AND PAAF.EFFECTIVE_END_DATE(+)
AND PAAF.ASSIGNMENT_TYPE (+) <> 'B'
AND PAAF.PRIMARY_FLAG (+) = 'Y'