APPS.CZ_FCE_COMPILE dependencies on CZ_RP_ENTRIES

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

844:
845: -- LA 13733007 : OC with No children
846: TYPE tNoChildOCNodeId IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
847: TYPE tNoChildOCName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
848: TYPE tNoChildOCModelName IS TABLE OF cz_rp_entries.name%TYPE INDEX BY BINARY_INTEGER;
849: lNoChildOCNodeId tNoChildOCNodeId ;
850: lNoChildOCName tNoChildOCName ;
851: lNoChildOCModelName tNoChildOCModelName;
852:

Line 863: FROM cz_ps_nodes PARENT, cz_rp_entries MODEL

859: -- This query is used to report all the OCs under Root model and it's reference chain
860:
861: SELECT MODEL.NAME, PARENT.PS_NODE_ID, PARENT.NAME
862: BULK COLLECT INTO lNoChildOCModelName, lNoChildOCNodeId, lNoChildOCName
863: FROM cz_ps_nodes PARENT, cz_rp_entries MODEL
864: WHERE PARENT.deleted_flag = '0'
865: AND MODEL.deleted_flag = '0'
866: AND PARENT.devl_project_id = MODEL.object_id
867: AND MODEL.object_type = 'PRJ'

Line 2244: SELECT name INTO l_name FROM cz_rp_entries

2240: --it will not get this far without the data.
2241:
2242: IF ( t_psn_parentid ( p_index ) IS NULL ) THEN
2243:
2244: SELECT name INTO l_name FROM cz_rp_entries
2245: WHERE deleted_flag = '0'
2246: AND object_type = 'PRJ'
2247: AND object_id = t_psn_psnodeid ( p_index );
2248: