VIEW: APPS.PAY_GB_BALANCES_BY_DATE_V2

Source

View Text - Preformatted

SELECT /*+ ORDERED USE_NL(pbttl,pbt,paf,pdb,pbd,ses) */ PAF.ROWID ROW_ID , PAF.ASSIGNMENT_ID, PBT.BALANCE_TYPE_ID, PBTTL.BALANCE_NAME, PDB.DEFINED_BALANCE_ID, PBD.DATABASE_ITEM_SUFFIX, SES.EFFECTIVE_DATE, hr_gbbal.calc_all_balances(SES.EFFECTIVE_DATE, PAF.ASSIGNMENT_ID, PDB.DEFINED_BALANCE_ID) VALUE FROM PAY_BALANCE_TYPES_TL PBTTL, PAY_BALANCE_TYPES PBT, PER_ALL_ASSIGNMENTS_F PAF, PAY_DEFINED_BALANCES PDB, PAY_BALANCE_DIMENSIONS PBD, FND_SESSIONS SES WHERE PBT.balance_type_id = PBTTL.balance_type_id AND PBTTL.LANGUAGE = userenv('LANG') AND (PBT.LEGISLATION_CODE IS NULL OR PBT.LEGISLATION_CODE = 'GB') AND PBT.balance_type_id = PDB.BALANCE_TYPE_ID AND PBD.balance_dimension_id = PDB.BALANCE_DIMENSION_ID AND SES.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE AND SES.SESSION_ID = USERENV('SESSIONID') and ( pdb.legislation_code = 'GB' OR pdb.business_group_id = PAF.BUSINESS_GROUP_ID)

View Text - HTML Formatted

SELECT /*+ ORDERED USE_NL(PBTTL
, PBT
, PAF
, PDB
, PBD
, SES) */ PAF.ROWID ROW_ID
, PAF.ASSIGNMENT_ID
, PBT.BALANCE_TYPE_ID
, PBTTL.BALANCE_NAME
, PDB.DEFINED_BALANCE_ID
, PBD.DATABASE_ITEM_SUFFIX
, SES.EFFECTIVE_DATE
, HR_GBBAL.CALC_ALL_BALANCES(SES.EFFECTIVE_DATE
, PAF.ASSIGNMENT_ID
, PDB.DEFINED_BALANCE_ID) VALUE
FROM PAY_BALANCE_TYPES_TL PBTTL
, PAY_BALANCE_TYPES PBT
, PER_ALL_ASSIGNMENTS_F PAF
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_DIMENSIONS PBD
, FND_SESSIONS SES
WHERE PBT.BALANCE_TYPE_ID = PBTTL.BALANCE_TYPE_ID
AND PBTTL.LANGUAGE = USERENV('LANG')
AND (PBT.LEGISLATION_CODE IS NULL OR PBT.LEGISLATION_CODE = 'GB')
AND PBT.BALANCE_TYPE_ID = PDB.BALANCE_TYPE_ID
AND PBD.BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID
AND SES.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND SES.SESSION_ID = USERENV('SESSIONID')
AND ( PDB.LEGISLATION_CODE = 'GB' OR PDB.BUSINESS_GROUP_ID = PAF.BUSINESS_GROUP_ID)