50: cursor c_standard_component(cp_element_type_id in number)
51: is
52: select prc.retro_component_id
53: from
54: pay_retro_components prc,
55: pay_retro_component_usages prcu
56: where
57: prcu.creator_id=cp_element_type_id
58: and prc.retro_component_id=prcu.retro_component_id
63: cursor c_replacement_component(cp_element_type_id in number)
64: is
65: select prc.retro_component_id
66: from
67: pay_retro_components prc,
68: pay_retro_component_usages prcu
69: where
70: prcu.creator_id=cp_element_type_id
71: and prc.retro_component_id=prcu.retro_component_id