View: PAY_KR_SEPL_LIAB_SUMMARY_V

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

View Text

SELECT PAA.ASSIGNMENT_ID
, PCVF.PROPORTION
, PAA.ASSIGNMENT_ACTION_ID
, PPA.TIME_PERIOD_ID
, PAAF.ESTABLISHMENT_ID
, PPA.BUSINESS_GROUP_ID
, HOI.ORG_INFORMATION1 ESTABLISHMENT_NAME
, PAAF.GRADE_ID GRADE_ID
, PGT.NAME GRADE_NAME
, PPA.EFFECTIVE_DATE
, PM.PAYROLL_ID
, ((PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'AVERAGE_SALARY'
, '_ASG_RUN')) * NVL(PCVF.PROPORTION
, 1)) AVG_SAL
, ((PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'SEP_PAY'
, '_ASG_RUN')) * NVL(PCVF.PROPORTION
, 1))SEP_PAY
, ((PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'WKPD_SEP_PAY'
, '_ASG_RUN')) * NVL(PCVF.PROPORTION
, 1)) WORKING_PERIOD
, ((PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'PAYMENT_DAYS'
, '_ASG_RUN')) * NVL(PCVF.PROPORTION
, 1)) PAYMENT_DAYS
, (PAY_KR_FF_FUNCTIONS_PKG.GET_LEGISLATIVE_PARAMETER(PPA.PAYROLL_ACTION_ID
, 'LIABILITY_RATE'
, 0))LIABILITY_RATE
, 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_PAYROLL_ACTIONS PPA
, HR_ORGANIZATION_INFORMATION HOI
, PER_GRADES_TL PGT
, PAY_COST_ALLOCATION_KEYFLEX PKV
, FND_SEGMENT_ATTRIBUTE_VALUES FSAV
, PAY_PAYROLL_GL_FLEX_MAPS PM
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_COST_ALLOCATIONS_F PCVF
, PAY_RUN_TYPES_F PRT
, PER_ASSIGNMENTS_F PAAF
, PAY_PAYROLLS_F PPF
, GL_SETS_OF_BOOKS GSB
WHERE 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 PAA.TAX_UNIT_ID = HOI.ORGANIZATION_ID
AND HOI.ORG_INFORMATION_CONTEXT = 'KR_BUSINESS_PLACE_REGISTRATION'
AND PAAF.GRADE_ID = PGT.GRADE_ID(+)
AND PGT.LANGUAGE (+) = USERENV('LANG')
AND PAAF.ASSIGNMENT_ID = PAA.ASSIGNMENT_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 PRT.LEGISLATION_CODE = 'KR'
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 PRT.RUN_TYPE_ID = PAA.RUN_TYPE_ID
AND PRT.RUN_TYPE_NAME = 'SEP_L'
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 PPF.EFFECTIVE_START_DATE
AND PPF.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