APPS.PJI_PMV_UTIL dependencies on PJI_RM_RES_F

Line 132: FROM pji_rm_res_f

128: IF p_threshold = 1 THEN
129:
130: SELECT max(time_id)
131: INTO l_j_date
132: FROM pji_rm_res_f
133: WHERE person_id = p_person_id
134: and expenditure_organization_id = p_exp_org_id
135: and period_type_id = 1
136: and time_id between l_start_time and l_end_time

Line 143: FROM pji_rm_res_f

139: ELSIF p_threshold = 2 THEN
140:
141: SELECT max(time_id)
142: INTO l_j_date
143: FROM pji_rm_res_f
144: WHERE person_id = p_person_id
145: and expenditure_organization_id = p_exp_org_id
146: and period_type_id = 1
147: and time_id between l_start_time and l_end_time

Line 154: FROM pji_rm_res_f

150: ELSIF p_threshold = 3 THEN
151:
152: SELECT max(time_id)
153: INTO l_j_date
154: FROM pji_rm_res_f
155: WHERE person_id = p_person_id
156: and expenditure_organization_id = p_exp_org_id
157: and period_type_id = 1
158: and time_id between l_start_time and l_end_time

Line 165: FROM pji_rm_res_f

161: ELSIF p_threshold = 4 THEN
162:
163: SELECT max(time_id)
164: INTO l_j_date
165: FROM pji_rm_res_f
166: WHERE person_id = p_person_id
167: and expenditure_organization_id = p_exp_org_id
168: and period_type_id = 1
169: and time_id between l_start_time and l_end_time

Line 176: FROM pji_rm_res_f

172: ELSIF p_threshold = 5 THEN
173:
174: SELECT max(time_id)
175: INTO l_j_date
176: FROM pji_rm_res_f
177: WHERE person_id = p_person_id
178: and expenditure_organization_id = p_exp_org_id
179: and period_type_id = 1
180: and time_id between l_start_time and l_end_time

Line 242: FROM pji_rm_res_f

238: IF p_threshold = 1 THEN
239:
240: SELECT min(time_id)
241: INTO l_j_date
242: FROM pji_rm_res_f
243: WHERE person_id = p_person_id
244: and expenditure_organization_id = p_exp_org_id
245: and period_type_id = 1
246: and time_id between l_start_time and l_end_time

Line 253: FROM pji_rm_res_f

249: ELSIF p_threshold = 2 THEN
250:
251: SELECT min(time_id)
252: INTO l_j_date
253: FROM pji_rm_res_f
254: WHERE person_id = p_person_id
255: and expenditure_organization_id = p_exp_org_id
256: and period_type_id = 1
257: and time_id between l_start_time and l_end_time

Line 264: FROM pji_rm_res_f

260: ELSIF p_threshold = 3 THEN
261:
262: SELECT min(time_id)
263: INTO l_j_date
264: FROM pji_rm_res_f
265: WHERE person_id = p_person_id
266: and expenditure_organization_id = p_exp_org_id
267: and period_type_id = 1
268: and time_id between l_start_time and l_end_time

Line 275: FROM pji_rm_res_f

271: ELSIF p_threshold = 4 THEN
272:
273: SELECT min(time_id)
274: INTO l_j_date
275: FROM pji_rm_res_f
276: WHERE person_id = p_person_id
277: and expenditure_organization_id = p_exp_org_id
278: and period_type_id = 1
279: and time_id between l_start_time and l_end_time

Line 286: FROM pji_rm_res_f

282: ELSIF p_threshold = 5 THEN
283:
284: SELECT min(time_id)
285: INTO l_j_date
286: FROM pji_rm_res_f
287: WHERE person_id = p_person_id
288: and expenditure_organization_id = p_exp_org_id
289: and period_type_id = 1
290: and time_id between l_start_time and l_end_time