DBA Data[Home] [Help]

APPS.IGS_FI_PRC_ACCT_PKG dependencies on IGS_PS_UNIT_ACCTS

Line 210: CURSOR cur_ps_unit_accts (cp_unit_cd igs_ps_unit_accts.unit_cd%TYPE,

206:
207: --
208: --Get the Segment Values for the Unit Entity
209: --
210: CURSOR cur_ps_unit_accts (cp_unit_cd igs_ps_unit_accts.unit_cd%TYPE,
211: cp_version_number igs_ps_unit_accts.version_number%TYPE)
212: IS
213: SELECT segment_num,segment_value
214: FROM igs_ps_unit_accts

Line 211: cp_version_number igs_ps_unit_accts.version_number%TYPE)

207: --
208: --Get the Segment Values for the Unit Entity
209: --
210: CURSOR cur_ps_unit_accts (cp_unit_cd igs_ps_unit_accts.unit_cd%TYPE,
211: cp_version_number igs_ps_unit_accts.version_number%TYPE)
212: IS
213: SELECT segment_num,segment_value
214: FROM igs_ps_unit_accts
215: WHERE unit_cd= cp_unit_cd

Line 214: FROM igs_ps_unit_accts

210: CURSOR cur_ps_unit_accts (cp_unit_cd igs_ps_unit_accts.unit_cd%TYPE,
211: cp_version_number igs_ps_unit_accts.version_number%TYPE)
212: IS
213: SELECT segment_num,segment_value
214: FROM igs_ps_unit_accts
215: WHERE unit_cd= cp_unit_cd
216: AND version_number = cp_version_number;
217:
218: --