VIEW: APPS.PAY_NZ_BALANCES_BY_DATE_V2

Source

View Text - Preformatted

SELECT paf.rowid row_id , paf.assignment_id , pbt.balance_type_id , pbt.balance_name , pdb.defined_balance_id , pbd.database_item_suffix , ses.effective_date , hr_nzbal.calc_all_balances( ses.effective_date, paf.assignment_id, pdb.defined_balance_id ) value from pay_balance_types pbt , per_assignments_f paf , fnd_sessions ses , pay_defined_balances pdb , pay_balance_dimensions pbd WHERE ( pbt.legislation_code is null or pbt.legislation_code = 'NZ') 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')

View Text - HTML Formatted

SELECT PAF.ROWID ROW_ID
, PAF.ASSIGNMENT_ID
, PBT.BALANCE_TYPE_ID
, PBT.BALANCE_NAME
, PDB.DEFINED_BALANCE_ID
, PBD.DATABASE_ITEM_SUFFIX
, SES.EFFECTIVE_DATE
, HR_NZBAL.CALC_ALL_BALANCES( SES.EFFECTIVE_DATE
, PAF.ASSIGNMENT_ID
, PDB.DEFINED_BALANCE_ID ) VALUE
FROM PAY_BALANCE_TYPES PBT
, PER_ASSIGNMENTS_F PAF
, FND_SESSIONS SES
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_DIMENSIONS PBD
WHERE ( PBT.LEGISLATION_CODE IS NULL OR PBT.LEGISLATION_CODE = 'NZ')
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')