eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SP_AWARD dependencies on IGS_PE_PRSID_GRP_MEM

Line 2156: p_person_group_id IN igs_pe_prsid_grp_mem.group_id%TYPE,

2152: retcode OUT NOCOPY NUMBER,
2153: p_award_year IN VARCHAR2,
2154: p_term_calendar IN VARCHAR2,
2155: p_person_id IN igs_pe_person.person_id%TYPE,
2156: p_person_group_id IN igs_pe_prsid_grp_mem.group_id%TYPE,
2157: p_fund_id IN igf_sp_stdnt_rel.fund_id%TYPE,
2158: p_award_type IN igf_aw_awd_disb.trans_type%TYPE,
2159: p_test_mode IN VARCHAR2,
2160: p_org_id IN NUMBER)

Line 2209: -- to fetch the records from view igs_pe_prsid_grp_mem

2205: -- Sponsor Code parameter is made optional
2206: --pathipat 25-Apr-2003 Enh 2831569 - Commercial Receivables build
2207: -- Added check for manage_accounts - call to chk_manage_account()
2208: --smadathi 30-Jan-2002 Bug 2620302. Cursor c_person_id_grp select modified
2209: -- to fetch the records from view igs_pe_prsid_grp_mem
2210: -- instead of igs_pe_prsid_grp_mem_v. This fix is done to remove
2211: -- Non-mergablity and to reduce shared memory. Also modified the
2212: -- cursor c_igs_lookups modified to fetch only active look up codes
2213: --smadathi 02-jul-2002 Bug 2427996. Cursor c_person_id_grp modified to select only active person id

Line 2210: -- instead of igs_pe_prsid_grp_mem_v. This fix is done to remove

2206: --pathipat 25-Apr-2003 Enh 2831569 - Commercial Receivables build
2207: -- Added check for manage_accounts - call to chk_manage_account()
2208: --smadathi 30-Jan-2002 Bug 2620302. Cursor c_person_id_grp select modified
2209: -- to fetch the records from view igs_pe_prsid_grp_mem
2210: -- instead of igs_pe_prsid_grp_mem_v. This fix is done to remove
2211: -- Non-mergablity and to reduce shared memory. Also modified the
2212: -- cursor c_igs_lookups modified to fetch only active look up codes
2213: --smadathi 02-jul-2002 Bug 2427996. Cursor c_person_id_grp modified to select only active person id
2214: -- belonging to the group. The logic for logging the message IGF_SP_NO_PERSON

Line 2280: TYPE person_grp_rec_type IS RECORD (l_n_person_id igs_pe_prsid_grp_mem.person_id%TYPE );

2276: l_dynamic_sql VARCHAR2(2000);
2277: l_v_status VARCHAR2(10);
2278:
2279: -- Record of person_id to get the values of
2280: TYPE person_grp_rec_type IS RECORD (l_n_person_id igs_pe_prsid_grp_mem.person_id%TYPE );
2281: rec_person_grp person_grp_rec_type;
2282:
2283: l_b_award_year BOOLEAN;
2284: l_b_term BOOLEAN;