APPS.IGS_FI_GEN_004 dependencies on IGS_PE_PERSID_GROUP_ALL

Line 934: CURSOR cur_pers_grp(cp_n_pers_grp_id igs_pe_persid_group_all.group_id%TYPE) IS

930: l_v_manage_accounts igs_fi_control.manage_accounts%TYPE;
931:
932: l_v_person_number igs_fi_parties_v.person_number%TYPE := NULL;
933:
934: CURSOR cur_pers_grp(cp_n_pers_grp_id igs_pe_persid_group_all.group_id%TYPE) IS
935: SELECT 'x'
936: FROM igs_pe_persid_group_all
937: WHERE group_id = cp_n_pers_grp_id
938: AND TRUNC(create_dt) <= g_d_sysdate

Line 936: FROM igs_pe_persid_group_all

932: l_v_person_number igs_fi_parties_v.person_number%TYPE := NULL;
933:
934: CURSOR cur_pers_grp(cp_n_pers_grp_id igs_pe_persid_group_all.group_id%TYPE) IS
935: SELECT 'x'
936: FROM igs_pe_persid_group_all
937: WHERE group_id = cp_n_pers_grp_id
938: AND TRUNC(create_dt) <= g_d_sysdate
939: AND NVL(closed_ind, g_v_ind_no) = g_v_ind_no;
940: l_c_var VARCHAR2(10) := NULL;