APPS.IGF_GR_REPACKAGE dependencies on IGS_PE_PERSID_GROUP_ALL

Line 46: p_persid_grp IN igs_pe_persid_group_all.group_id%TYPE,

42: PROCEDURE log_parameters(
43: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
44: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
45: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
46: p_persid_grp IN igs_pe_persid_group_all.group_id%TYPE,
47: p_test_run IN VARCHAR2,
48: p_cancel_invalid_award IN VARCHAR2
49: ) AS
50: ------------------------------------------------------------------

Line 96: cp_persid_grp igs_pe_persid_group_all.group_id%TYPE

92: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;
93:
94: -- Get get group description for group_id
95: CURSOR c_person_group(
96: cp_persid_grp igs_pe_persid_group_all.group_id%TYPE
97: ) IS
98: SELECT group_cd group_name
99: FROM igs_pe_persid_group_all
100: WHERE group_id = cp_persid_grp;

Line 99: FROM igs_pe_persid_group_all

95: CURSOR c_person_group(
96: cp_persid_grp igs_pe_persid_group_all.group_id%TYPE
97: ) IS
98: SELECT group_cd group_name
99: FROM igs_pe_persid_group_all
100: WHERE group_id = cp_persid_grp;
101:
102: l_persid_grp_name c_person_group%ROWTYPE;
103:

Line 1323: p_persid_grp IN igs_pe_persid_group_all.group_id%TYPE,

1319: retcode OUT NOCOPY NUMBER,
1320: p_award_year IN VARCHAR2,
1321: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1322: p_org_id IN igf_aw_award_all.org_id%TYPE,
1323: p_persid_grp IN igs_pe_persid_group_all.group_id%TYPE,
1324: p_test_run IN VARCHAR2,
1325: p_cancel_invalid_awds IN VARCHAR2
1326: ) AS
1327: -----------------------------------------------------------------------------------------------