APPS.EAM_OTL_TIMECARD_PUB dependencies on MTL_PARAMETERS

Line 1643: from mtl_parameters

1639: BEGIN
1640:
1641: select calendar_code
1642: into l_calendar_code
1643: from mtl_parameters
1644: where organization_id = p_organization_id;
1645:
1646:
1647: select SUM(days_off + days_on)

Line 1927: from mtl_system_items_b_kfv msik, mtl_parameters mp

1923: end if;
1924:
1925: if l_org_id <> -9999 and l_asset_group <> -9999 and l_asset_group is not null and l_org_id is not null then
1926: select distinct msik.concatenated_segments into l_asset_group_name
1927: from mtl_system_items_b_kfv msik, mtl_parameters mp
1928: where msik.inventory_item_id = l_asset_group
1929: and mp.maint_organization_id = l_org_id
1930: and mp.organization_id = msik.organization_id;
1931: end if;