APPS.PSA_BC_XML_REPORT_PUB dependencies on GL_BC_PACKETS_HISTS

Line 504: FROM gl_bc_packets_hists

500: FROM gl_bc_packets
501: WHERE template_id IS NOT NULL
502: UNION ALL
503: SELECT packet_id
504: FROM gl_bc_packets_hists
505: WHERE template_id IS NOT NULL) bc
506: WHERE bc.packet_id IN (SELECT packet_id FROM psa_bc_results_gt);
507:
508: CURSOR c_document_status IS

Line 753: psa_utils.debug_other_string(g_state_level,l_api_name, 'Fetching records from GL_BC_PACKETS_HISTS');

749: FROM GL_BC_PACKETS pkts
750: WHERE pkts.period_year = l_period_year
751: AND pkts.period_num BETWEEN l_period_start_num AND l_period_end_num;
752:
753: psa_utils.debug_other_string(g_state_level,l_api_name, 'Fetching records from GL_BC_PACKETS_HISTS');
754:
755: INSERT INTO PSA_BC_REPORT_EVENTS_GT (packet_id)
756: SELECT DISTINCT packet_id
757: FROM GL_BC_PACKETS_HISTS pkts

Line 757: FROM GL_BC_PACKETS_HISTS pkts

753: psa_utils.debug_other_string(g_state_level,l_api_name, 'Fetching records from GL_BC_PACKETS_HISTS');
754:
755: INSERT INTO PSA_BC_REPORT_EVENTS_GT (packet_id)
756: SELECT DISTINCT packet_id
757: FROM GL_BC_PACKETS_HISTS pkts
758: WHERE pkts.period_year = l_period_year
759: AND pkts.period_num BETWEEN l_period_start_num AND l_period_end_num;
760:
761: psa_utils.debug_other_string(g_state_level,l_api_name, 'Completed fetching records from GL_BC_PACKETS_HISTS');

Line 761: psa_utils.debug_other_string(g_state_level,l_api_name, 'Completed fetching records from GL_BC_PACKETS_HISTS');

757: FROM GL_BC_PACKETS_HISTS pkts
758: WHERE pkts.period_year = l_period_year
759: AND pkts.period_num BETWEEN l_period_start_num AND l_period_end_num;
760:
761: psa_utils.debug_other_string(g_state_level,l_api_name, 'Completed fetching records from GL_BC_PACKETS_HISTS');
762:
763: ELSE
764: --Bug 9881400
765: --First Insert all the packet_id data