VIEW: APPS.PAY_KR_SEP_RESULT_RR_V

Source

View Text - Preformatted

SELECT paa.assignment_action_id assignment_action_id, paa.assignment_id assignment_id, ppa.effective_date effective_date, ppa.date_earned date_earned, paa.run_type_id run_type_id, prr.run_result_id run_result_id, prr.entry_type entry_type, prr.source_id source_id, prr.source_type source_type, pet.element_type_id element_type_id, pet.element_name element_name, petl.element_name uelement_name, pet.processing_priority processing_priority, 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 petl, pay_element_types_f pet, pay_run_results prr, pay_payroll_actions ppa, pay_assignment_actions paa where not exists( select null from pay_run_types_f prt, pay_payroll_actions sppa, pay_assignment_actions spaa, pay_action_interlocks pai where pai.locking_action_id = paa.assignment_action_id and spaa.assignment_action_id = pai.locked_action_id and sppa.payroll_action_id = spaa.payroll_action_id and prt.run_type_id = spaa.run_type_id and sppa.effective_date between prt.effective_start_date and prt.effective_end_date and prt.run_type_name like 'SEP%') and ppa.payroll_action_id = paa.payroll_action_id and prr.assignment_action_id = paa.assignment_action_id and pet.element_type_id = prr.element_type_id and ppa.date_earned between pet.effective_start_date and pet.effective_end_date and petl.element_type_id = pet.element_type_id and petl.language = userenv('LANG') and pec.classification_id = pet.classification_id and pectl.classification_id = pec.classification_id and pectl.language = userenv('LANG')

View Text - HTML Formatted

SELECT PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE EFFECTIVE_DATE
, PPA.DATE_EARNED DATE_EARNED
, PAA.RUN_TYPE_ID RUN_TYPE_ID
, PRR.RUN_RESULT_ID RUN_RESULT_ID
, PRR.ENTRY_TYPE ENTRY_TYPE
, PRR.SOURCE_ID SOURCE_ID
, PRR.SOURCE_TYPE SOURCE_TYPE
, PET.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, PET.ELEMENT_NAME ELEMENT_NAME
, PETL.ELEMENT_NAME UELEMENT_NAME
, PET.PROCESSING_PRIORITY PROCESSING_PRIORITY
, 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 PETL
, PAY_ELEMENT_TYPES_F PET
, PAY_RUN_RESULTS PRR
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE NOT EXISTS( SELECT NULL
FROM PAY_RUN_TYPES_F PRT
, PAY_PAYROLL_ACTIONS SPPA
, PAY_ASSIGNMENT_ACTIONS SPAA
, PAY_ACTION_INTERLOCKS PAI
WHERE PAI.LOCKING_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND SPAA.ASSIGNMENT_ACTION_ID = PAI.LOCKED_ACTION_ID
AND SPPA.PAYROLL_ACTION_ID = SPAA.PAYROLL_ACTION_ID
AND PRT.RUN_TYPE_ID = SPAA.RUN_TYPE_ID
AND SPPA.EFFECTIVE_DATE BETWEEN PRT.EFFECTIVE_START_DATE
AND PRT.EFFECTIVE_END_DATE
AND PRT.RUN_TYPE_NAME LIKE 'SEP%')
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PET.ELEMENT_TYPE_ID = PRR.ELEMENT_TYPE_ID
AND PPA.DATE_EARNED BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PETL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PETL.LANGUAGE = USERENV('LANG')
AND PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID
AND PECTL.CLASSIFICATION_ID = PEC.CLASSIFICATION_ID
AND PECTL.LANGUAGE = USERENV('LANG')