APPS.IGF_GR_GEN_XML dependencies on IGS_PE_PERSID_GROUP_ALL

Line 97: FROM IGS_PE_PERSID_GROUP_ALL

93: AS
94:
95: CURSOR cur_get_grp_name ( p_per_grp_id NUMBER) IS
96: SELECT group_cd
97: FROM IGS_PE_PERSID_GROUP_ALL
98: WHERE group_id = p_per_grp_id;
99: get_grp_name_rec cur_get_grp_name%ROWTYPE;
100:
101: BEGIN

Line 234: CURSOR cur_person_group(cp_persid_grp igs_pe_persid_group_all.group_id%TYPE) IS

230: (reverse chronological order - newest change first)
231: ***************************************************************/
232:
233: -- To get group description for group_id
234: CURSOR cur_person_group(cp_persid_grp igs_pe_persid_group_all.group_id%TYPE) IS
235: SELECT group_cd group_name
236: FROM igs_pe_persid_group_all
237: WHERE group_id = cp_persid_grp;
238: rec_person_group cur_person_group%ROWTYPE;

Line 236: FROM igs_pe_persid_group_all

232:
233: -- To get group description for group_id
234: CURSOR cur_person_group(cp_persid_grp igs_pe_persid_group_all.group_id%TYPE) IS
235: SELECT group_cd group_name
236: FROM igs_pe_persid_group_all
237: WHERE group_id = cp_persid_grp;
238: rec_person_group cur_person_group%ROWTYPE;
239:
240: l_ci_cal_type VARCHAR2(11);

Line 383: CURSOR cur_person_group ( cp_persid_grp igs_pe_persid_group_all.group_id%TYPE) IS

379: AND rfms.ci_sequence_number = cp_sequence_number
380: AND rfms.base_id = cp_base_id;
381:
382: -- To check fa base record exists or not.
383: CURSOR cur_person_group ( cp_persid_grp igs_pe_persid_group_all.group_id%TYPE) IS
384: SELECT 'x'
385: FROM IGS_PE_PERSID_GROUP_ALL pers
386: WHERE pers.group_id = cp_persid_grp
387: AND pers.closed_ind = 'N';

Line 385: FROM IGS_PE_PERSID_GROUP_ALL pers

381:
382: -- To check fa base record exists or not.
383: CURSOR cur_person_group ( cp_persid_grp igs_pe_persid_group_all.group_id%TYPE) IS
384: SELECT 'x'
385: FROM IGS_PE_PERSID_GROUP_ALL pers
386: WHERE pers.group_id = cp_persid_grp
387: AND pers.closed_ind = 'N';
388:
389: l_params_status BOOLEAN;