APPS.ARH_CLASSIFICATION_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 276: FROM hz_code_assignments

272: RETURN VARCHAR2
273: IS
274: CURSOR c_insert IS
275: SELECT 'Y'
276: FROM hz_code_assignments
277: WHERE owner_table_id = p_owner_table_id
278: AND owner_table_name = p_owner_table_name
279: AND class_category = p_class_category
280: AND class_code = p_class_code

Line 289: FROM hz_code_assignments a,

285: decode(status,'I','EXC','INC'))='Y';
286:
287: CURSOR c_update IS
288: SELECT 'Y'
289: FROM hz_code_assignments a,
290: hz_code_assignments b
291: WHERE a.code_assignment_id = p_code_assignment_id
292: AND a.owner_table_name = b.owner_table_name
293: AND a.owner_table_id = b.owner_table_id

Line 290: hz_code_assignments b

286:
287: CURSOR c_update IS
288: SELECT 'Y'
289: FROM hz_code_assignments a,
290: hz_code_assignments b
291: WHERE a.code_assignment_id = p_code_assignment_id
292: AND a.owner_table_name = b.owner_table_name
293: AND a.owner_table_id = b.owner_table_id
294: AND a.class_category = b.class_category

Line 347: FROM hz_code_assignments

343: RETURN VARCHAR2
344: IS
345: CURSOR c IS
346: SELECT 'Y'
347: FROM hz_code_assignments
348: WHERE owner_table_id = p_owner_table_id
349: AND owner_table_name = p_owner_table_name
350: AND class_category = p_class_category
351: AND class_code = p_class_code

Line 391: FROM hz_code_assignments

387: RETURN VARCHAR2
388: IS
389: CURSOR c1 IS
390: SELECT 'Y'
391: FROM hz_code_assignments
392: WHERE owner_table_name = p_owner_table_name
393: AND owner_table_id = p_owner_table_id
394: AND class_category = p_class_category
395: AND class_code = p_class_code

Line 434: FROM hz_code_assignments

430: RETURN VARCHAR2
431: IS
432: CURSOR c IS
433: SELECT 'Y'
434: FROM hz_code_assignments
435: WHERE owner_table_name = p_owner_table_name
436: AND owner_table_id = p_owner_table_id
437: AND class_category = p_class_category
438: AND class_code = p_class_code;

Line 656: FROM hz_code_assignments

652: SELECT ROWID,
653: START_DATE_ACTIVE,
654: OBJECT_VERSION_NUMBER,
655: LAST_UPDATE_DATE
656: FROM hz_code_assignments
657: WHERE Code_assignment_id = p_code_assignment_id;
658: l_code_assignment_rec HZ_CLASSIFICATION_V2PUB.CODE_ASSIGNMENT_REC_TYPE;
659: tmp_var VARCHAR2(2000);
660: i NUMBER;

Line 811: FROM hz_code_assignments

807: RETURN VARCHAR2
808: IS
809: CURSOR c IS
810: SELECT 'Y'
811: FROM hz_code_assignments
812: WHERE owner_table_name = p_owner_table_name
813: AND owner_table_id = p_owner_table_id
814: AND class_category = p_class_category
815: AND class_code = p_class_code