DBA Data[Home] [Help]

APPS.XLA_LINE_DEFINITIONS_PVT dependencies on XLA_JLT_ACCT_ATTRS

Line 3859: FROM xla_jlt_acct_attrs xco, xla_line_defn_jlt_assgns xld,

3855: SELECT distinct xld.event_class_code, xld.event_type_code,
3856: xld.accounting_line_type_code, xld.accounting_line_code,
3857: xco.source_type_code, xco.source_code
3858: ,xco.accounting_attribute_code
3859: FROM xla_jlt_acct_attrs xco, xla_line_defn_jlt_assgns xld,
3860: xla_acct_attributes_b xaab
3861: WHERE xld.application_id = p_application_id
3862: AND xld.amb_context_code = p_amb_context_code
3863: AND xld.event_class_code = p_event_class_code

Line 3894: FROM xla_jlt_acct_attrs xco, xla_line_defn_jlt_assgns xld

3890: SELECT distinct xld.event_class_code, xld.event_type_code,
3891: xld.accounting_line_type_code, xld.accounting_line_code,
3892: xco.source_type_code, xco.source_code
3893: ,xco.accounting_attribute_code
3894: FROM xla_jlt_acct_attrs xco, xla_line_defn_jlt_assgns xld
3895: WHERE xld.application_id = p_application_id
3896: AND xld.amb_context_code = p_amb_context_code
3897: AND xld.event_class_code = p_event_class_code
3898: AND xld.event_type_code = p_event_type_code

Line 4045: FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b jlt, xla_jlt_acct_attrs xja

4041: CURSOR c_non_pe_jlt IS
4042: SELECT xld.accounting_line_type_code
4043: ,xld.accounting_line_code
4044: ,xja.accounting_attribute_code
4045: FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b jlt, xla_jlt_acct_attrs xja
4046: WHERE xld.application_id = xja.application_id
4047: AND xld.amb_context_code = xja.amb_context_code
4048: AND xld.event_class_code = xja.event_class_code
4049: AND xld.accounting_line_type_code = xja.accounting_line_type_code

Line 4074: FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b jlt, xla_jlt_acct_attrs xja

4070: CURSOR c_pe_jlt IS
4071: SELECT xld.accounting_line_type_code
4072: ,xld.accounting_line_code
4073: ,xja.accounting_attribute_code
4074: FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b jlt, xla_jlt_acct_attrs xja
4075: WHERE xld.application_id = xja.application_id
4076: AND xld.amb_context_code = xja.amb_context_code
4077: AND xld.event_class_code = xja.event_class_code
4078: AND xld.accounting_line_type_code = xja.accounting_line_type_code

Line 4239: FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa

4235:
4236: CURSOR c_mapping_groups(l_accounting_line_type_code VARCHAR2
4237: ,l_accounting_line_code VARCHAR2) IS
4238: SELECT distinct xaa.assignment_group_code
4239: FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa
4240: WHERE xja.application_id = p_application_id
4241: AND xja.amb_context_code = p_amb_context_code
4242: AND xja.event_class_code = p_event_class_code
4243: AND xja.accounting_line_type_code = l_accounting_line_type_code

Line 4261: ,xla_jlt_acct_attrs xja

4257: ,l_accounting_line_code VARCHAR2
4258: ,l_assignment_group_code VARCHAR2) IS
4259: SELECT distinct xaa.accounting_attribute_code
4260: FROM xla_acct_attributes_b xaa
4261: ,xla_jlt_acct_attrs xja
4262: WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
4263: AND xaa.assignment_required_code = 'G'
4264: AND xaa.accounting_attribute_code = xja.accounting_attribute_code
4265: AND xaa.assignment_group_code = l_assignment_group_code

Line 4276: FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa

4272:
4273: CURSOR c_pe_mapping_groups(l_accounting_line_type_code VARCHAR2
4274: ,l_accounting_line_code VARCHAR2) IS
4275: SELECT distinct xaa.assignment_group_code
4276: FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa
4277: WHERE xja.application_id = p_application_id
4278: AND xja.amb_context_code = p_amb_context_code
4279: AND xja.event_class_code = p_event_class_code
4280: AND xja.accounting_line_type_code = l_accounting_line_type_code

Line 4299: ,xla_jlt_acct_attrs xja

4295: ,l_accounting_line_code VARCHAR2
4296: ,l_assignment_group_code VARCHAR2) IS
4297: SELECT distinct xaa.accounting_attribute_code
4298: FROM xla_acct_attributes_b xaa
4299: ,xla_jlt_acct_attrs xja
4300: WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
4301: AND xaa.assignment_required_code = 'G'
4302: AND xaa.accounting_attribute_code = xja.accounting_attribute_code
4303: AND xaa.assignment_group_code = l_assignment_group_code

