APPS.XLA_CMP_TAD_PKG dependencies on XLA_TAB_ACCT_DEF_DETAILS

Line 1814: FROM xla_tab_acct_def_details xtdd

1810: ,xtta.rule_assignment_code
1811: ,NULL
1812: BULK COLLECT
1813: INTO l_table_of_tad_details
1814: FROM xla_tab_acct_def_details xtdd
1815: ,xla_tab_acct_types_b xtta
1816: WHERE xtdd.application_id = $APPLICATION_ID_2$
1817: AND xtdd.account_definition_code = ''$TAD_CODE_2$''
1818: AND xtdd.account_definition_type_code = ''$TAD_TYPE_CODE_2$''

Line 3963: FROM xla_tab_acct_def_details xtdd

3959: ,xtta.rule_assignment_code
3960: ,NULL
3961: BULK COLLECT
3962: INTO l_table_of_tad_details
3963: FROM xla_tab_acct_def_details xtdd
3964: ,xla_tab_acct_types_b xtta
3965: WHERE xtdd.application_id = p_application_id
3966: AND xtdd.account_definition_code = p_account_definition_code
3967: AND xtdd.account_definition_type_code = p_account_definition_type_code

Line 4018: FROM xla_tab_acct_def_details xtdd

4014: xtdd.application_id
4015: ,xtdd.segment_rule_type_code
4016: ,xtdd.segment_rule_code
4017: ,xtdd.amb_context_code
4018: FROM xla_tab_acct_def_details xtdd
4019: ,xla_tab_acct_types_b xtta
4020: WHERE xtdd.application_id = p_application_id
4021: AND xtdd.account_definition_code = p_account_definition_code
4022: AND xtdd.account_definition_type_code = p_account_definition_type_code

Line 4188: ,xla_tab_acct_def_details xtad

4184: --Check is some TAT requiring compilation has been left out
4185: SELECT count(*)
4186: INTO l_count_missing_required_tat
4187: FROM xla_tab_acct_types_b xtat
4188: ,xla_tab_acct_def_details xtad
4189: WHERE xtat.application_id = p_application_id
4190: AND xtat.enabled_flag = 'Y'
4191: AND xtat.rule_assignment_code = 'REQUIRED'
4192: AND xtad.application_id (+)= xtat.application_id