DBA Data[Home] [Help]

APPS.OE_HEADER_ADJ_PCFWK dependencies on OE_PC_EXCLUSIONS

Line 225: FROM OE_PC_EXCLUSIONS e

221: AND decode(c.column_name, '',decode(p_check_all_cols_constraint,'Y',
222: nvl(p_column_name,'#NULL'),'#NULL'),c.column_name) = nvl(p_column_name,'#NULL')
223: AND NOT EXISTS (
224: SELECT 'EXISTS'
225: FROM OE_PC_EXCLUSIONS e
226: WHERE e.responsibility_id = p_responsibility_id
227: AND e.assignment_id = a.assignment_id
228: );
229: -- Cursor to select all update constraints that are applicable to insert

Line 253: FROM OE_PC_EXCLUSIONS e

249: AND decode(honored_by_def_flag,'N',decode(p_is_caller_defaulting,'Y','N','Y'),
250: nvl(honored_by_def_flag,'Y')) = 'Y'
251: AND NOT EXISTS (
252: SELECT 'EXISTS'
253: FROM OE_PC_EXCLUSIONS e
254: WHERE e.responsibility_id = p_responsibility_id
255: AND e.assignment_id = a.assignment_id
256: );
257: --Local Variables