Line 4316: ,xla_jlt_acct_attrs xja

4312: CURSOR c_bus_flow_acct_sources(l_accounting_line_type_code VARCHAR2
4313: ,l_accounting_line_code VARCHAR2) IS
4314: SELECT distinct xaa.accounting_attribute_code
4315: FROM xla_acct_attributes_b xaa
4316: ,xla_jlt_acct_attrs xja
4317: WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
4318: AND xaa.assignment_required_code = 'G'
4319: AND xaa.accounting_attribute_code = xja.accounting_attribute_code
4320: AND xaa.assignment_group_code = 'BUSINESS_FLOW'

Line 4332: ,xla_jlt_acct_attrs xja

4328: CURSOR c_mpa_acct_sources(l_accounting_line_type_code VARCHAR2
4329: ,l_accounting_line_code VARCHAR2) IS
4330: SELECT distinct xaa.accounting_attribute_code
4331: FROM xla_acct_attributes_b xaa
4332: ,xla_jlt_acct_attrs xja
4333: WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
4334: AND xaa.assignment_required_code = 'G'
4335: AND xaa.accounting_attribute_code = xja.accounting_attribute_code
4336: AND xaa.assignment_group_code = 'MULTIPERIOD_CODE'

Line 6661: ,xla_jlt_acct_attrs xja

6657: ,mpa.mpa_accounting_line_code
6658: ,xja.accounting_attribute_code
6659: FROM xla_line_defn_jlt_assgns xld
6660: ,xla_acct_line_types_b jlt
6661: ,xla_jlt_acct_attrs xja
6662: ,xla_mpa_jlt_assgns mpa
6663: WHERE jlt.application_id = xja.application_id
6664: AND jlt.amb_context_code = xja.amb_context_code
6665: AND jlt.event_class_code = xja.event_class_code

Line 6712: ,xla_jlt_acct_attrs xja

6708: ,mpa.mpa_accounting_line_code
6709: ,xja.accounting_attribute_code
6710: FROM xla_line_defn_jlt_assgns xld
6711: ,xla_acct_line_types_b jlt
6712: ,xla_jlt_acct_attrs xja
6713: ,xla_mpa_jlt_assgns mpa
6714: WHERE jlt.application_id = xja.application_id
6715: AND jlt.amb_context_code = xja.amb_context_code
6716: AND jlt.event_class_code = xja.event_class_code

Line 6917: FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa

6913:
6914: CURSOR c_mapping_groups(l_accounting_line_type_code VARCHAR2
6915: ,l_accounting_line_code VARCHAR2) IS
6916: SELECT distinct xaa.assignment_group_code
6917: FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa
6918: WHERE xja.application_id = p_application_id
6919: AND xja.amb_context_code = p_amb_context_code
6920: AND xja.event_class_code = p_event_class_code
6921: AND xja.accounting_line_type_code = l_accounting_line_type_code

Line 6939: ,xla_jlt_acct_attrs xja

6935: ,l_accounting_line_code VARCHAR2
6936: ,l_assignment_group_code VARCHAR2) IS
6937: SELECT distinct xaa.accounting_attribute_code
6938: FROM xla_acct_attributes_b xaa
6939: ,xla_jlt_acct_attrs xja
6940: WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
6941: AND xaa.assignment_required_code = 'G'
6942: AND xaa.accounting_attribute_code = xja.accounting_attribute_code
6943: AND xaa.assignment_group_code = l_assignment_group_code

Line 6954: FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa

6950:
6951: CURSOR c_pe_mapping_groups(l_accounting_line_type_code VARCHAR2
6952: ,l_accounting_line_code VARCHAR2) IS
6953: SELECT distinct xaa.assignment_group_code
6954: FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa
6955: WHERE xja.application_id = p_application_id
6956: AND xja.amb_context_code = p_amb_context_code
6957: AND xja.event_class_code = p_event_class_code
6958: AND xja.accounting_line_type_code = l_accounting_line_type_code

Line 6977: ,xla_jlt_acct_attrs xja

6973: ,l_accounting_line_code VARCHAR2
6974: ,l_assignment_group_code VARCHAR2) IS
6975: SELECT distinct xaa.accounting_attribute_code
6976: FROM xla_acct_attributes_b xaa
6977: ,xla_jlt_acct_attrs xja
6978: WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
6979: AND xaa.assignment_required_code = 'G'
6980: AND xaa.accounting_attribute_code = xja.accounting_attribute_code
6981: AND xaa.assignment_group_code = l_assignment_group_code