423: mthd.default_lot_cost_type_id
424: INTO g_legal_entity_name, g_ledger_name,
425: g_cost_method_type, g_cost_type_code, g_cost_method,
426: g_default_cost_type_id
427: FROM org_organization_definitions le, gl_ledgers led,
428: cm_mthd_mst mthd, gem_lookups lk
429: WHERE le.organization_id = g_legal_entity_id
430: AND led.ledger_id = g_ledger_id
431: AND mthd.cost_type_id = g_cost_type_id
2367: SELECT
2368: d1.period_year fiscal_year, d1.period_num period,
2369: d1.period_start_date begin_date, d2.schedule_close_date period_end_date
2370: FROM
2371: org_organization_definitions org,
2372: org_acct_periods d1,
2373: org_acct_periods d2
2374: WHERE
2375: org.legal_entity = cp_le_id
2518: mthd.default_lot_cost_type_id
2519: INTO g_legal_entity_name, g_ledger_name,
2520: g_cost_method_type, g_cost_type_code, g_cost_method,
2521: g_default_cost_type_id
2522: FROM org_organization_definitions le, gl_ledgers led,
2523: cm_mthd_mst mthd, gem_lookups lk
2524: WHERE le.organization_id = g_legal_entity_id
2525: AND led.ledger_id = g_ledger_id
2526: AND mthd.cost_type_id = g_cost_type_id