3076: INTO l_period_set_name,
3077: l_period_name,
3078: l_period_start_date
3079: FROM gl_periods gp,
3080: gl_sets_of_books gsob,
3081: /*org_organization_definitions ood */
3082: cst_organization_definitions ood
3083: WHERE ood.organization_id = l_organization_id
3084: AND gsob.set_of_books_id = ood.set_of_books_id
10142:
10143: IF (c_cedi_rec.currency_code IS NULL) THEN
10144: SELECT currency_code
10145: INTO l_currency_code
10146: FROM gl_sets_of_books
10147: WHERE set_of_books_id = c_cedi_rec.set_of_books_id;
10148: Else
10149: l_currency_code := c_cedi_rec.currency_code;
10150: END IF;