View: PAY_KR_SEP_RESULT_SLIP_YB_V

Product:	PAY - Payroll
Description:	This view returns Result Value for Subjected Yearly Bonus of Separation Pay Slip based on assignment_action_id.
Implementation/DBA Data:	APPS.PAY_KR_SEP_RESULT_SLIP_YB_V

View Text

SELECT /*+RULE*/ 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
, BPAA.ASSIGNMENT_ACTION_ID BASSIGNMENT_ACTION_ID
, BPAA.ACTION_SEQUENCE BACTION_SEQUENCE
, BPPA.EFFECTIVE_DATE BEFFECTIVE_DATE
, BPPA.DATE_EARNED BDATE_EARNED
, BPRT.RUN_TYPE_ID BRUN_TYPE_ID
, BPRT.RUN_TYPE_NAME BRUN_TYPE_NAME
, BPRTTL.RUN_TYPE_NAME UBRUN_TYPE_NAME
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE_ASG_RUN(BPAA.ASSIGNMENT_ACTION_ID
, BPBT.BALANCE_TYPE_ID) BEARNINGS_SUBJ_AVG
FROM PAY_RUN_TYPES_F_TL BPRTTL
, PAY_RUN_TYPES_F BPRT
, PAY_PAYROLL_ACTIONS BPPA
, PAY_ASSIGNMENT_ACTIONS BPAA
, PAY_BALANCE_TYPES BPBT
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND BPBT.BALANCE_NAME = 'EARNINGS_SUBJ_AVG'
AND BPBT.LEGISLATION_CODE = 'KR'
AND BPAA.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND BPAA.ACTION_SEQUENCE < PAA.ACTION_SEQUENCE
AND BPAA.ACTION_STATUS = 'C'
AND BPPA.PAYROLL_ACTION_ID = BPAA.PAYROLL_ACTION_ID
AND BPPA.EFFECTIVE_DATE BETWEEN ADD_MONTHS(PPA.EFFECTIVE_DATE -1
, -12)
AND (PPA.EFFECTIVE_DATE)
AND BPRT.RUN_TYPE_ID = BPAA.RUN_TYPE_ID
AND SUBSTR(BPRT.RUN_TYPE_NAME
, 1
, 3) = 'BON'
AND BPRT.RUN_TYPE_NAME <> 'BON_ALR'
AND BPPA.EFFECTIVE_DATE BETWEEN BPRT.EFFECTIVE_START_DATE
AND BPRT.EFFECTIVE_END_DATE
AND BPRTTL.RUN_TYPE_ID = BPRT.RUN_TYPE_ID
AND BPRTTL.LANGUAGE = USERENV('LANG')
AND EXISTS( SELECT NULL
FROM PAY_RUN_RESULT_VALUES BPRRV
, PAY_RUN_RESULTS BPRR
, PAY_BALANCE_FEEDS_F BPBF
WHERE BPBF.BALANCE_TYPE_ID = BPBT.BALANCE_TYPE_ID
AND BPPA.EFFECTIVE_DATE BETWEEN BPBF.EFFECTIVE_START_DATE
AND BPBF.EFFECTIVE_END_DATE
AND BPRR.ASSIGNMENT_ACTION_ID = BPAA.ASSIGNMENT_ACTION_ID
AND BPRRV.RUN_RESULT_ID = BPRR.RUN_RESULT_ID
AND BPRRV.INPUT_VALUE_ID = BPBF.INPUT_VALUE_ID)

Columns