DBA Data[Home] [Help]

APPS.PAY_IP_RETRO_UPGRADE dependencies on PAY_ELEMENT_SPAN_USAGES_S

Line 109: select pay_element_span_usages_s.nextval, p_business_group_id, p_time_span_id,

105: (element_span_usage_id, business_group_id, time_span_id,
106: retro_component_usage_id, retro_element_type_id,
107: creation_date, created_by, last_update_date, last_updated_by,
108: last_update_login, object_version_number)
109: select pay_element_span_usages_s.nextval, p_business_group_id, p_time_span_id,
110: p_retro_comp_usage_id, p_retro_element_type_id,
111: sysdate, 2, sysdate, 2, 2, 1
112: from dual
113: WHERE not exists ( SELECT 1 FROM pay_element_span_usages pesu