APPS.IGF_AW_CANCEL_AWD dependencies on IGS_PE_PERSID_GROUP_ALL

Line 480: CURSOR cur_get_pig_desc (cp_pig_id igs_pe_persid_group_all.group_id%TYPE)

476: igf_ap_fa_con_v
477: WHERE base_id=p_base_id;
478:
479: -- Cursor to get pig description
480: CURSOR cur_get_pig_desc (cp_pig_id igs_pe_persid_group_all.group_id%TYPE)
481: IS
482: SELECT description
483: FROM igs_pe_persid_group_all
484: WHERE group_id = cp_pig_id;

Line 483: FROM igs_pe_persid_group_all

479: -- Cursor to get pig description
480: CURSOR cur_get_pig_desc (cp_pig_id igs_pe_persid_group_all.group_id%TYPE)
481: IS
482: SELECT description
483: FROM igs_pe_persid_group_all
484: WHERE group_id = cp_pig_id;
485:
486: --For display of heading and parameters passed
487: TYPE l_parameters IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;

Line 503: l_pig_desc igs_pe_persid_group_all.description%TYPE;

499: l_party_id hz_parties.party_id%TYPE;
500: l_per_exists BOOLEAN := FALSE;
501: l_list VARCHAR2(32767);
502: l_status VARCHAR2(1);
503: l_pig_desc igs_pe_persid_group_all.description%TYPE;
504: PARAM_ERR EXCEPTION;
505: TYPE l_per_ref_cur IS REF CURSOR;
506: l_per_cur l_per_ref_cur;
507: lv_group_type igs_pe_persid_group_v.group_type%TYPE;