APPS.FA_RX_PUBLISH dependencies on FA_RX_MULTIFORMAT_REPS

Line 226: from fa_rx_multiformat_reps

222: m_report.output_format := p_output_format;
223:
224: select sub_report_id, sub_attribute_set
225: into m_report.report_id, m_report.attribute_set
226: from fa_rx_multiformat_reps
227: where request_id = p_request_id
228: and seq_number = (
229: select min(seq_number) from fa_rx_multiformat_reps
230: where request_id = p_request_id)

Line 229: select min(seq_number) from fa_rx_multiformat_reps

225: into m_report.report_id, m_report.attribute_set
226: from fa_rx_multiformat_reps
227: where request_id = p_request_id
228: and seq_number = (
229: select min(seq_number) from fa_rx_multiformat_reps
230: where request_id = p_request_id)
231: and rownum=1;
232:
233: else

Line 752: from fa_rx_multiformat_reps m

748: m.sub_attribute_set,
749: m.group_id,
750: m.complex_flag,
751: m.seq_number
752: from fa_rx_multiformat_reps m
753: where m.request_id = m_report.request_id
754: order by m.group_id, m.seq_number;
755: rformat cformat%rowtype;
756:

Line 2427: from fa_rx_multiformat_reps

2423: is
2424: cnt number;
2425: begin
2426: select count(*) into cnt
2427: from fa_rx_multiformat_reps
2428: where request_id = p_request_id;
2429:
2430: return (cnt > 0);
2431: end is_multi_format_report;