View: PAY_GB_STUDENT_LOANS_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_GB_STUDENT_LOANS_V

View Text

SELECT DISTINCT ELE.ELEMENT_TYPE_ID
, ENT.ELEMENT_ENTRY_ID
, LNK.ELEMENT_LINK_ID
, ELE.ELEMENT_NAME
, IPV1.INPUT_VALUE_ID START_DATE_IPV_ID
, EEV1.SCREEN_ENTRY_VALUE START_DATE
, SUBSTR(CL1.MEANING
, INSTR(CL1.MEANING
, '(')+1
, (INSTR(CL1.MEANING
, ')')-INSTR(CL1.MEANING
, '('))-1) IPV_DATE_FORMAT
, IPV1.INPUT_VALUE_ID END_DATE_IPV_ID
, EEV2.SCREEN_ENTRY_VALUE END_DATE
, ENT.SUBPRIORITY
, ENT.ASSIGNMENT_ID
, ENT.EFFECTIVE_START_DATE
, ENT.EFFECTIVE_END_DATE
, ENT.OBJECT_VERSION_NUMBER
FROM PAY_ELEMENT_ENTRY_VALUES_F EEV1
, HR_LOOKUPS CL1
, PAY_ELEMENT_ENTRY_VALUES_F EEV2
, PAY_ELEMENT_ENTRIES_F ENT
, PAY_ELEMENT_LINKS_F LNK
, PAY_INPUT_VALUES_F IPV1
, PAY_INPUT_VALUES_F IPV2
, PAY_ELEMENT_TYPES_F ELE
, FND_SESSIONS SES
WHERE ELE.ELEMENT_NAME = 'STUDENT LOAN'
AND IPV1.UOM = CL1.LOOKUP_CODE
AND CL1.LOOKUP_TYPE = 'UNITS'
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN ENT.EFFECTIVE_START_DATE
AND ENT.EFFECTIVE_END_DATE
AND LNK.ELEMENT_TYPE_ID = ELE.ELEMENT_TYPE_ID
AND ENT.ELEMENT_LINK_ID = LNK.ELEMENT_LINK_ID
AND ENT.ELEMENT_ENTRY_ID = EEV1.ELEMENT_ENTRY_ID
AND ENT.ELEMENT_ENTRY_ID = EEV2.ELEMENT_ENTRY_ID
AND EEV1.INPUT_VALUE_ID = IPV1.INPUT_VALUE_ID
AND IPV1.ELEMENT_TYPE_ID = ELE.ELEMENT_TYPE_ID
AND IPV1.NAME ='START DATE'
AND EEV2.INPUT_VALUE_ID = IPV2.INPUT_VALUE_ID
AND IPV2.ELEMENT_TYPE_ID = ELE.ELEMENT_TYPE_ID
AND IPV2.NAME ='END DATE'
AND SES.EFFECTIVE_DATE BETWEEN EEV1.EFFECTIVE_START_DATE
AND EEV1.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV2.EFFECTIVE_START_DATE
AND EEV2.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN IPV1.EFFECTIVE_START_DATE
AND IPV1.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN IPV2.EFFECTIVE_START_DATE
AND IPV2.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN LNK.EFFECTIVE_START_DATE
AND LNK.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN ELE.EFFECTIVE_START_DATE
AND ELE.EFFECTIVE_END_DATE

Columns