APPS.PSA_BC_XML_REPORT_PUB dependencies on GL_BC_PACKETS

Line 480: FROM gl_bc_packets

476:
477: CURSOR c_is_summary_used IS
478: SELECT min('Y')
479: FROM (SELECT packet_id
480: FROM gl_bc_packets
481: WHERE template_id IS NOT NULL
482: UNION ALL
483: SELECT packet_id
484: FROM gl_bc_packets_hists

Line 484: FROM gl_bc_packets_hists

480: FROM gl_bc_packets
481: WHERE template_id IS NOT NULL
482: UNION ALL
483: SELECT packet_id
484: FROM gl_bc_packets_hists
485: WHERE template_id IS NOT NULL) bc
486: WHERE bc.packet_id IN (SELECT packet_id FROM psa_bc_results_gt);
487:
488: CURSOR c_document_status IS

Line 2235: from gl_bc_packets

2231: IF x_source = 'FORM' THEN
2232: IF p_para_rec.packet_event_flag = 'P' THEN
2233: select EVENT_ID
2234: into l_event_id
2235: from gl_bc_packets
2236: where packet_id in (select packet_id from psa_bc_report_events_gt)
2237: and template_id is NULL
2238: and rownum = 1;
2239: END IF;