802: , xpah.description_type_code
803: , REPLACE( xdtl.name , '''','''''')
804: FROM xla_prod_acct_headers xpah
805: , xla_descriptions_tl xdtl
806: , xla_descriptions_b xdb
807: , xla_aad_line_defn_assgns xald
808: , xla_line_definitions_b xld
809:
810: WHERE xpah.application_id = p_application_id
848: FROM xla_aad_line_defn_assgns xald
849: , xla_line_defn_jlt_assgns xldj
850: , xla_prod_acct_headers xpah
851: , xla_descriptions_tl xdtl
852: , xla_descriptions_b xdb
853: , xla_line_definitions_b xld
854: WHERE xpah.application_id = p_application_id
855: AND xpah.amb_context_code = p_amb_context_code
856: AND xpah.product_rule_type_code = p_product_rule_type_code
905: FROM xla_prod_acct_headers xpah
906: , xla_aad_line_defn_assgns xald
907: , xla_line_defn_jlt_assgns xldj
908: , xla_descriptions_tl xdtl
909: , xla_descriptions_b xdb
910: , xla_line_definitions_b xld
911: WHERE xpah.application_id = p_application_id
912: AND xpah.amb_context_code = p_amb_context_code
913: AND xpah.product_rule_type_code = p_product_rule_type_code
962: , xla_aad_line_defn_assgns xald
963: , xla_mpa_jlt_assgns xmja
964: , xla_line_defn_jlt_assgns xldj
965: , xla_descriptions_tl xdtl
966: , xla_descriptions_b xdb
967: , xla_line_definitions_b xld
968: WHERE xpah.application_id = p_application_id
969: AND xpah.amb_context_code = p_amb_context_code
970: AND xpah.product_rule_type_code = p_product_rule_type_code