1878: l_stmt_num := 100;
1879: SELECT min(crrl.acct_period_num)
1880: INTO l_phase3_required
1881: FROM cst_revenue_recognition_lines crrl,
1882: cst_revenue_cogs_match_lines crcml,
1883: cst_cost_group_assignments ccga,
1884: cst_cost_groups ccg
1885: WHERE crrl.ledger_id = l_ledger_id
1886: AND crrl.potentially_unmatched_flag = 'Y'