DBA Data[Home] [Help]

APPS.GMF_SUBLEDGER_PKG dependencies on GEM_LOOKUPS

Line 428: cm_mthd_mst mthd, gem_lookups lk

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
432: AND lk.lookup_type = 'GMF_COST_METHOD'

Line 471: gem_lookups lk

467: g_cost_type_code,
468: g_cost_method,
469: g_default_cost_type_id
470: FROM cm_mthd_mst mthd,
471: gem_lookups lk
472: WHERE mthd.cost_type_id = g_cost_type_id
473: AND lk.lookup_type = 'GMF_COST_METHOD'
474: AND lk.lookup_code = mthd.cost_type ;
475: EXCEPTION

Line 2523: cm_mthd_mst mthd, gem_lookups lk

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
2527: AND lk.lookup_type = 'GMF_COST_METHOD'

Line 2566: gem_lookups lk

2562: g_cost_type_code,
2563: g_cost_method,
2564: g_default_cost_type_id
2565: FROM cm_mthd_mst mthd,
2566: gem_lookups lk
2567: WHERE mthd.cost_type_id = g_cost_type_id
2568: AND lk.lookup_type = 'GMF_COST_METHOD'
2569: AND lk.lookup_code = mthd.cost_type ;
2570: EXCEPTION