VIEW: APPS.PAY_KR_SEP_ARCHIVE_V

Source

View Text - Preformatted

SELECT xpaa.assignment_action_id assignment_action_id, xpaa.assignment_id assignment_id, xppa.effective_date effective_date, paa.assignment_action_id sassignment_action_id, ppa.effective_date seffective_date, ppa.date_earned sdate_earnd, prt.run_type_id run_type_id, fue.user_entity_id user_entity_id, fue.route_id route_id, fdi.user_name user_name, fdi.data_type data_type, hr_general.decode_lookup('DATA_TYPE',fdi.data_type) udata_type, fai.archive_item_id archive_item_id, fai.value value from ff_database_items fdi, ff_user_entities fue, ff_archive_items fai, pay_run_types_f prt, pay_payroll_actions ppa, pay_assignment_actions paa, pay_action_interlocks pai, pay_payroll_actions xppa, pay_assignment_actions xpaa where xpaa.action_status = 'C' and xppa.payroll_action_id = xpaa.payroll_action_id and pai.locking_action_id = xpaa.assignment_action_id and paa.assignment_action_id = pai.locked_action_id and ppa.payroll_action_id = paa.payroll_action_id and prt.run_type_id = paa.run_type_id and prt.run_type_name like 'SEP%' and ppa.effective_date between prt.effective_start_date and prt.effective_end_date and fai.context1 = xpaa.assignment_action_id and fue.user_entity_id = fai.user_entity_id and fue.legislation_code = pay_kr_report_pkg.legislation_code(ppa.business_group_id) and fue.creator_type = 'X' and fdi.user_entity_id = fue.user_entity_id

View Text - HTML Formatted

SELECT XPAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, XPAA.ASSIGNMENT_ID ASSIGNMENT_ID
, XPPA.EFFECTIVE_DATE EFFECTIVE_DATE
, PAA.ASSIGNMENT_ACTION_ID SASSIGNMENT_ACTION_ID
, PPA.EFFECTIVE_DATE SEFFECTIVE_DATE
, PPA.DATE_EARNED SDATE_EARND
, PRT.RUN_TYPE_ID RUN_TYPE_ID
, FUE.USER_ENTITY_ID USER_ENTITY_ID
, FUE.ROUTE_ID ROUTE_ID
, FDI.USER_NAME USER_NAME
, FDI.DATA_TYPE DATA_TYPE
, HR_GENERAL.DECODE_LOOKUP('DATA_TYPE'
, FDI.DATA_TYPE) UDATA_TYPE
, FAI.ARCHIVE_ITEM_ID ARCHIVE_ITEM_ID
, FAI.VALUE VALUE
FROM FF_DATABASE_ITEMS FDI
, FF_USER_ENTITIES FUE
, FF_ARCHIVE_ITEMS FAI
, PAY_RUN_TYPES_F PRT
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_ACTION_INTERLOCKS PAI
, PAY_PAYROLL_ACTIONS XPPA
, PAY_ASSIGNMENT_ACTIONS XPAA
WHERE XPAA.ACTION_STATUS = 'C'
AND XPPA.PAYROLL_ACTION_ID = XPAA.PAYROLL_ACTION_ID
AND PAI.LOCKING_ACTION_ID = XPAA.ASSIGNMENT_ACTION_ID
AND PAA.ASSIGNMENT_ACTION_ID = PAI.LOCKED_ACTION_ID
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PRT.RUN_TYPE_ID = PAA.RUN_TYPE_ID
AND PRT.RUN_TYPE_NAME LIKE 'SEP%'
AND PPA.EFFECTIVE_DATE BETWEEN PRT.EFFECTIVE_START_DATE
AND PRT.EFFECTIVE_END_DATE
AND FAI.CONTEXT1 = XPAA.ASSIGNMENT_ACTION_ID
AND FUE.USER_ENTITY_ID = FAI.USER_ENTITY_ID
AND FUE.LEGISLATION_CODE = PAY_KR_REPORT_PKG.LEGISLATION_CODE(PPA.BUSINESS_GROUP_ID)
AND FUE.CREATOR_TYPE = 'X'
AND FDI.USER_ENTITY_ID = FUE.USER_ENTITY_ID