APPS.XLA_SOURCES_PKG dependencies on XLA_AAD_LINE_DEFN_ASSGNS

Line 760: , xla_aad_line_defn_assgns xal

756: AND xpa.locking_status_flag = 'Y'
757: UNION
758: SELECT 'x'
759: FROM xla_line_defn_ac_assgns xld
760: , xla_aad_line_defn_assgns xal
761: , xla_prod_acct_headers xpa
762: WHERE xld.amb_context_code = xas.amb_context_code
763: AND xld.analytical_criterion_code = xas.analytical_criterion_code
764: AND xld.analytical_criterion_type_code = xas.analytical_criterion_type_code

Line 790: , xla_aad_line_defn_assgns xal

786: AND source_code is not null
787: AND exists (SELECT 'x'
788: FROM xla_desc_priorities xdp
789: , xla_line_defn_jlt_assgns xld
790: , xla_aad_line_defn_assgns xal
791: , xla_prod_acct_headers xpa
792: WHERE xdp.description_prio_id = xdd.description_prio_id
793: AND xld.application_id = xdp.application_id
794: AND xld.amb_context_code = xdp.amb_context_code

Line 835: xla_aad_line_defn_assgns xal,

831: AND value_source_code IS NOT NULL))
832: AND exists (SELECT 'x'
833: FROM xla_desc_priorities xdp,
834: xla_line_defn_jlt_assgns xld,
835: xla_aad_line_defn_assgns xal,
836: xla_prod_acct_headers xpa
837: WHERE xdp.description_prio_id = xco.description_prio_id
838: AND xld.application_id = xdp.application_id
839: AND xld.amb_context_code = xdp.amb_context_code

Line 870: xla_aad_line_defn_assgns xal,

866: AND value_source_code IS NOT NULL))
867: AND exists (SELECT 'x'
868: FROM xla_seg_rule_details xsd,
869: xla_line_defn_adr_assgns xld,
870: xla_aad_line_defn_assgns xal,
871: xla_prod_acct_headers xpa
872: WHERE xsd.segment_rule_detail_id = xco.segment_rule_detail_id
873: AND xld.application_id = xsd.application_id
874: AND xld.amb_context_code = xsd.amb_context_code

Line 904: xla_aad_line_defn_assgns xal,

900: AND value_source_code = p_der_source_code
901: AND value_source_code IS NOT NULL))
902: AND exists (SELECT 'x'
903: FROM xla_line_defn_jlt_assgns xld,
904: xla_aad_line_defn_assgns xal,
905: xla_prod_acct_headers xpa
906: WHERE xld.application_id = xco.application_id
907: AND xld.amb_context_code = xco.amb_context_code
908: AND xld.event_class_code = xco.event_class_code

Line 938: xla_aad_line_defn_assgns xal,

934: AND input_source_code = p_der_source_code
935: AND input_source_code IS NOT NULL))
936: AND exists (SELECT 'x'
937: FROM xla_line_defn_adr_assgns xld,
938: xla_aad_line_defn_assgns xal,
939: xla_prod_acct_headers xpa
940: WHERE xld.application_id = xsr.application_id
941: AND xld.amb_context_code = xsr.amb_context_code
942: AND xld.segment_rule_type_code = xsr.segment_rule_type_code

Line 969: xla_aad_line_defn_assgns xal,

965: AND source_code = p_der_source_code
966: AND source_type_code = p_der_source_type_code
967: AND exists (SELECT 'x'
968: FROM xla_line_defn_jlt_assgns xld,
969: xla_aad_line_defn_assgns xal,
970: xla_prod_acct_headers xpa
971: WHERE xld.application_id = xja.application_id
972: AND xld.amb_context_code = xja.amb_context_code
973: AND xld.event_class_code = xja.event_class_code

Line 1824: , xla_aad_line_defn_assgns xal

1820: AND xpa.locking_status_flag = 'Y'
1821: UNION
1822: SELECT 'x'
1823: FROM xla_line_defn_ac_assgns xad
1824: , xla_aad_line_defn_assgns xal
1825: , xla_prod_acct_headers xpa
1826: WHERE xad.amb_context_code = xas.amb_context_code
1827: AND xad.analytical_criterion_code = xas.analytical_criterion_code
1828: AND xad.analytical_criterion_type_code = xas.analytical_criterion_type_code

Line 1854: ,xla_aad_line_defn_assgns xal

1850: AND source_code is not null
1851: AND exists (SELECT 'x'
1852: FROM xla_desc_priorities xdp
1853: ,xla_line_defn_jlt_assgns xjl
1854: ,xla_aad_line_defn_assgns xal
1855: ,xla_prod_acct_headers xpa
1856: WHERE xdp.description_prio_id = xdd.description_prio_id
1857: AND xjl.application_id = xdp.application_id
1858: AND xjl.amb_context_code = xdp.amb_context_code

Line 1899: ,xla_aad_line_defn_assgns xal

1895: AND value_source_code IS NOT NULL))
1896: AND exists (SELECT 'x'
1897: FROM xla_desc_priorities xdp
1898: ,xla_line_defn_jlt_assgns xld
1899: ,xla_aad_line_defn_assgns xal
1900: ,xla_prod_acct_headers xpa
1901: WHERE xdp.description_prio_id = xco.description_prio_id
1902: AND xld.application_id = xdp.application_id
1903: AND xld.amb_context_code = xdp.amb_context_code

Line 1935: ,xla_aad_line_defn_assgns xal

1931: AND value_source_code IS NOT NULL))
1932: AND exists (SELECT 'x'
1933: FROM xla_seg_rule_details xsr
1934: ,xla_line_defn_adr_assgns xld
1935: ,xla_aad_line_defn_assgns xal
1936: ,xla_prod_acct_headers xpa
1937: WHERE xsr.segment_rule_detail_id = xco.segment_rule_detail_id
1938: AND xld.application_id = xsr.application_id
1939: AND xld.amb_context_code = xsr.amb_context_code

Line 1970: ,xla_aad_line_defn_assgns p

1966: AND value_source_code = p_source_code
1967: AND value_source_code IS NOT NULL))
1968: AND exists (SELECT 'x'
1969: FROM xla_line_defn_jlt_assgns pl
1970: ,xla_aad_line_defn_assgns p
1971: ,xla_prod_acct_headers xpa
1972: WHERE pl.application_id = c.application_id
1973: AND pl.amb_context_code = c.amb_context_code
1974: AND pl.event_class_code = c.event_class_code

Line 2004: ,xla_aad_line_defn_assgns p

2000: AND input_source_code = p_source_code
2001: AND input_source_code IS NOT NULL))
2002: AND exists (SELECT 'x'
2003: FROM xla_line_defn_adr_assgns pl
2004: ,xla_aad_line_defn_assgns p
2005: ,xla_prod_acct_headers xpa
2006: WHERE pl.application_id = sd.application_id
2007: AND pl.amb_context_code = sd.amb_context_code
2008: AND pl.segment_rule_type_code = sd.segment_rule_type_code

Line 2033: ,xla_aad_line_defn_assgns p

2029: AND source_code = p_source_code
2030: AND source_type_code = p_source_type_code
2031: AND exists (SELECT 'x'
2032: FROM xla_line_defn_jlt_assgns pl
2033: ,xla_aad_line_defn_assgns p
2034: ,xla_prod_acct_headers xpa
2035: WHERE pl.application_id = r.application_id
2036: AND pl.amb_context_code = r.amb_context_code
2037: AND pl.event_class_code = r.event_class_code