923: and business_group_id = p_business_group_id
924: and status = 'Verified';
925:
926: cursor csr_reqid is
927: select REQUEST_ID from FND_CONC_REQ_SUMMARY_V
928: where PROGRAM_SHORT_NAME='PYGBRTIEPS13'
929: and REQUEST_DATE = (select max(request_date) from FND_CONC_REQ_SUMMARY_V where PROGRAM_SHORT_NAME='PYGBRTIEPS13');
930:
931:
925:
926: cursor csr_reqid is
927: select REQUEST_ID from FND_CONC_REQ_SUMMARY_V
928: where PROGRAM_SHORT_NAME='PYGBRTIEPS13'
929: and REQUEST_DATE = (select max(request_date) from FND_CONC_REQ_SUMMARY_V where PROGRAM_SHORT_NAME='PYGBRTIEPS13');
930:
931:
932: l_proc varchar2(72) := g_package||'submit_eps';
933: xml_layout boolean;