APPS.CZ_LOGIC_GEN dependencies on CZ_RP_ENTRIES

Line 388: TYPE tNoChildOCModelName IS TABLE OF cz_rp_entries.name%TYPE INDEX BY BINARY_INTEGER;

384: instantiableContext NUMBER; -- jonatara:bug7041718
385:
386: -- LA 13733007 : OC with No children
387: TYPE tNoChildOCName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
388: TYPE tNoChildOCModelName IS TABLE OF cz_rp_entries.name%TYPE INDEX BY BINARY_INTEGER;
389: lNoChildOCName tNoChildOCName ;
390: lNoChildOCModelName tNoChildOCModelName;
391:
392: ---------------------------------------------------------------------------------------

Line 11103: FROM cz_ps_nodes PARENT, cz_rp_entries MODEL

11099: IF(inComponentId = inDevlProjectId)THEN
11100: BEGIN
11101: SELECT MODEL.NAME, PARENT.NAME
11102: BULK COLLECT INTO lNoChildOCModelName, lNoChildOCName
11103: FROM cz_ps_nodes PARENT, cz_rp_entries MODEL
11104: WHERE PARENT.deleted_flag = '0'
11105: AND MODEL.deleted_flag = '0'
11106: AND PARENT.devl_project_id = MODEL.object_id
11107: AND MODEL.object_type = 'PRJ'

Line 11433: AND EXISTS (SELECT null FROM cz_rp_entries

11429: SELECT effectivity_set_id, effective_from, effective_until
11430: BULK COLLECT INTO gvSetId, gvEffFrom, gvEffUntil
11431: FROM cz_effectivity_sets
11432: WHERE deleted_flag = FLAG_NOT_DELETED
11433: AND EXISTS (SELECT null FROM cz_rp_entries
11434: WHERE object_type='EFF'
11435: AND deleted_flag = FLAG_NOT_DELETED
11436: AND object_id = effectivity_set_id);
11437: