APPS.IGS_UC_EXT_MARVIN dependencies on IGS_UC_CYC_DEFAULTS

Line 1115: FROM igs_uc_cyc_defaults

1111: FROM IGS_UC_TRANSACTIONS
1112: WHERE
1113: system_code = NVL(cp_system_code,system_code) AND
1114: NVL(cp_system_code,system_code) IN (SELECT system_code
1115: FROM igs_uc_cyc_defaults
1116: WHERE ucas_interface = 'M' AND
1117: ucas_cycle = cp_config_cycle) AND
1118: ucas_cycle = cp_config_cycle AND
1119: sent_to_ucas = 'N' AND

Line 1243: CURSOR ucas_systems_cur (cp_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE) IS

1239: FROM IGS_UC_DEFAULTS ;
1240:
1241: -- Bug No: 3156212. Cursor changed to consider only MARVIN interface.
1242: -- Fetch all the UCAS Systems setup in the System
1243: CURSOR ucas_systems_cur (cp_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE) IS
1244: SELECT DISTINCT ucd.system_code system_code,
1245: DECODE(ucd.system_code,'U',1,'G',2,'N',3,'S',4,5)
1246: FROM IGS_UC_DEFAULTS ucd, IGS_UC_CYC_DEFAULTS uccd
1247: WHERE ucd.system_code = uccd.system_code AND

Line 1246: FROM IGS_UC_DEFAULTS ucd, IGS_UC_CYC_DEFAULTS uccd

1242: -- Fetch all the UCAS Systems setup in the System
1243: CURSOR ucas_systems_cur (cp_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE) IS
1244: SELECT DISTINCT ucd.system_code system_code,
1245: DECODE(ucd.system_code,'U',1,'G',2,'N',3,'S',4,5)
1246: FROM IGS_UC_DEFAULTS ucd, IGS_UC_CYC_DEFAULTS uccd
1247: WHERE ucd.system_code = uccd.system_code AND
1248: uccd.ucas_cycle = cp_ucas_cycle AND
1249: uccd.ucas_interface = 'M'
1250: ORDER BY 2;