eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_KR_SEPL_LIAB_SUMMARY_V

Source

View Text - Preformatted


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)

View Text - HTML Formatted

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)