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_SEP_RESULT_NET_V

Source

View Text - Preformatted


SELECT 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, pay_kr_report_pkg.get_balance_value(paa.assignment_action_id,'TOTAL_TAXABLE_EARNINGS','_ASG_RUN') total_taxable_earnings, pay_kr_report_pkg.get_balance_value(paa.assignment_action_id,'ITAX','_ASG_RUN') itax, pay_kr_report_pkg.get_balance_value(paa.assignment_action_id,'RTAX','_ASG_RUN') rtax, pay_kr_report_pkg.get_balance_value(paa.assignment_action_id,'STAX','_ASG_RUN') stax, pay_kr_report_pkg.get_balance_value(paa.assignment_action_id,'NP_PREM_FUND_REIMB','_ASG_ITD') np_prem_fund_reimb, pay_kr_report_pkg.get_balance_value(paa.assignment_action_id,'NET_PAY','_ASG_RUN') net_pay, pay_kr_report_pkg.get_balance_value(paa.assignment_action_id,'VOL_DEDUCTIONS','_ASG_RUN') vol_deductions, pay_kr_report_pkg.get_balance_value(paa.assignment_action_id,'INVOL_DEDUCTIONS','_ASG_RUN') invol_deductions, pay_kr_report_pkg.get_dbitem_value(paa.assignment_action_id,'KR_LIYEA_ITAX_ADJ') last_iyea_itax_adj, pay_kr_report_pkg.get_dbitem_value(paa.assignment_action_id,'KR_LIYEA_RTAX_ADJ') last_iyea_rtax_adj, pay_kr_report_pkg.get_dbitem_value(paa.assignment_action_id,'KR_LIYEA_STAX_ADJ') last_iyea_stax_adj, pay_kr_report_pkg.get_balance_value(paa.assignment_action_id,'Health Ins Sep Adj Employee Charge','_ASG_YTD') last_ihia_prem_ee_adj, pay_kr_report_pkg.get_balance_value(paa.assignment_action_id,'Health Ins Sep Adj Employer Charge', '_ASG_YTD') last_ihia_prem_er_adj from pay_payroll_actions ppa, pay_assignment_actions paa WHERE not exists ( select null from pay_run_types_f prt, pay_payroll_actions sppa, pay_assignment_actions spaa, pay_action_interlocks pai where pai.locking_action_id = paa.assignment_action_id and spaa.assignment_action_id = pai.locked_action_id and sppa.payroll_action_id = spaa.payroll_action_id and prt.run_type_id = spaa.run_type_id and sppa.effective_date between prt.effective_start_date and prt.effective_end_date and prt.run_type_name like 'SEP%' and prt.run_type_name <> 'SEP_L') and ppa.payroll_action_id = paa.payroll_action_id

View Text - HTML Formatted

SELECT 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
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'TOTAL_TAXABLE_EARNINGS'
, '_ASG_RUN') TOTAL_TAXABLE_EARNINGS
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'ITAX'
, '_ASG_RUN') ITAX
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'RTAX'
, '_ASG_RUN') RTAX
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'STAX'
, '_ASG_RUN') STAX
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'NP_PREM_FUND_REIMB'
, '_ASG_ITD') NP_PREM_FUND_REIMB
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'NET_PAY'
, '_ASG_RUN') NET_PAY
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'VOL_DEDUCTIONS'
, '_ASG_RUN') VOL_DEDUCTIONS
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'INVOL_DEDUCTIONS'
, '_ASG_RUN') INVOL_DEDUCTIONS
, PAY_KR_REPORT_PKG.GET_DBITEM_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'KR_LIYEA_ITAX_ADJ') LAST_IYEA_ITAX_ADJ
, PAY_KR_REPORT_PKG.GET_DBITEM_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'KR_LIYEA_RTAX_ADJ') LAST_IYEA_RTAX_ADJ
, PAY_KR_REPORT_PKG.GET_DBITEM_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'KR_LIYEA_STAX_ADJ') LAST_IYEA_STAX_ADJ
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'HEALTH INS SEP ADJ EMPLOYEE CHARGE'
, '_ASG_YTD') LAST_IHIA_PREM_EE_ADJ
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'HEALTH INS SEP ADJ EMPLOYER CHARGE'
, '_ASG_YTD') LAST_IHIA_PREM_ER_ADJ
FROM PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE NOT EXISTS ( SELECT NULL
FROM PAY_RUN_TYPES_F PRT
, PAY_PAYROLL_ACTIONS SPPA
, PAY_ASSIGNMENT_ACTIONS SPAA
, PAY_ACTION_INTERLOCKS PAI
WHERE PAI.LOCKING_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND SPAA.ASSIGNMENT_ACTION_ID = PAI.LOCKED_ACTION_ID
AND SPPA.PAYROLL_ACTION_ID = SPAA.PAYROLL_ACTION_ID
AND PRT.RUN_TYPE_ID = SPAA.RUN_TYPE_ID
AND SPPA.EFFECTIVE_DATE BETWEEN PRT.EFFECTIVE_START_DATE
AND PRT.EFFECTIVE_END_DATE
AND PRT.RUN_TYPE_NAME LIKE 'SEP%'
AND PRT.RUN_TYPE_NAME <> 'SEP_L')
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID