APPS.PJI_PMV_AVL dependencies on PJI_AVL_THRESHOLDS_V

Line 141: FROM PJI_AVL_THRESHOLDS_V

137: IF G_AVL_THRESHOLD_VAL IS NULL THEN
138: BEGIN
139: SELECT VALUE
140: INTO G_AVL_THRESHOLD_VAL
141: FROM PJI_AVL_THRESHOLDS_V
142: WHERE ID = P_THRESHOLD;
143: EXCEPTION
144: WHEN OTHERS THEN
145: G_AVL_THRESHOLD_VAL := 100;

Line 153: FROM PJI_AVL_THRESHOLDS_V;

149: IF P_THRESHOLD IS NULL THEN
150: BEGIN
151: SELECT DISTINCT
152: FIRST_VALUE(ID) OVER (ORDER BY VALUE DESC) INTO L_THRESHOLD
153: FROM PJI_AVL_THRESHOLDS_V;
154: END;
155: END IF;
156:
157:

Line 644: FROM PJI_AVL_THRESHOLDS_V;

640: IF P_THRESHOLD IS NULL THEN
641: BEGIN
642: SELECT DISTINCT
643: FIRST_VALUE(ID) OVER (ORDER BY VALUE DESC) INTO L_THRESHOLD
644: FROM PJI_AVL_THRESHOLDS_V;
645: END;
646: END IF;
647:
648:

Line 971: FROM PJI_AVL_THRESHOLDS_V;

967: IF P_THRESHOLD IS NULL THEN
968: BEGIN
969: SELECT DISTINCT
970: FIRST_VALUE(ID) OVER (ORDER BY VALUE DESC) INTO L_THRESHOLD
971: FROM PJI_AVL_THRESHOLDS_V;
972: END;
973: END IF;
974:
975:

Line 1296: FROM PJI_AVL_THRESHOLDS_V;

1292: IF P_THRESHOLD IS NULL THEN
1293: BEGIN
1294: SELECT DISTINCT
1295: FIRST_VALUE(ID) OVER (ORDER BY VALUE DESC) INTO L_THRESHOLD
1296: FROM PJI_AVL_THRESHOLDS_V;
1297: END;
1298: END IF;
1299:
1300:

Line 1763: FROM PJI_AVL_THRESHOLDS_V;

1759:
1760: IF P_THRESHOLD is null then
1761: SELECT distinct
1762: first_value(ID) over (ORDER BY VALUE DESC) into l_Threshold
1763: FROM PJI_AVL_THRESHOLDS_V;
1764: END IF;
1765: -- end of snippet (bug4001112)
1766:
1767: FOR i IN 1..P_AVL_RES_DET_TBL.LAST