APPS.IGS_FI_PAYMENT_PLANS dependencies on IGS_PE_PERSID_GROUP_ALL

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

45: g_v_person CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON');
46: g_d_sysdate CONSTANT DATE := TRUNC(SYSDATE);
47:
48: --Cursor for validating person group.
49: CURSOR cur_pers_grp(cp_n_pers_grp_id igs_pe_persid_group_all.group_id%TYPE) IS
50: SELECT 'x'
51: FROM igs_pe_persid_group_all
52: WHERE group_id = cp_n_pers_grp_id
53: AND TRUNC(create_dt) <= g_d_sysdate

Line 51: FROM igs_pe_persid_group_all

47:
48: --Cursor for validating person group.
49: CURSOR cur_pers_grp(cp_n_pers_grp_id igs_pe_persid_group_all.group_id%TYPE) IS
50: SELECT 'x'
51: FROM igs_pe_persid_group_all
52: WHERE group_id = cp_n_pers_grp_id
53: AND TRUNC(create_dt) <= g_d_sysdate
54: AND NVL(closed_ind,g_v_ind_no) = g_v_ind_no;
55:

Line 59: p_n_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,

55:
56:
57: PROCEDURE activate_plan(errbuf OUT NOCOPY VARCHAR2,
58: retcode OUT NOCOPY NUMBER,
59: p_n_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,
60: p_v_fee_period IN VARCHAR2,
61: p_n_offset_days IN NUMBER
62: ) AS
63: ------------------------------------------------------------------

Line 513: p_n_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,

509:
510: PROCEDURE assign_students(errbuf OUT NOCOPY VARCHAR2,
511: retcode OUT NOCOPY NUMBER,
512: p_v_payment_plan_name IN igs_fi_pp_templates.payment_plan_name%TYPE,
513: p_n_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,
514: p_v_start_date IN VARCHAR2,
515: p_v_fee_period IN VARCHAR2
516: ) AS
517: ------------------------------------------------------------------

Line 1184: p_n_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,

1180:
1181: PROCEDURE close_status(errbuf OUT NOCOPY VARCHAR2,
1182: retcode OUT NOCOPY NUMBER,
1183: p_n_tolerance_threshold IN NUMBER,
1184: p_n_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,
1185: p_v_test_mode IN VARCHAR2
1186: ) AS
1187: ------------------------------------------------------------------
1188: --Created by : vvutukur, Oracle IDC