DBA Data[Home] [Help]

APPS.XLA_VALIDATIONS_PKG dependencies on FND_APPLICATION_TL

Line 104: , fnd_application_tl fat

100: CURSOR c_prod_rule
101: IS
102: SELECT fat.application_name, xpr.name, xlk.meaning product_rule_type_dsp
103: FROM xla_product_rules_tl xpr
104: , fnd_application_tl fat
105: , xla_lookups xlk
106: WHERE xlk.lookup_type = 'XLA_OWNER_TYPE'
107: AND xlk.lookup_code = xpr.product_rule_type_code
108: AND fat.application_id = xpr.application_id

Line 166: , fnd_application_tl fat

162: CURSOR c_desc_rule
163: IS
164: SELECT fat.application_name, xdt.name, xlk.meaning description_type_code_dsp
165: FROM xla_descriptions_tl xdt
166: , fnd_application_tl fat
167: , xla_lookups xlk
168: WHERE xlk.lookup_type = 'XLA_OWNER_TYPE'
169: AND xlk.lookup_code = xdt.description_type_code
170: AND fat.application_id = xdt.application_id

Line 228: , fnd_application_tl fat

224: CURSOR c_seg_rule
225: IS
226: SELECT fat.application_name, xsr.name, xlk.meaning segment_rule_type_dsp
227: FROM xla_seg_rules_tl xsr
228: , fnd_application_tl fat
229: , xla_lookups xlk
230: WHERE xlk.lookup_type = 'XLA_OWNER_TYPE'
231: AND xlk.lookup_code = xsr.segment_rule_type_code
232: AND fat.application_id = xsr.application_id

Line 293: , fnd_application_tl fat

289: CURSOR c_line_type
290: IS
291: SELECT fat.application_name, xal.name, xlk.meaning accounting_line_type_dsp
292: FROM xla_acct_line_types_tl xal
293: , fnd_application_tl fat
294: , xla_lookups xlk
295: WHERE xlk.lookup_type = 'XLA_OWNER_TYPE'
296: AND xlk.lookup_code = xal.accounting_line_type_code
297: AND fat.application_id = xal.application_id

Line 622: FROM fnd_application_tl

618: --
619: CURSOR c_application
620: IS
621: SELECT application_name
622: FROM fnd_application_tl
623: WHERE application_id = p_application_id
624: AND language = USERENV('LANG');
625:
626: BEGIN