538: --
539: l_exists varchar2(1);
540: l_proc varchar2(72) := g_package || 'chk_child_rows';
541: --
542: -- Cursor to check if child rows exist in per_bf_balance_amounts
543: --
544: cursor csr_balance_amount is
545: select 'Y'
546: from per_bf_balance_amounts bba
542: -- Cursor to check if child rows exist in per_bf_balance_amounts
543: --
544: cursor csr_balance_amount is
545: select 'Y'
546: from per_bf_balance_amounts bba
547: where bba.processed_assignment_id = p_processed_assignment_id;
548: --
549: -- Cursor to check if child rows exist in per_bf_payment_details
550: --