APPS.FA_RX_PUBLISH dependencies on FA_RX_MULTIFORMAT_REPS

Line 227: from fa_rx_multiformat_reps

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

Line 230: select min(seq_number) from fa_rx_multiformat_reps

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

Line 753: from fa_rx_multiformat_reps m

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

Line 2359: from fa_rx_multiformat_reps

2355: is
2356: cnt number;
2357: begin
2358: select count(*) into cnt
2359: from fa_rx_multiformat_reps
2360: where request_id = p_request_id;
2361:
2362: return (cnt > 0);
2363: end is_multi_format_report;