APPS.GMF_MIGRATION dependencies on GEM_LOOKUPS

Line 1063: l_Line_type_code gem_lookups.meaning%TYPE;

1059: /************************
1060: * Local Variables *
1061: ************************/
1062:
1063: l_Line_type_code gem_lookups.meaning%TYPE;
1064: l_om NUMBER;
1065: l_opm_om VARCHAR2(10);
1066:
1067: /****************

Line 1077: FROM gem_lookups

1073: p_Line_type IN NUMBER
1074: )
1075: IS
1076: SELECT meaning
1077: FROM gem_lookups
1078: WHERE lookup_type = 'LINE_TYPE'
1079: AND nvl(start_date_active,sysdate) <= sysdate
1080: AND nvl(end_date_active,sysdate) >= sysdate
1081: AND enabled_flag = 'Y'

Line 6497: l_Line_type_code GEM_LOOKUPS.meaning%TYPE;

6493: l_routing_vers GMD_ROUTINGS_B.routing_vers%TYPE;
6494: l_price_element_type_id PO_COST_MST.price_element_type_id%TYPE;
6495: l_cost_cmpntcls_code CM_CMPT_MST.cost_cmpntcls_code%TYPE;
6496: l_Order_type_code OP_ORDR_TYP.Order_type_code%TYPE;
6497: l_Line_type_code GEM_LOOKUPS.meaning%TYPE;
6498: l_ar_trx_type_code RA_CUST_TRX_TYPES_ALL.name%TYPE;
6499:
6500: l_co_code t_co_code;
6501: l_orgn_code t_orgn_code;