DBA Data[Home] [Help]

APPS.XLA_LINE_DEFINITIONS_PVT dependencies on XLA_AAD_LINE_DEFN_ASSGNS

Line 12416: FROM xla_aad_line_defn_assgns xal

12412: CURSOR c_aads
12413: IS
12414: SELECT xpr.name product_rule_name
12415: ,xlk.meaning product_rule_owner
12416: FROM xla_aad_line_defn_assgns xal
12417: ,xla_product_rules_tl xpr
12418: ,xla_lookups xlk
12419: WHERE xpr.application_id = xal.application_id
12420: AND xpr.amb_context_code = xal.amb_context_code

Line 12527: FROM xla_aad_line_defn_assgns xal

12523: CURSOR c_aads
12524: IS
12525: SELECT xpa.entity_code, xpa.product_rule_type_code, xpa.product_rule_code
12526: ,xpa.locking_status_flag
12527: FROM xla_aad_line_defn_assgns xal
12528: ,xla_prod_acct_headers xpa
12529: WHERE xpa.application_id = xal.application_id
12530: AND xpa.amb_context_code = xal.amb_context_code
12531: AND xpa.product_rule_type_code = xal.product_rule_type_code

Line 12655: FROM xla_aad_line_defn_assgns xal

12651: CURSOR c_aads
12652: IS
12653: SELECT xpa.entity_code, xpa.product_rule_type_code, xpa.product_rule_code
12654: ,xpa.locking_status_flag
12655: FROM xla_aad_line_defn_assgns xal
12656: ,xla_prod_acct_headers xpa
12657: WHERE xpa.application_id = xal.application_id
12658: AND xpa.amb_context_code = xal.amb_context_code
12659: AND xpa.product_rule_type_code = xal.product_rule_type_code

Line 12955: FROM xla_aad_line_defn_assgns xal

12951: ,xpa.product_rule_type_code
12952: ,xpa.product_rule_code
12953: ,xpa.locking_status_flag
12954: ,xpa.validation_status_code
12955: FROM xla_aad_line_defn_assgns xal
12956: ,xla_prod_acct_headers xpa
12957: WHERE xpa.application_id = xal.application_id
12958: AND xpa.amb_context_code = xal.amb_context_code
12959: AND xpa.product_rule_type_code = xal.product_rule_type_code

Line 12975: FROM xla_aad_line_defn_assgns xal

12971: CURSOR c_update_aads IS
12972: SELECT xal.event_class_code
12973: , xal.product_rule_type_code
12974: , xal.product_rule_code
12975: FROM xla_aad_line_defn_assgns xal
12976: ,xla_prod_acct_headers xpa
12977: WHERE xpa.application_id = xal.application_id
12978: AND xpa.amb_context_code = xal.amb_context_code
12979: AND xpa.product_rule_type_code = xal.product_rule_type_code