APPS.PAY_GB_EPS dependencies on FND_CONC_REQ_SUMMARY_V

Line 789: select REQUEST_ID from FND_CONC_REQ_SUMMARY_V

785: and business_group_id = p_business_group_id
786: and status = 'Verified';
787:
788: cursor csr_reqid is
789: select REQUEST_ID from FND_CONC_REQ_SUMMARY_V
790: where PROGRAM_SHORT_NAME='PYGBRTIEPS'
791: and REQUEST_DATE = (select max(request_date) from FND_CONC_REQ_SUMMARY_V where PROGRAM_SHORT_NAME='PYGBRTIEPS');
792:
793:

Line 791: and REQUEST_DATE = (select max(request_date) from FND_CONC_REQ_SUMMARY_V where PROGRAM_SHORT_NAME='PYGBRTIEPS');

787:
788: cursor csr_reqid is
789: select REQUEST_ID from FND_CONC_REQ_SUMMARY_V
790: where PROGRAM_SHORT_NAME='PYGBRTIEPS'
791: and REQUEST_DATE = (select max(request_date) from FND_CONC_REQ_SUMMARY_V where PROGRAM_SHORT_NAME='PYGBRTIEPS');
792:
793:
794: l_proc varchar2(72) := g_package||'submit_eps';
795: xml_layout boolean;