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: --
551: cursor csr_payment_detail is
552: select 'Y'
553: from per_bf_payment_details bpd
549: -- Cursor to check if child rows exist in per_bf_payment_details
550: --
551: cursor csr_payment_detail is
552: select 'Y'
553: from per_bf_payment_details bpd
554: where bpd.processed_assignment_id = p_processed_assignment_id;
555:
556: --
557: BEGIN