DBA Data[Home] [Help]

APPS.PAY_GB_EPS_13 dependencies on FND_CONC_REQ_SUMMARY_V

Line 927: select REQUEST_ID from FND_CONC_REQ_SUMMARY_V

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:

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

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;