APPS.IGF_AP_VER_GRPS_PRC_PKG dependencies on IGS_PE_PERSID_GROUP

Line 86: CURSOR c_person_group( cp_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE ) IS

82: WHERE pe.person_id = fa.person_id
83: AND fa.base_id = cp_base_id;
84:
85: -- Get the details of group
86: CURSOR c_person_group( cp_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE ) IS
87: SELECT description
88: FROM igs_pe_persid_group
89: WHERE group_id = cp_person_id_grp;
90:

Line 88: FROM igs_pe_persid_group

84:
85: -- Get the details of group
86: CURSOR c_person_group( cp_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE ) IS
87: SELECT description
88: FROM igs_pe_persid_group
89: WHERE group_id = cp_person_id_grp;
90:
91: -- Get Item Description
92: CURSOR c_item_descrption( cp_item_number IN igf_ap_td_item_mst_all.todo_number%TYPE ) IS

Line 113: l_group_desc igs_pe_persid_group_all.description%TYPE;

109: lv_isir_field_pmpt igf_lookups_view.meaning%TYPE ;
110: l_para_pass igf_lookups_view.meaning%TYPE ;
111:
112: l_person_number igs_pe_person_base_v.person_number%TYPE;
113: l_group_desc igs_pe_persid_group_all.description%TYPE;
114: l_item_description igf_ap_td_item_mst_all.description%TYPE;
115:
116:
117: BEGIN

Line 566: lv_group_type igs_pe_persid_group_v.group_type%TYPE;

562:
563: -- Get all Active persons from the given person_id_group.
564: /* Variables for the dynamic person id group */
565: lv_status VARCHAR2(1) := 'S'; /*Defaulted to 'S' and the function will return 'F' in case of failure */
566: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
567:
568: lv_sql_stmt VARCHAR(32767) := igf_ap_ss_pkg.get_pid(p_prs_grp_id,lv_status,lv_group_type);
569:
570: /* Variable to change the dynamic sql stmt and get the count */