DBA Data[Home] [Help]

APPS.PAY_GB_COURT_ORDER_UPGRADE dependencies on PAY_BALANCE_PKG

Line 252: nvl(pay_balance_pkg.get_value(p_defined_balance_id, max(pac.assignment_action_id), null,null, fc.context_id, pac.context_value,null,null),0) paid_value

248: CURSOR csr_asg_actions(p_person_id in number
249: ,p_defined_balance_id in number) is
250: SELECT max(paa.assignment_action_id) assignment_action_id,
251: pac.context_value context_value,
252: nvl(pay_balance_pkg.get_value(p_defined_balance_id, max(pac.assignment_action_id), null,null, fc.context_id, pac.context_value,null,null),0) paid_value
253: FROM per_assignments_f paf,
254: pay_assignment_actions paa,
255: pay_action_contexts pac,
256: ff_contexts fc,