APPS.PJI_EV_UTIL dependencies on PJI_PRD_PER_COMPLETE_TMP

Line 80: DELETE PJI_PRD_PER_COMPLETE_TMP;

76: OPEN object_type;
77: FETCH object_type INTO l_object_type;
78: CLOSE object_type;
79:
80: DELETE PJI_PRD_PER_COMPLETE_TMP;
81:
82: /* If calendar is enterprise, then open the corresponding cursor and fetch the percent complete */
83: IF (l_calendar_type = 'E')
84: THEN

Line 100: INSERT INTO PJI_PRD_PER_COMPLETE_TMP (period_id,completed_percentage) VALUES

96: ELSE
97: l_completed_per := NULL;
98: END IF;
99:
100: INSERT INTO PJI_PRD_PER_COMPLETE_TMP (period_id,completed_percentage) VALUES
101: (rec_ent_periods.period_id,l_completed_per);
102:
103: END LOOP;
104:

Line 124: INSERT INTO PJI_PRD_PER_COMPLETE_TMP (period_id,completed_percentage) VALUES

120: ELSE
121: l_completed_per := NULL;
122: END IF;
123:
124: INSERT INTO PJI_PRD_PER_COMPLETE_TMP (period_id,completed_percentage) VALUES
125: (rec_gl_pa_periods.period_id,l_completed_per );
126:
127:
128: END LOOP;