eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_GB_STUDENT_LOANS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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