VIEW: APPS.PAY_KR_SEP_MASTER_EE_V

Source

View Text - Preformatted

SELECT pee.assignment_id assignment_id ,pee.element_entry_id element_entry_id ,pee.effective_start_date effective_start_date ,pee.effective_end_date effective_end_date ,pee.creator_id creator_id ,pee.creator_type creator_type ,pee.object_version_number object_version_number ,pet.element_type_id element_type_id ,pet.effective_start_date teffective_start_date ,pet.effective_end_date teffective_end_date ,pet.element_name element_name ,pet.processing_priority processing_priority ,pettl.element_name uelement_name ,pel.element_link_id element_link_id ,pel.effective_start_date leffective_start_date ,pel.effective_end_date leffective_end_date ,pec.classification_id classification_id ,pec.classification_name classification_name ,pectl.classification_name uclassification_name FROM pay_element_classifications_tl pectl ,pay_element_classifications pec ,pay_element_types_f_tl pettl ,pay_element_types_f pet ,pay_element_links_f pel ,pay_element_entries_f pee ,fnd_sessions fs WHERE fs.session_id = userenv('sessionid') AND pee.creator_type in ('F','H') AND pec.legislation_code = 'KR' AND fs.effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date AND pel.element_link_id = pee.element_link_id AND fs.effective_date between pel.effective_start_date AND pel.effective_end_date AND pet.element_type_id = pel.element_type_id AND fs.effective_date between pet.effective_start_date AND pet.effective_end_date AND pettl.element_type_id = pet.element_type_id AND pettl.language = userenv('LANG') AND pec.classification_id = pet.classification_id AND pectl.classification_id = pec.classification_id AND pectl.language = userenv('LANG') AND not exists ( SELECT NULL FROM pay_run_types_f prt_sep, pay_run_types_f prt_sepi, pay_element_type_usages_f petu_sep, pay_element_type_usages_f petu_sepi WHERE petu_sep.element_type_id = pet.element_type_id AND petu_sepi.element_type_id = pet.element_type_id AND fs.effective_date between petu_sep.effective_start_date AND petu_sep.effective_end_date AND fs.effective_date between petu_sepi.effective_start_date AND petu_sepi.effective_end_date AND nvl(petu_sep.inclusion_flag, 'N') = 'N' AND nvl(petu_sepi.inclusion_flag, 'N') = 'N' AND prt_sep.run_type_id = petu_sep.run_type_id AND prt_sepi.run_type_id = petu_sepi.run_type_id AND fs.effective_date between prt_sep.effective_start_date AND prt_sep.effective_end_date AND fs.effective_date between prt_sepi.effective_start_date AND prt_sepi.effective_end_date AND prt_sep.run_type_name in ('SEP') AND prt_sepi.run_type_name in ('SEP_I') )

View Text - HTML Formatted

SELECT PEE.ASSIGNMENT_ID ASSIGNMENT_ID
, PEE.ELEMENT_ENTRY_ID ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PEE.CREATOR_ID CREATOR_ID
, PEE.CREATOR_TYPE CREATOR_TYPE
, PEE.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PET.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, PET.EFFECTIVE_START_DATE TEFFECTIVE_START_DATE
, PET.EFFECTIVE_END_DATE TEFFECTIVE_END_DATE
, PET.ELEMENT_NAME ELEMENT_NAME
, PET.PROCESSING_PRIORITY PROCESSING_PRIORITY
, PETTL.ELEMENT_NAME UELEMENT_NAME
, PEL.ELEMENT_LINK_ID ELEMENT_LINK_ID
, PEL.EFFECTIVE_START_DATE LEFFECTIVE_START_DATE
, PEL.EFFECTIVE_END_DATE LEFFECTIVE_END_DATE
, PEC.CLASSIFICATION_ID CLASSIFICATION_ID
, PEC.CLASSIFICATION_NAME CLASSIFICATION_NAME
, PECTL.CLASSIFICATION_NAME UCLASSIFICATION_NAME
FROM PAY_ELEMENT_CLASSIFICATIONS_TL PECTL
, PAY_ELEMENT_CLASSIFICATIONS PEC
, PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_ENTRIES_F PEE
, FND_SESSIONS FS
WHERE FS.SESSION_ID = USERENV('SESSIONID')
AND PEE.CREATOR_TYPE IN ('F'
, 'H')
AND PEC.LEGISLATION_CODE = 'KR'
AND FS.EFFECTIVE_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND PEL.ELEMENT_LINK_ID = PEE.ELEMENT_LINK_ID
AND FS.EFFECTIVE_DATE BETWEEN PEL.EFFECTIVE_START_DATE
AND PEL.EFFECTIVE_END_DATE
AND PET.ELEMENT_TYPE_ID = PEL.ELEMENT_TYPE_ID
AND FS.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PETTL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV('LANG')
AND PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID
AND PECTL.CLASSIFICATION_ID = PEC.CLASSIFICATION_ID
AND PECTL.LANGUAGE = USERENV('LANG')
AND NOT EXISTS ( SELECT NULL
FROM PAY_RUN_TYPES_F PRT_SEP
, PAY_RUN_TYPES_F PRT_SEPI
, PAY_ELEMENT_TYPE_USAGES_F PETU_SEP
, PAY_ELEMENT_TYPE_USAGES_F PETU_SEPI
WHERE PETU_SEP.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PETU_SEPI.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND FS.EFFECTIVE_DATE BETWEEN PETU_SEP.EFFECTIVE_START_DATE
AND PETU_SEP.EFFECTIVE_END_DATE
AND FS.EFFECTIVE_DATE BETWEEN PETU_SEPI.EFFECTIVE_START_DATE
AND PETU_SEPI.EFFECTIVE_END_DATE
AND NVL(PETU_SEP.INCLUSION_FLAG
, 'N') = 'N'
AND NVL(PETU_SEPI.INCLUSION_FLAG
, 'N') = 'N'
AND PRT_SEP.RUN_TYPE_ID = PETU_SEP.RUN_TYPE_ID
AND PRT_SEPI.RUN_TYPE_ID = PETU_SEPI.RUN_TYPE_ID
AND FS.EFFECTIVE_DATE BETWEEN PRT_SEP.EFFECTIVE_START_DATE
AND PRT_SEP.EFFECTIVE_END_DATE
AND FS.EFFECTIVE_DATE BETWEEN PRT_SEPI.EFFECTIVE_START_DATE
AND PRT_SEPI.EFFECTIVE_END_DATE
AND PRT_SEP.RUN_TYPE_NAME IN ('SEP')
AND PRT_SEPI.RUN_TYPE_NAME IN ('SEP_I') )