VIEW: APPS.PAY_KR_YER_PROCESS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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