DBA Data[Home] [Help]

APPS.PAY_NL_RULES dependencies on PAY_RETRO_COMPONENTS

Line 54: pay_retro_components prc,

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

Line 67: pay_retro_components prc,

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