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_CA_FED_ER_V

Source

View Text - Preformatted


SELECT paa.assignment_id , paa.tax_unit_id , paa.assignment_action_id , paa.action_status , ppa.payroll_action_id , ppa.action_type , ppa.effective_date , pbs.attribute_1 base_balance_name , pbttl.balance_name balance_name, pbttl.reporting_name reporting_name , pbs.business_group_id , pbs.legislation_code , pay_ca_balance_pkg.call_ca_balance_get_value( pbs.attribute_1 ,'CURRENT' ,paa.assignment_action_id ,paa.assignment_id ,ppa.effective_date ,pay_ca_balance_view_pkg.get_session_var('REPORT_LEVEL') ,paa.tax_unit_id ,pay_ca_balance_view_pkg.get_session_var('BUSINESS_GROUP') ) CURRENT_VALUE , pay_ca_balance_pkg.call_ca_balance_get_value( pbs.attribute_1 ,'RUN' ,paa.assignment_action_id ,paa.assignment_id ,ppa.effective_date ,pay_ca_balance_view_pkg.get_session_var('REPORT_LEVEL') ,paa.tax_unit_id ,pay_ca_balance_view_pkg.get_session_var('BUSINESS_GROUP') ) RUN_VALUE , pay_ca_balance_pkg.call_ca_balance_get_value( pbs.attribute_1 ,'PYDATE' ,paa.assignment_action_id ,paa.assignment_id ,ppa.effective_date ,pay_ca_balance_view_pkg.get_session_var('REPORT_LEVEL') ,paa.tax_unit_id ,pay_ca_balance_view_pkg.get_session_var('BUSINESS_GROUP') ) PYDATE_VALUE , pay_ca_balance_pkg.call_ca_balance_get_value( pbs.attribute_1 ,'MONTH' ,paa.assignment_action_id ,paa.assignment_id ,ppa.effective_date ,pay_ca_balance_view_pkg.get_session_var('REPORT_LEVEL') ,paa.tax_unit_id ,pay_ca_balance_view_pkg.get_session_var('BUSINESS_GROUP') ) MONTH_VALUE , pay_ca_balance_pkg.call_ca_balance_get_value( pbs.attribute_1 ,'QTD' ,paa.assignment_action_id ,paa.assignment_id ,ppa.effective_date ,pay_ca_balance_view_pkg.get_session_var('REPORT_LEVEL') ,paa.tax_unit_id ,pay_ca_balance_view_pkg.get_session_var('BUSINESS_GROUP') ) QTD_VALUE , pay_ca_balance_pkg.call_ca_balance_get_value( pbs.attribute_1 ,'PTD' ,paa.assignment_action_id ,paa.assignment_id ,ppa.effective_date ,pay_ca_balance_view_pkg.get_session_var('REPORT_LEVEL') ,paa.tax_unit_id ,pay_ca_balance_view_pkg.get_session_var('BUSINESS_GROUP') ) PTD_VALUE , pay_ca_balance_pkg.call_ca_balance_get_value( pbs.attribute_1 ,'YTD' ,paa.assignment_action_id ,paa.assignment_id ,ppa.effective_date ,pay_ca_balance_view_pkg.get_session_var('REPORT_LEVEL') ,paa.tax_unit_id ,pay_ca_balance_view_pkg.get_session_var('BUSINESS_GROUP') ) YTD_VALUE FROM pay_payroll_actions ppa , pay_assignment_actions paa , pay_balance_sets pbs,pay_balance_types pbt, pay_balance_types_tl pbttl WHERE ppa.payroll_action_id = paa.payroll_action_id and ppa.action_type in ('Q','R','V','B','I') and pbs.attribute_1 = pbt.balance_name and pbt.legislation_code = 'CA' and pbt.balance_type_id = pbttl.balance_type_id and pbttl.language = userenv('LANG') and substr(pbs.balance_set_name,1,6) = 'FED_ER'

View Text - HTML Formatted

SELECT PAA.ASSIGNMENT_ID
, PAA.TAX_UNIT_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ACTION_STATUS
, PPA.PAYROLL_ACTION_ID
, PPA.ACTION_TYPE
, PPA.EFFECTIVE_DATE
, PBS.ATTRIBUTE_1 BASE_BALANCE_NAME
, PBTTL.BALANCE_NAME BALANCE_NAME
, PBTTL.REPORTING_NAME REPORTING_NAME
, PBS.BUSINESS_GROUP_ID
, PBS.LEGISLATION_CODE
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE( PBS.ATTRIBUTE_1
, 'CURRENT'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
, PAA.TAX_UNIT_ID
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('BUSINESS_GROUP') ) CURRENT_VALUE
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE( PBS.ATTRIBUTE_1
, 'RUN'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
, PAA.TAX_UNIT_ID
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('BUSINESS_GROUP') ) RUN_VALUE
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE( PBS.ATTRIBUTE_1
, 'PYDATE'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
, PAA.TAX_UNIT_ID
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('BUSINESS_GROUP') ) PYDATE_VALUE
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE( PBS.ATTRIBUTE_1
, 'MONTH'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
, PAA.TAX_UNIT_ID
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('BUSINESS_GROUP') ) MONTH_VALUE
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE( PBS.ATTRIBUTE_1
, 'QTD'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
, PAA.TAX_UNIT_ID
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('BUSINESS_GROUP') ) QTD_VALUE
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE( PBS.ATTRIBUTE_1
, 'PTD'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
, PAA.TAX_UNIT_ID
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('BUSINESS_GROUP') ) PTD_VALUE
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE( PBS.ATTRIBUTE_1
, 'YTD'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
, PAA.TAX_UNIT_ID
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('BUSINESS_GROUP') ) YTD_VALUE
FROM PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_BALANCE_SETS PBS
, PAY_BALANCE_TYPES PBT
, PAY_BALANCE_TYPES_TL PBTTL
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('Q'
, 'R'
, 'V'
, 'B'
, 'I')
AND PBS.ATTRIBUTE_1 = PBT.BALANCE_NAME
AND PBT.LEGISLATION_CODE = 'CA'
AND PBT.BALANCE_TYPE_ID = PBTTL.BALANCE_TYPE_ID
AND PBTTL.LANGUAGE = USERENV('LANG')
AND SUBSTR(PBS.BALANCE_SET_NAME
, 1
, 6) = 'FED_ER'