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.PAYFV_DEFINED_BALANCES

Source

View Text - Preformatted


SELECT /* $Header: paybis.odf 115.16 2003/10/31 12:12:24 asasthan noship $ */ bgrT.name business_group_name ,NVL(dbl.legislation_code,pbg.legislation_code) legislation_code ,blt.balance_name balance_name ,blt.legislation_subgroup balance_legislation_subgroup ,blt.reporting_name balance_reporting_name ,hr_general.decode_lookup('UNITS',blt.balance_uom) balance_unit_of_measure ,bdm.dimension_name dimension_name ,hr_general.decode_lookup('DIMENSION_TYPE',bdm.dimension_type) dimension_type ,bdm.description dimension_description ,bdm.database_item_suffix database_item_suffix /* Descriptive Flexfields */ ,'_DF:PAY:PAY_BALANCE_TYPES:blt' /* Ids */ ,dbl.defined_balance_id defined_balance_id ,dbl.business_group_id business_group_id ,dbl.balance_type_id balance_type_id ,dbl.balance_dimension_id balance_dimension_id FROM pay_defined_balances dbl ,pay_balance_types blt ,pay_balance_dimensions bdm ,per_business_groups pbg ,hr_all_organization_units_tl bgrT WHERE dbl.balance_type_id = blt.balance_type_id AND dbl.balance_dimension_id = bdm.balance_dimension_id AND bgrT.organization_id (+) = dbl.business_group_id AND bgrT.language (+) = userenv('LANG') AND pbg.business_group_id (+) = NVL(hr_general.get_business_group_id,dbl.business_group_id) AND ( (dbl.business_group_id IS NOT NULL AND dbl.business_group_id = NVL(hr_general.get_business_group_id,dbl.business_group_id)) OR (dbl.legislation_code IS NOT NULL AND dbl.legislation_code = NVL(pbg.legislation_code,dbl.legislation_code)) OR (dbl.business_group_id IS NULL AND dbl.legislation_code IS NULL) ) WITH READ ONLY

View Text - HTML Formatted

SELECT /* $HEADER: PAYBIS.ODF 115.16 2003/10/31 12:12:24 ASASTHAN NOSHIP $ */ BGRT.NAME BUSINESS_GROUP_NAME
, NVL(DBL.LEGISLATION_CODE
, PBG.LEGISLATION_CODE) LEGISLATION_CODE
, BLT.BALANCE_NAME BALANCE_NAME
, BLT.LEGISLATION_SUBGROUP BALANCE_LEGISLATION_SUBGROUP
, BLT.REPORTING_NAME BALANCE_REPORTING_NAME
, HR_GENERAL.DECODE_LOOKUP('UNITS'
, BLT.BALANCE_UOM) BALANCE_UNIT_OF_MEASURE
, BDM.DIMENSION_NAME DIMENSION_NAME
, HR_GENERAL.DECODE_LOOKUP('DIMENSION_TYPE'
, BDM.DIMENSION_TYPE) DIMENSION_TYPE
, BDM.DESCRIPTION DIMENSION_DESCRIPTION
, BDM.DATABASE_ITEM_SUFFIX DATABASE_ITEM_SUFFIX /* DESCRIPTIVE FLEXFIELDS */
, '_DF:PAY:PAY_BALANCE_TYPES:BLT' /* IDS */
, DBL.DEFINED_BALANCE_ID DEFINED_BALANCE_ID
, DBL.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, DBL.BALANCE_TYPE_ID BALANCE_TYPE_ID
, DBL.BALANCE_DIMENSION_ID BALANCE_DIMENSION_ID
FROM PAY_DEFINED_BALANCES DBL
, PAY_BALANCE_TYPES BLT
, PAY_BALANCE_DIMENSIONS BDM
, PER_BUSINESS_GROUPS PBG
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE DBL.BALANCE_TYPE_ID = BLT.BALANCE_TYPE_ID
AND DBL.BALANCE_DIMENSION_ID = BDM.BALANCE_DIMENSION_ID
AND BGRT.ORGANIZATION_ID (+) = DBL.BUSINESS_GROUP_ID
AND BGRT.LANGUAGE (+) = USERENV('LANG')
AND PBG.BUSINESS_GROUP_ID (+) = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, DBL.BUSINESS_GROUP_ID)
AND ( (DBL.BUSINESS_GROUP_ID IS NOT NULL
AND DBL.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, DBL.BUSINESS_GROUP_ID)) OR (DBL.LEGISLATION_CODE IS NOT NULL
AND DBL.LEGISLATION_CODE = NVL(PBG.LEGISLATION_CODE
, DBL.LEGISLATION_CODE)) OR (DBL.BUSINESS_GROUP_ID IS NULL
AND DBL.LEGISLATION_CODE IS NULL) ) WITH READ ONLY