VIEW: APPS.CE_BA_SIGNATORIES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'