DBA Data[Home] [Help]

APPS.IGS_FI_PRC_ACCT_PKG dependencies on IGS_OR_UNIT_ACCTS

Line 230: CURSOR cur_or_unit_accts (cp_org_unit_cd igs_or_unit_accts.org_unit_cd%TYPE,

226:
227: --
228: --Get the Segment Values for the Organization Entity
229: --
230: CURSOR cur_or_unit_accts (cp_org_unit_cd igs_or_unit_accts.org_unit_cd%TYPE,
231: cp_start_dt igs_or_unit_accts.start_dt%TYPE)
232: IS
233: SELECT segment_num,segment_value
234: FROM igs_or_unit_accts

Line 231: cp_start_dt igs_or_unit_accts.start_dt%TYPE)

227: --
228: --Get the Segment Values for the Organization Entity
229: --
230: CURSOR cur_or_unit_accts (cp_org_unit_cd igs_or_unit_accts.org_unit_cd%TYPE,
231: cp_start_dt igs_or_unit_accts.start_dt%TYPE)
232: IS
233: SELECT segment_num,segment_value
234: FROM igs_or_unit_accts
235: WHERE org_unit_cd = cp_org_unit_cd

Line 234: FROM igs_or_unit_accts

230: CURSOR cur_or_unit_accts (cp_org_unit_cd igs_or_unit_accts.org_unit_cd%TYPE,
231: cp_start_dt igs_or_unit_accts.start_dt%TYPE)
232: IS
233: SELECT segment_num,segment_value
234: FROM igs_or_unit_accts
235: WHERE org_unit_cd = cp_org_unit_cd
236: AND start_dt = cp_start_dt;
237:
238: --