DBA Data[Home] [Help]

APPS.PJI_PMV_UTIL dependencies on PJI_LOOKUPS

Line 44: FROM pji_lookups lkp,

40: l_labor_unit VARCHAR2(80);
41: BEGIN
42: SELECT lkp.meaning
43: INTO l_labor_unit
44: FROM pji_lookups lkp,
45: pji_system_settings setup
46: WHERE lkp.lookup_type = G_Labor_Units_LT
47: AND lkp.lookup_code = setup.report_labor_units;
48:

Line 1337: FROM pji_lookups

1333:
1334: BEGIN
1335: SELECT lookup_code, meaning
1336: BULK COLLECT INTO G_Measure_Short_Code, G_Measure_Label
1337: FROM pji_lookups
1338: WHERE lookup_type LIKE 'PJI_PMV_MSR_LABELS';
1339: EXCEPTION
1340: WHEN NO_DATA_FOUND THEN
1341: NULL;

Line 1355: FROM pji_lookups

1351: END;
1352:
1353: BEGIN
1354: SELECT meaning INTO G_Budget_Label
1355: FROM pji_lookups
1356: WHERE lookup_type = G_Graph_Labels_LT
1357: AND lookup_code = G_Budget_Label_LC ;
1358: EXCEPTION
1359: WHEN NO_DATA_FOUND THEN

Line 1365: FROM pji_lookups

1361: END;
1362:
1363: BEGIN
1364: SELECT meaning INTO G_Prior_Label
1365: FROM pji_lookups
1366: WHERE lookup_type = G_Graph_Labels_LT
1367: AND lookup_code = G_Prior_Budget_Label_LC ;
1368: EXCEPTION
1369: WHEN NO_DATA_FOUND THEN