APPS.XLA_TB_AP_REPORT_PVT dependencies on XLA_TB_DEFN_DETAILS

Line 93: FROM xla_tb_defn_details d,

89: SELECT /*+ materialize */
90: DISTINCT p.ledger_id, d.code_combination_id,
91: p.period_name,
92: rpad(''x'',500) pad
93: FROM xla_tb_defn_details d,
94: xla_tb_definitions_vl vl,
95: gl_period_statuses p
96: WHERE d.definition_code = ''$p_definition_code$''
97: AND vl.definition_code = d.definition_code

Line 135: FROM xla_tb_defn_details d,

131: WITH xtd AS
132: (
133: SELECT /*+ materialize */ DISTINCT ledger_id, code_combination_id,
134: rpad(''x'',500) pad
135: FROM xla_tb_defn_details d,
136: xla_tb_definitions_vl vl
137: WHERE d.definition_code = ''$p_definition_code$''
138: AND vl.definition_code = d.definition_code
139: ) ,

Line 2702: FROM xla_tb_defn_details d

2698: END LOOP;
2699:
2700: /* commented for bug#9926320
2701: FOR i IN ( SELECT *
2702: FROM xla_tb_defn_details d
2703: WHERE d.definition_code = p_definition_code
2704: )
2705: LOOP
2706: l_join_gcck := l_join_gcck || ' AND gcck.'|| i.flexfield_segment_code || ' BETWEEN ' ||

Line 2788: FROM xla_tb_defn_details

2784: arr_manual_sla_amount t_manual_sla_amount;
2785:
2786: CURSOR csr_seg_range_check IS
2787: SELECT code_combination_id
2788: FROM xla_tb_defn_details
2789: WHERE definition_code = p_definition_code;
2790:
2791: l_code_combination_id gl_code_combinations.code_combination_id%TYPE;
2792: