APPS.PAY_ZA_EOY_VAL dependencies on PAY_BALANCE_TYPES

Line 835: 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

831: AND paei.information_type = 'ZA_SPECIFIC_INFO'
832: AND pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0)) <> '0';
833:
834: /*Fetch elements feeding to PKG classification */
835: 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
836: SELECT ELEM.element_name element_name,
837: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(TARGET.RESULT_VALUE,0)))))
838: from pay_balance_feeds_f FEED
839: , pay_run_result_values TARGET

Line 4155: , pay_balance_types PBT

4151: , pay_assignment_actions ASSACT
4152: , pay_payroll_actions BACT
4153: , pay_assignment_actions BAL_ASSACT
4154: , pay_element_types_f ELEM
4155: , pay_balance_types PBT
4156: where BAL_ASSACT.assignment_action_id = p_asgn_action_id
4157: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
4158: and FEED.input_value_id = TARGET.input_value_id
4159: and TARGET.run_result_id = RR.run_result_id