DBA Data[Home] [Help]

APPS.PAY_ZA_EOY_VAL dependencies on PAY_BALANCE_TYPES

Line 655: CURSOR fetch_pkg_ele( p_asgn_action_id pay_assignment_actions.assignment_action_id%type, p_bal_typ_id pay_balance_types.balance_type_id%type) IS

651: AND paei.information_type = 'ZA_SPECIFIC_INFO'
652: AND pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0)) <> '0';
653:
654: /*Fetch elements feeding to PKG classification */
655: CURSOR fetch_pkg_ele( p_asgn_action_id pay_assignment_actions.assignment_action_id%type, p_bal_typ_id pay_balance_types.balance_type_id%type) IS
656: SELECT ELEM.element_name element_name,
657: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(TARGET.RESULT_VALUE,0)))))
658: from pay_balance_feeds_f FEED
659: , pay_run_result_values TARGET