APPS.IGF_SP_CREATE_BASE_REC dependencies on IGS_PE_PRSID_GRP_MEM

Line 70: p_person_group_id IN igs_pe_prsid_grp_mem.group_id%TYPE,

66: (errbuf OUT NOCOPY VARCHAR2,
67: retcode OUT NOCOPY NUMBER,
68: p_award_year IN VARCHAR2,
69: p_person_id IN igs_pe_person.person_id%TYPE,
70: p_person_group_id IN igs_pe_prsid_grp_mem.group_id%TYPE,
71: p_org_id IN NUMBER )
72: AS
73: ------------------------------------------------------------------------------------
74: --Created by : smanglm ( Oracle IDC)

Line 107: -- the records from view igs_pe_prsid_grp_mem

103: --shtatiko 25-MAR-2003 Bug# 2772277, Added parameter logging for PERSON, NAME, STATUS and REASON
104: -- Removed write_log_file and write_log_file_head.
105: -- Added log_person_details and log_status procedures
106: --smadathi 03-jun-2003 Bug 2620288. Modified cursor c_person_id to fetch
107: -- the records from view igs_pe_prsid_grp_mem
108: -- instead of igs_pe_prsid_grp_mem_v. This fix is done to remove
109: -- Non-mergable view exists in the select and to reduce shared memory
110: -- within the acceptable limit
111: -------------------------------------------------------------------------------------

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

104: -- Removed write_log_file and write_log_file_head.
105: -- Added log_person_details and log_status procedures
106: --smadathi 03-jun-2003 Bug 2620288. Modified cursor c_person_id to fetch
107: -- the records from view igs_pe_prsid_grp_mem
108: -- instead of igs_pe_prsid_grp_mem_v. This fix is done to remove
109: -- Non-mergable view exists in the select and to reduce shared memory
110: -- within the acceptable limit
111: -------------------------------------------------------------------------------------
112: l_cal_type igs_ca_inst.cal_type%TYPE;

Line 131: /*CURSOR c_person_id (cp_group_id igs_pe_prsid_grp_mem_v.group_id%TYPE) IS

127:
128: /*
129: cursor to fetch person_id based on the person_group_id
130: */
131: /*CURSOR c_person_id (cp_group_id igs_pe_prsid_grp_mem_v.group_id%TYPE) IS
132: SELECT person_id
133: FROM igs_pe_prsid_grp_mem
134: WHERE group_id = cp_group_id
135: AND (TRUNC(start_date) <= TRUNC(SYSDATE) OR (start_date IS NULL))

Line 133: FROM igs_pe_prsid_grp_mem

129: cursor to fetch person_id based on the person_group_id
130: */
131: /*CURSOR c_person_id (cp_group_id igs_pe_prsid_grp_mem_v.group_id%TYPE) IS
132: SELECT person_id
133: FROM igs_pe_prsid_grp_mem
134: WHERE group_id = cp_group_id
135: AND (TRUNC(start_date) <= TRUNC(SYSDATE) OR (start_date IS NULL))
136: AND (TRUNC(end_date) >= TRUNC(SYSDATE) OR (end_date IS NULL));*/
137: