6001: INTO l_upgrade_check
6002: FROM DUAL
6003: WHERE EXISTS
6004: (SELECT 1
6005: FROM gl_ledger_relationships
6006: WHERE hist_conv_status_code = 'SUCCESSFUL'
6007: AND primary_ledger_id = l_primary_ledger_id
6008: AND relationship_enabled_flag = 'Y');
6009: EXCEPTION WHEN OTHERS THEN
6026: SELECT max(glp.start_date)
6027: INTO l_max_first_open_period
6028: FROM gl_period_statuses glp,
6029: gl_ledgers gl,
6030: gl_ledger_relationships glr
6031: WHERE glp.period_name = gl.first_ledger_period_name
6032: AND glp.ledger_id = gl.ledger_id
6033: AND glp.application_id = 101
6034: AND gl.ledger_id = glr.target_ledger_id