APPS.PSA_BC_XML_REPORT_PUB dependencies on GL_BC_PACKETS

Line 484: GL_BC_PACKETS glb

480: (XAE.event_date between PS.start_date AND PS.end_date) AND
481: ((x_source = 'FORM' AND
482: EXISTS (SELECT 'x'
483: FROM PSA_BC_REPORT_EVENTS_GT PSAGT,
484: GL_BC_PACKETS glb
485: WHERE PSAGT.packet_id = glb.packet_id
486: AND glb.event_id = XAE.event_id
487: UNION
488: SELECT 'x'

Line 500: FROM gl_bc_packets

496:
497: CURSOR c_is_summary_used IS
498: SELECT min('Y')
499: FROM (SELECT packet_id
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

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 745: psa_utils.debug_other_string(g_state_level,l_api_name, 'Fetching records from GL_BC_PACKETS');

741: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_4 = '||x_rep_eve.source_distribution_id_num_4);
742: psa_utils.debug_other_string(g_state_level,l_api_name, 'SOURCE_DISTRIBUTION_ID_NUM_5 = '||x_rep_eve.source_distribution_id_num_5);
743: END LOOP;
744:
745: psa_utils.debug_other_string(g_state_level,l_api_name, 'Fetching records from GL_BC_PACKETS');
746:
747: INSERT INTO PSA_BC_REPORT_EVENTS_GT (packet_id)
748: SELECT DISTINCT packet_id
749: FROM GL_BC_PACKETS pkts

Line 749: FROM GL_BC_PACKETS pkts

745: psa_utils.debug_other_string(g_state_level,l_api_name, 'Fetching records from GL_BC_PACKETS');
746:
747: INSERT INTO PSA_BC_REPORT_EVENTS_GT (packet_id)
748: SELECT DISTINCT packet_id
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');

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

Line 771: FROM gl_bc_packets b,

767: (
768: packet_id
769: )
770: SELECT DISTINCT b.packet_id
771: FROM gl_bc_packets b,
772: psa_bc_report_events_gt r
773: WHERE b.event_id = r.event_id;
774:
775: psa_utils.debug_other_string(g_state_level,l_api_name, 'Inserted records into psa_bc_report_events_gt: '||SQL%ROWCOUNT);

Line 2310: from gl_bc_packets

2306: IF x_source = 'FORM' THEN
2307: IF p_para_rec.packet_event_flag = 'P' THEN
2308: select EVENT_ID
2309: into l_event_id
2310: from gl_bc_packets
2311: where packet_id in (select packet_id from psa_bc_report_events_gt)
2312: and template_id is NULL
2313: and rownum = 1;
2314: END IF;