DBA Data[Home] [Help]

APPS.GMF_SUBLEDGER_PKG dependencies on GEM_LOOKUPS

Line 280: cm_mthd_mst mthd, gem_lookups lk

276: INTO g_legal_entity_name, g_ledger_name,
277: g_cost_method_type, g_cost_type_code, g_cost_method,
278: g_default_cost_type_id
279: FROM org_organization_definitions le, gl_ledgers led,
280: cm_mthd_mst mthd, gem_lookups lk
281: WHERE le.organization_id = g_legal_entity_id
282: AND led.ledger_id = g_ledger_id
283: AND mthd.cost_type_id = g_cost_type_id
284: AND lk.lookup_type = 'GMF_COST_METHOD'

Line 323: gem_lookups lk

319: g_cost_type_code,
320: g_cost_method,
321: g_default_cost_type_id
322: FROM cm_mthd_mst mthd,
323: gem_lookups lk
324: WHERE mthd.cost_type_id = g_cost_type_id
325: AND lk.lookup_type = 'GMF_COST_METHOD'
326: AND lk.lookup_code = mthd.cost_type ;
327: EXCEPTION

Line 2000: cm_mthd_mst mthd, gem_lookups lk

1996: INTO g_legal_entity_name, g_ledger_name,
1997: g_cost_method_type, g_cost_type_code, g_cost_method,
1998: g_default_cost_type_id
1999: FROM org_organization_definitions le, gl_ledgers led,
2000: cm_mthd_mst mthd, gem_lookups lk
2001: WHERE le.organization_id = g_legal_entity_id
2002: AND led.ledger_id = g_ledger_id
2003: AND mthd.cost_type_id = g_cost_type_id
2004: AND lk.lookup_type = 'GMF_COST_METHOD'

Line 2043: gem_lookups lk

2039: g_cost_type_code,
2040: g_cost_method,
2041: g_default_cost_type_id
2042: FROM cm_mthd_mst mthd,
2043: gem_lookups lk
2044: WHERE mthd.cost_type_id = g_cost_type_id
2045: AND lk.lookup_type = 'GMF_COST_METHOD'
2046: AND lk.lookup_code = mthd.cost_type ;
2047: EXCEPTION