APPS.OE_LINE_SCREDIT_PCFWK dependencies on OE_PC_EXCLUSIONS

Line 221: FROM OE_PC_EXCLUSIONS e

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

Line 249: FROM OE_PC_EXCLUSIONS e

245: AND decode(honored_by_def_flag,'N',decode(p_is_caller_defaulting,'Y','N','Y'),
246: nvl(honored_by_def_flag,'Y')) = 'Y'
247: AND NOT EXISTS (
248: SELECT 'EXISTS'
249: FROM OE_PC_EXCLUSIONS e
250: WHERE e.responsibility_id = p_responsibility_id
251: AND e.assignment_id = a.assignment_id
252: );
253: