DBA Data[Home] [Help]

APPS.IGS_AD_GEN_011 dependencies on IGS_PE_PERSID_GROUP_ALL

Line 1247: cp_person_id_group IN igs_pe_persid_group_all.group_id%TYPE

1243: --
1244: -- Cursor to select all the Person IDs that are part of the Person ID Group.
1245: --
1246: CURSOR cur_person_ids (
1247: cp_person_id_group IN igs_pe_persid_group_all.group_id%TYPE
1248: ) IS
1249: SELECT person_id
1250: FROM igs_pe_prsid_grp_mem_v
1251: WHERE group_id = cp_person_id_group AND

Line 1441: p_person_id_group igs_pe_persid_group_all.group_id%TYPE;

1437: p_program_of_study igs_ad_ps_appl_inst.nominated_course_cd%TYPE;
1438: p_response_status igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE;
1439: p_residency_class igs_pe_res_dtls_v.residency_class%TYPE;
1440: p_residency_status igs_pe_res_dtls_v.residency_status%TYPE;
1441: p_person_id_group igs_pe_persid_group_all.group_id%TYPE;
1442: p_organization_unit igs_ps_ver.responsible_org_unit_cd%TYPE;
1443: p_sort_by fnd_lookups.lookup_code%TYPE;
1444: /*
1445: ** End of code for enhancement# 1818444.