APPS.AR_INVOICE_VALIDATE_FLEX dependencies on FND_DESCR_FLEX_CONTEXTS

Line 16: from fnd_descr_flex_contexts ctx,

12: pc_desc_flex in varchar2) is
13: select ctx.descriptive_flex_context_code context_code,
14: substr(seg.application_column_name,
15: length('INTERFACE_LINE_ATTRIBUTE')+1) segment_num
16: from fnd_descr_flex_contexts ctx,
17: fnd_descr_flex_column_usages seg
18: where ctx.application_id = pc_appl_id
19: and ctx.descriptive_flexfield_name = pc_desc_flex
20: and ctx.application_id = seg.application_id(+)

Line 28: l_prior_context fnd_descr_flex_contexts.descriptive_flex_context_code%type;

24: seg.descriptive_flex_context_code(+)
25: and seg.enabled_flag (+) = 'Y'
26: order by ctx.descriptive_flex_context_code, seg.column_seq_num;
27:
28: l_prior_context fnd_descr_flex_contexts.descriptive_flex_context_code%type;
29: l_ctx_count number;
30: l_seg_count number;
31: l_total_seg_count number;
32: l_seg_number number;