DBA Data[Home] [Help]

APPS.IGS_FI_PRC_ACCT_PKG dependencies on IGS_PS_ACCTS

Line 11: lv_segment_value igs_ps_accts.segment_value%TYPE,

7:
8: TYPE accsegs IS RECORD(
9: l_segment igs_fi_acct_segs_v.segment%TYPE,
10: lv_Segment_num igs_fi_acct_segs_v.segment_num%TYPE,
11: lv_segment_value igs_ps_accts.segment_value%TYPE,
12: l_value_length fnd_flex_Value_Sets.maximum_size%TYPE);
13:
14: TYPE accsegs_list IS TABLE OF accsegs;
15:

Line 199: CURSOR cur_ps_accts (cp_course_cd igs_ps_accts.course_cd%TYPE,

195:
196: --
197: --Get the Segment Values for the Program Entity
198: --
199: CURSOR cur_ps_accts (cp_course_cd igs_ps_accts.course_cd%TYPE,
200: cp_version_number igs_ps_accts.version_number%TYPE)
201: IS
202: SELECT segment_num,segment_value
203: FROM igs_ps_accts

Line 200: cp_version_number igs_ps_accts.version_number%TYPE)

196: --
197: --Get the Segment Values for the Program Entity
198: --
199: CURSOR cur_ps_accts (cp_course_cd igs_ps_accts.course_cd%TYPE,
200: cp_version_number igs_ps_accts.version_number%TYPE)
201: IS
202: SELECT segment_num,segment_value
203: FROM igs_ps_accts
204: WHERE course_cd= cp_course_cd

Line 203: FROM igs_ps_accts

199: CURSOR cur_ps_accts (cp_course_cd igs_ps_accts.course_cd%TYPE,
200: cp_version_number igs_ps_accts.version_number%TYPE)
201: IS
202: SELECT segment_num,segment_value
203: FROM igs_ps_accts
204: WHERE course_cd= cp_course_cd
205: AND version_number = cp_version_number;
206:
207: --