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_PMED_WCB_BALANCES_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 , pbttl.balance_name , pbttl.reporting_name , PPA.BUSINESS_GROUP_ID , PBS.LEGISLATION_CODE , PWI.BALANCE_TYPE , 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') ,NULL ,PWI.SOURCE_ID ) 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') ,NULL ,PWI.SOURCE_ID )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') ,NULL ,PWI.SOURCE_ID )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') ,NULL ,PWI.SOURCE_ID )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') ,NULL ,PWI.SOURCE_ID )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') ,NULL ,PWI.SOURCE_ID )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') ,NULL ,PWI.SOURCE_ID )YTD_VALUE FROM PAY_CA_PMED_WCB_ID_V PWI, PAY_BALANCE_SETS PBS, PAY_PAYROLL_ACTIONS PPA , PAY_ASSIGNMENT_ACTIONS PAA,PAY_BALANCE_TYPES PBT,PAY_BALANCE_TYPES_TL PBTTL WHERE PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID AND PPA.ACTION_TYPE IN ('Q','R','V','B','I') AND PPA.ACTION_STATUS = 'C' 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 PWI.BALANCE_TYPE = DECODE(PBS.BALANCE_SET_NAME,'WCB','WCB','PMED','PMED') AND PPA.BUSINESS_GROUP_ID = PWI.BUSINESS_GROUP_ID + 0 AND PBS.LEGISLATION_CODE = 'CA' AND EXISTS ( SELECT 'X' FROM PAY_PAYROLL_ACTIONS PPA2 , PAY_ASSIGNMENT_ACTIONS PAA2, PAY_ACTION_CONTEXTS PAC2, FF_CONTEXTS FFC2 WHERE PAA2.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND PAC2.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID AND PPA2.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID AND PPA2.EFFECTIVE_DATE BETWEEN TRUNC(PPA.EFFECTIVE_DATE,'YEAR') AND PPA.EFFECTIVE_DATE AND PPA2.ACTION_TYPE IN ('R','Q') AND PAC2.CONTEXT_VALUE =TO_CHAR( PWI.SOURCE_ID) AND PAC2.CONTEXT_ID = FFC2.CONTEXT_ID AND FFC2.CONTEXT_NAME = 'SOURCE_ID')

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
, PBTTL.BALANCE_NAME
, PBTTL.REPORTING_NAME
, PPA.BUSINESS_GROUP_ID
, PBS.LEGISLATION_CODE
, PWI.BALANCE_TYPE
, 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')
, NULL
, PWI.SOURCE_ID ) 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')
, NULL
, PWI.SOURCE_ID )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')
, NULL
, PWI.SOURCE_ID )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')
, NULL
, PWI.SOURCE_ID )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')
, NULL
, PWI.SOURCE_ID )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')
, NULL
, PWI.SOURCE_ID )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')
, NULL
, PWI.SOURCE_ID )YTD_VALUE
FROM PAY_CA_PMED_WCB_ID_V PWI
, PAY_BALANCE_SETS PBS
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_BALANCE_TYPES PBT
, PAY_BALANCE_TYPES_TL PBTTL
WHERE PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('Q'
, 'R'
, 'V'
, 'B'
, 'I')
AND PPA.ACTION_STATUS = 'C'
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 PWI.BALANCE_TYPE = DECODE(PBS.BALANCE_SET_NAME
, 'WCB'
, 'WCB'
, 'PMED'
, 'PMED')
AND PPA.BUSINESS_GROUP_ID = PWI.BUSINESS_GROUP_ID + 0
AND PBS.LEGISLATION_CODE = 'CA'
AND EXISTS ( SELECT 'X'
FROM PAY_PAYROLL_ACTIONS PPA2
, PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_ACTION_CONTEXTS PAC2
, FF_CONTEXTS FFC2
WHERE PAA2.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PAC2.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PPA2.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID
AND PPA2.EFFECTIVE_DATE BETWEEN TRUNC(PPA.EFFECTIVE_DATE
, 'YEAR')
AND PPA.EFFECTIVE_DATE
AND PPA2.ACTION_TYPE IN ('R'
, 'Q')
AND PAC2.CONTEXT_VALUE =TO_CHAR( PWI.SOURCE_ID)
AND PAC2.CONTEXT_ID = FFC2.CONTEXT_ID
AND FFC2.CONTEXT_NAME = 'SOURCE_ID')