VIEW: APPS.PAY_KR_SEP_RESULT_BALV_V

Source

View Text - Preformatted

SELECT /*+RULE*/ paa.assignment_action_id assignment_action_id, paa.assignment_id assignment_id, ppa.effective_date effective_date, ppa.date_earned date_earned, paa.run_type_id run_type_id, pbt.balance_type_id balance_type_id, pdb.defined_balance_id defined_balance_id, pbd.balance_dimension_id balance_dimension_id, pbd.database_item_suffix database_item_suffix, pbd.dimension_name dimension_name, pbd.dimension_type dimension_type, pbd.route_id route_id, pay_balance_pkg.get_value(pdb.defined_balance_id,paa.assignment_action_id) balance_value from pay_balance_dimensions pbd, pay_defined_balances pdb, pay_balance_types pbt, pay_payroll_actions ppa, pay_assignment_actions paa where ppa.payroll_action_id = paa.payroll_action_id and pdb.balance_type_id = pbt.balance_type_id and nvl(pdb.business_group_id,ppa.business_group_id) = ppa.business_group_id and nvl(pdb.legislation_code,pay_kr_report_pkg.legislation_code(ppa.business_group_id)) = pay_kr_report_pkg.legislation_code(ppa.business_group_id) and pbd.balance_dimension_id = pdb.balance_dimension_id

View Text - HTML Formatted

SELECT /*+RULE*/ PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE EFFECTIVE_DATE
, PPA.DATE_EARNED DATE_EARNED
, PAA.RUN_TYPE_ID RUN_TYPE_ID
, PBT.BALANCE_TYPE_ID BALANCE_TYPE_ID
, PDB.DEFINED_BALANCE_ID DEFINED_BALANCE_ID
, PBD.BALANCE_DIMENSION_ID BALANCE_DIMENSION_ID
, PBD.DATABASE_ITEM_SUFFIX DATABASE_ITEM_SUFFIX
, PBD.DIMENSION_NAME DIMENSION_NAME
, PBD.DIMENSION_TYPE DIMENSION_TYPE
, PBD.ROUTE_ID ROUTE_ID
, PAY_BALANCE_PKG.GET_VALUE(PDB.DEFINED_BALANCE_ID
, PAA.ASSIGNMENT_ACTION_ID) BALANCE_VALUE
FROM PAY_BALANCE_DIMENSIONS PBD
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_TYPES PBT
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PDB.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
AND NVL(PDB.BUSINESS_GROUP_ID
, PPA.BUSINESS_GROUP_ID) = PPA.BUSINESS_GROUP_ID
AND NVL(PDB.LEGISLATION_CODE
, PAY_KR_REPORT_PKG.LEGISLATION_CODE(PPA.BUSINESS_GROUP_ID)) = PAY_KR_REPORT_PKG.LEGISLATION_CODE(PPA.BUSINESS_GROUP_ID)
AND PBD.BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID