APPS.IGS_FI_REFUNDS_PROCESS dependencies on IGS_PE_ALL_PERSID_GROUP_V

Line 547: 1. Modified cursor cur_pers_grp - used igs_pe_all_persid_group_v instead of igs_pe_persid_group

543: Added validation for manage_account - call to chk_manage_account()
544: Added code to log messages for test run = Y and for no-data-found cases
545: Increased width of l_v_sql_query from 1000 to 32767
546: pathipat 18-Feb-2003 Enh 2747329 - Payables Intg build
547: 1. Modified cursor cur_pers_grp - used igs_pe_all_persid_group_v instead of igs_pe_persid_group
548: Changed declaration of l_group_code accordingly.
549: 2. Added validation to check for Refunds Destination before allowing the process to be run
550: 3. Modified approach to identify persons in a person id group
551: vvutukur 03-Jan-2003 Bug#2727216.Modified the logic for logging the parameters, by removing the

Line 564: FROM igs_pe_all_persid_group_v

560:
561: -- Cursor for validating Person Id Group
562: CURSOR cur_pers_grp IS
563: SELECT group_cd
564: FROM igs_pe_all_persid_group_v
565: WHERE group_id = p_person_id_grp
566: AND closed_ind = 'N';
567:
568: l_group_code igs_pe_all_persid_group_v.group_cd%TYPE;

Line 568: l_group_code igs_pe_all_persid_group_v.group_cd%TYPE;

564: FROM igs_pe_all_persid_group_v
565: WHERE group_id = p_person_id_grp
566: AND closed_ind = 'N';
567:
568: l_group_code igs_pe_all_persid_group_v.group_cd%TYPE;
569:
570: -- Ref cursor used to execute the dynamic sql query for
571: -- identifying persons in a Person Id Group
572: TYPE person_group_ref IS REF CURSOR;