View: PAY_KR_YER_PROCESS_V

Product:	PAY - Payroll
Description:	This view returns YEA process type, processed Year information from payroll action table based on assignment_id.
Implementation/DBA Data:	APPS.PAY_KR_YER_PROCESS_V

View Text

SELECT SUBSTR(TO_CHAR(PPA.EFFECTIVE_DATE
, 'YYYY-MON-DD')
, 1
, 4) || ' ' || SUBSTR( HR_GENERAL.DECODE_LOOKUP('KR_YEA_TYPE'
, PPA.REPORT_CATEGORY)
, 1
, 80) YEA_PROCESS
, SUBSTR(TO_CHAR(PPA.EFFECTIVE_DATE
, 'YYYY-MON-DD')
, 1
, 4) YEAR
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('KR_YEA_TYPE'
, PPA.REPORT_CATEGORY)
, 1
, 80) TYPE
, PAA.ASSIGNMENT_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.PAYROLL_ACTION_ID
, PPA.PAYROLL_ID
FROM PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE PAA.ACTION_STATUS = 'C'
AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE = 'B'
AND PPA.REPORT_TYPE = 'YEA'
AND PPA.REPORT_QUALIFIER = 'KR' ORDER BY PAA.ASSIGNMENT_ACTION_ID DESC
, PPA.EFFECTIVE_DATE DESC

Columns