APPS.CN_COLLECT_CUSTOM dependencies on CN_OBJECTS

Line 22: package_name cn_objects.name%TYPE;

18: p_table_map_id IN NUMBER
19: ) -- Added as part of MOAC Changes
20: IS
21:
22: package_name cn_objects.name%TYPE;
23: dummy_vch VARCHAR2(2);
24: dummy_num NUMBER;
25: c INTEGER;
26: rows_processed INTEGER;

Line 41: FROM cn_table_map_objects tmov, cn_objects obj

37: --+
38: MO_GLOBAL.SET_POLICY_CONTEXT ('S',x_org_id);
39: SELECT OBJ.name
40: INTO package_name
41: FROM cn_table_map_objects tmov, cn_objects obj
42: WHERE tmov.table_map_id = p_table_map_id
43: and obj.object_id = tmov.object_id
44: AND tmov.tm_object_type = 'PKS'
45: and tmov.org_id = obj.org_id