[Home] [Help]
650: SELECT
651: cra.credit_activity_id
652: FROM
653: igs_fi_cr_activities cra,
654: igs_fi_credits cr,
655: igs_fi_cr_types crt
656: WHERE
657: cra.status = 'CLEARED'
658: AND cr.party_id = cp_n_person_id
705: WHERE person_id = p_n_person_id;
706:
707: CURSOR cur_min_crd_dt IS
708: SELECT MIN(effective_date)
709: FROM igs_fi_credits_all
710: WHERE party_id = p_n_person_id;
711:
712: BEGIN
713: