APPS.IGS_FI_PRC_REFUNDS dependencies on IGS_PE_ALL_PERSID_GROUP_V

Line 656: igs_pe_all_persid_group_v. Added validation for refund_cr_gl_ccid.

652: is on an Active Payment Plan
653: pathipat 24-Apr-2003 Enh 2831569 - Commercial Receivables build
654: Added check for manage_accounts - call to chk_manage_account()
655: smadathi 21-Feb-2002 Bug 2747329. Cursor select cur_pers was modified to replace table igs_pe_persid_group reference to
656: igs_pe_all_persid_group_v. Added validation for refund_cr_gl_ccid.
657: agairola 23-Dec-02 Bug 2718029: Modified the code in Process_batch to remove the app_exception
658: .raise_exception for parameter validation and replaced it by setting retcode=2
659: and RETURN
660: vvutukur 19-Nov-2002 Enh#2584986.Added mandatory IN parameter p_d_gl_date.Code added to validate GL Date.

Line 687: FROM igs_pe_all_persid_group_v

683:
684: -- Cursor for validating the Person Id Group
685: CURSOR cur_pers(cp_person_id_grp igs_pe_persid_group.group_id%TYPE) IS
686: SELECT group_cd
687: FROM igs_pe_all_persid_group_v
688: WHERE group_id=cp_person_id_grp
689: AND closed_ind <> g_ind_yes;
690:
691: -- Cursor for getting the Person Ids for which the Refunds have to be

Line 800: l_group_cd igs_pe_all_persid_group_v.group_cd%TYPE;

796: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
797: l_rfnd_amnt igs_fi_refunds.refund_amount%TYPE;
798: l_party_number igs_fi_parties_v.person_number%TYPE;
799: l_invoice_number igs_fi_inv_int.invoice_number%TYPE;
800: l_group_cd igs_pe_all_persid_group_v.group_cd%TYPE;
801: l_v_message_name fnd_new_messages.message_name%TYPE;
802: l_v_closing_status gl_period_statuses.closing_status%TYPE;
803: l_d_gl_date igs_fi_credits_all.gl_date%TYPE;
804: l_n_party_id hz_parties.party_id%TYPE;