View: PAY_KR_SEP_LIAB_DETAIL_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_KR_SEP_LIAB_DETAIL_V

View Text

SELECT PAA.ASSIGNMENT_ID ASSIGNMENT_ID
, PET.REPORTING_NAME ELEMENT_NAME
, PET.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, NVL(TO_NUMBER(PAY_KR_REPORT_PKG.GET_RESULT_VALUE(PRR.RUN_RESULT_ID
, PIV.INPUT_VALUE_ID))
, 0) RESULT_VALUE
, PAPF.FULL_NAME EMPLOYEE_NAME
, PAPF.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PPA.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PPA.TIME_PERIOD_ID TIME_PERIOD_ID
, PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PPA.PAYROLL_ID PAYROLL_ID
, PPOS.DATE_START DATE_START
, PGR.NAME GRADE_NAME
, HOI.ORG_INFORMATION1 ESTABLISHMENT_NAME
, HOI.ORGANIZATION_ID ESTABLISHMENT_ID
, NVL(PCVF.PROPORTION
, 1) PROPORTION
, PAY_KR_REPORT_PKG.GET_RESULT_VALUE_NUMBER(PAA.ASSIGNMENT_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, 'YBON_SUBJ_AVG'
, 'AMOUNT') * NVL(PCVF.PROPORTION
, 1) YEARLY_BONUS
, PAY_KR_REPORT_PKG.GET_RESULT_VALUE_NUMBER(PAA.ASSIGNMENT_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, 'ALR_SUBJ_AVG'
, 'AMOUNT') * NVL(PCVF.PROPORTION
, 1) ALR
, PAY_KR_REPORT_PKG.GET_RESULT_VALUE_CHAR(PAA.ASSIGNMENT_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, 'WKPD'
, 'WKPD') WORKING_PERIOD
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'AVERAGE_SALARY_ME'
, '_ASG_RUN') * NVL(PCVF.PROPORTION
, 1) AVERAGE_SALARY_ME
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'AVERAGE_SALARY_YBON'
, '_ASG_RUN') * NVL(PCVF.PROPORTION
, 1) AVERAGE_SALARY_YBON
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'AVERAGE_SALARY_ALR'
, '_ASG_RUN')* NVL(PCVF.PROPORTION
, 1) AVERAGE_SALARY_ALR
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'SEP_PAY'
, '_ASG_RUN') * NVL(PCVF.PROPORTION
, 1) SEPARATION_PAY
, DECODE(PAY_KR_REPORT_PKG.GET_RESULT_VALUE_DATE(PAA.ASSIGNMENT_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, 'WKPD'
, 'L_DATE')
, NULL
, PPOS.ACTUAL_TERMINATION_DATE
, PAY_KR_REPORT_PKG.GET_RESULT_VALUE_DATE(PAA.ASSIGNMENT_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, 'WKPD'
, 'L_DATE')) SEPARATION_DATE
, PAY_KR_FF_FUNCTIONS_PKG.GET_LEGISLATIVE_PARAMETER(PPA.PAYROLL_ACTION_ID
, 'LIABILITY_RATE'
, 0) LIABILITY_RATE
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'PAYMENT_DAYS'
, '_ASG_RUN') * NVL(PCVF.PROPORTION
, 1) PAYMENT_DAYS
, DECODE(PM.PAYROLL_COST_SEGMENT
, 'SEGMENT1'
, PKV.SEGMENT1
, 'SEGMENT2'
, PKV.SEGMENT2
, 'SEGMENT3'
, PKV.SEGMENT3
, 'SEGMENT4'
, PKV.SEGMENT4
, 'SEGMENT5'
, PKV.SEGMENT5
, 'SEGMENT6'
, PKV.SEGMENT6
, 'SEGMENT7'
, PKV.SEGMENT7
, 'SEGMENT8'
, PKV.SEGMENT8
, 'SEGMENT9'
, PKV.SEGMENT9
, 'SEGMENT10'
, PKV.SEGMENT10
, 'SEGMENT11'
, PKV.SEGMENT11
, 'SEGMENT12'
, PKV.SEGMENT12
, 'SEGMENT13'
, PKV.SEGMENT13
, 'SEGMENT14'
, PKV.SEGMENT14
, 'SEGMENT15'
, PKV.SEGMENT15
, 'SEGMENT16'
, PKV.SEGMENT16
, 'SEGMENT17'
, PKV.SEGMENT17
, 'SEGMENT18'
, PKV.SEGMENT18
, 'SEGMENT19'
, PKV.SEGMENT19) COST_CENTER
FROM PAY_BALANCE_FEEDS_F PBF
, PAY_INPUT_VALUES_F PIV
, PAY_ELEMENT_TYPES_F PET
, PAY_RUN_RESULTS PRR
, PAY_PAYROLL_ACTIONS PPA
, HR_ORGANIZATION_INFORMATION HOI
, PER_GRADES PGR
, PAY_COST_ALLOCATION_KEYFLEX PKV
, FND_SEGMENT_ATTRIBUTE_VALUES FSAV
, PAY_COST_ALLOCATIONS_F PCVF
, PAY_PAYROLL_GL_FLEX_MAPS PM
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_RUN_TYPES_F PRT
, PER_ASSIGNMENTS_F PAAF
, PAY_PAYROLLS_F PPF
, PER_PERIODS_OF_SERVICE PPOS
, PER_PEOPLE_F PAPF
, GL_SETS_OF_BOOKS GSB
WHERE PBF.BALANCE_TYPE_ID = (SELECT BALANCE_TYPE_ID
FROM PAY_BALANCE_TYPES
WHERE BALANCE_NAME = 'EARNINGS_SUBJ_AVG'
AND LEGISLATION_CODE ='KR')
AND PBF.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PIV.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PRR.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID
AND PPA.RUN_TYPE_ID = PRT.RUN_TYPE_ID
AND PRT.RUN_TYPE_ID = PAA.RUN_TYPE_ID
AND PRT.RUN_TYPE_NAME = 'SEP_L'
AND PRT.LEGISLATION_CODE = 'KR'
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PPA.BUSINESS_GROUP_ID = PAAF.BUSINESS_GROUP_ID
AND PPA.PAYROLL_ID = PM.PAYROLL_ID
AND PPA.PAYROLL_ID = PPF.PAYROLL_ID
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PAPF.PERSON_ID = PAAF.PERSON_ID
AND PAPF.PERSON_ID = PPOS.PERSON_ID
AND PAA.TAX_UNIT_ID = HOI.ORGANIZATION_ID
AND HOI.ORGANIZATION_ID = PAAF.ESTABLISHMENT_ID
AND HOI.ORG_INFORMATION_CONTEXT = 'KR_BUSINESS_PLACE_REGISTRATION'
AND PAAF.GRADE_ID = PGR.GRADE_ID(+)
AND PAAF.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PAAF.PAYROLL_ID = PPA.PAYROLL_ID
AND PPF.PAYROLL_ID = PAAF.PAYROLL_ID
AND PAA.ASSIGNMENT_ID = PCVF.ASSIGNMENT_ID(+)
AND PCVF.COST_ALLOCATION_KEYFLEX_ID = PKV.COST_ALLOCATION_KEYFLEX_ID(+)
AND FSAV.APPLICATION_COLUMN_NAME = PM.GL_ACCOUNT_SEGMENT
AND FSAV.APPLICATION_ID = 101
AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'FA_COST_CTR'
AND FSAV.ATTRIBUTE_VALUE = 'Y'
AND FSAV.ID_FLEX_CODE = 'GL#'
AND (PKV.ID_FLEX_NUM = FSAV.ID_FLEX_NUM OR PKV.ID_FLEX_NUM IS NULL)
AND PPF.GL_SET_OF_BOOKS_ID = PM.GL_SET_OF_BOOKS_ID
AND PPF.GL_SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID
AND GSB.CHART_OF_ACCOUNTS_ID = FSAV.ID_FLEX_NUM
AND (PAY_KR_FF_FUNCTIONS_PKG.GET_LEGISLATIVE_PARAMETER(PPA.PAYROLL_ACTION_ID
, 'LIABILITY_RATE'
, 0)) <> 0
AND PPA.EFFECTIVE_DATE BETWEEN PAAF.EFFECTIVE_START_DATE
AND PAAF.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN PRT.EFFECTIVE_START_DATE
AND PRT.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN NVL(PCVF.EFFECTIVE_START_DATE
, PPA.EFFECTIVE_DATE)
AND NVL(PCVF.EFFECTIVE_END_DATE
, PPA.EFFECTIVE_DATE)

Columns