APPS.IGS_UC_UPD_PENDING_TRANS_PKG dependencies on IGS_UC_CYC_DEFAULTS

Line 71: IGS_UC_CYC_DEFAULTS DFLTS

67: TRANS.MODULAR,
68: TRANS.PART_TIME
69: FROM
70: IGS_UC_TRANSACTIONS TRANS,
71: IGS_UC_CYC_DEFAULTS DFLTS
72: WHERE
73: TRANS.ERROR_CODE = -1
74: AND TRANS.SENT_TO_UCAS = 'Y'
75: AND TRANS.UCAS_CYCLE = cp_conf_cycle

Line 85: IGS_UC_CYC_DEFAULTS DFLTS

81: CURSOR c_pending_trans_count(cp_conf_cycle igs_uc_defaults.configured_cycle%TYPE) IS
82: SELECT COUNT(*)
83: FROM
84: IGS_UC_TRANSACTIONS TRANS,
85: IGS_UC_CYC_DEFAULTS DFLTS
86: WHERE
87: TRANS.ERROR_CODE = -1
88: AND TRANS.SENT_TO_UCAS = 'Y'
89: AND TRANS.UCAS_CYCLE = cp_conf_cycle