DBA Data[Home] [Help]

APPS.XLA_SOURCES_PKG dependencies on XLA_LINE_DEFN_JLT_ASSGNS

Line 789: , xla_line_defn_jlt_assgns xld

785: AND source_type_code = p_der_source_type_code
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

Line 834: xla_line_defn_jlt_assgns xld,

830: AND value_source_code = p_der_source_code
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

Line 903: FROM xla_line_defn_jlt_assgns xld,

899: AND value_source_type_code = p_der_source_type_code
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

Line 968: FROM xla_line_defn_jlt_assgns xld,

964: WHERE source_application_id = p_der_application_id
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

Line 1853: ,xla_line_defn_jlt_assgns xjl

1849: AND source_type_code = p_source_type_code
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

Line 1898: ,xla_line_defn_jlt_assgns xld

1894: AND value_source_code = p_source_code
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

Line 1969: FROM xla_line_defn_jlt_assgns pl

1965: AND value_source_type_code = p_source_type_code
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

Line 2032: FROM xla_line_defn_jlt_assgns pl

2028: WHERE source_application_id = p_application_id
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