APPS.XLE_ASSOC_VALIDATIONS_PVT dependencies on XLE_ASSOCIATION_TYPES

Line 56: FROM XLE_ASSOCIATION_TYPES

52:
53: IS
54: CURSOR Context_Cursor IS
55: SELECT Association_Type_Id
56: FROM XLE_ASSOCIATION_TYPES
57: WHERE CONTEXT = upper(p_context);
58: l_association_type_id NUMBER;
59: BEGIN
60:

Line 233: FROM XLE_ASSOCIATION_TYPES

229:
230: BEGIN
231: SELECT ASSOCIATION_TYPE_ID
232: INTO x_association_type_id
233: FROM XLE_ASSOCIATION_TYPES
234: WHERE CONTEXT = upper(p_context)
235: AND SUBJECT_TYPE_ID = p_subject_type
236: AND OBJECT_TYPE_ID = p_object_type;
237:

Line 277: FROM XLE_ASSOCIATION_TYPES AT,

273:
274: BEGIN
275: SELECT AT.ASSOCIATION_TYPE_ID
276: INTO x_association_type_id
277: FROM XLE_ASSOCIATION_TYPES AT,
278: XLE_ASSOC_OBJECT_TYPES ST,
279: XLE_ASSOC_OBJECT_TYPES OT
280: WHERE AT.CONTEXT = p_context
281: AND AT.SUBJECT_TYPE_ID = ST.object_type_id

Line 326: FROM XLE_ASSOCIATION_TYPES

322:
323: CURSOR Association_Type_Cursor
324: IS
325: SELECT *
326: FROM XLE_ASSOCIATION_TYPES
327: WHERE ASSOCIATION_TYPE_ID = p_association_type_id;
328:
329: CURSOR Association_Subject_Cursor
330: IS

Line 345: l_association_type_rec XLE_ASSOCIATION_TYPES%ROWTYPE;

341: WHERE ASSOCIATION_TYPE_ID = p_association_type_id
342: AND OBJECT_ID = p_object_id
343: AND EFFECTIVE_TO IS NULL;
344:
345: l_association_type_rec XLE_ASSOCIATION_TYPES%ROWTYPE;
346: l_association_subject_rec XLE_ASSOCIATIONS%ROWTYPE;
347: l_association_object_rec XLE_ASSOCIATIONS%ROWTYPE;
348:
349:

Line 508: FROM XLE_ASSOCIATION_TYPES

504:
505: CURSOR Association_Type_Cursor
506: IS
507: SELECT *
508: FROM XLE_ASSOCIATION_TYPES
509: WHERE ASSOCIATION_TYPE_ID = p_association_type_id;
510:
511: l_association_type_rec XLE_ASSOCIATION_TYPES%ROWTYPE;
512:

Line 511: l_association_type_rec XLE_ASSOCIATION_TYPES%ROWTYPE;

507: SELECT *
508: FROM XLE_ASSOCIATION_TYPES
509: WHERE ASSOCIATION_TYPE_ID = p_association_type_id;
510:
511: l_association_type_rec XLE_ASSOCIATION_TYPES%ROWTYPE;
512:
513: BEGIN
514:
515: OPEN Association_Type_Cursor;