DBA Data[Home] [Help]

APPS.OKS_QA_DATA_INTEGRITY dependencies on FND_CONCURRENT_REQUESTS

Line 8145: FROM fnd_concurrent_requests

8141: req_id NUMBER;
8142:
8143: CURSOR c_reprice_req(l_chr_id IN NUMBER,l_prog_appl_id IN NUMBER,l_prg_id IN NUMBER) IS
8144: SELECT max(request_id)
8145: FROM fnd_concurrent_requests
8146: WHERE program_application_id = l_prog_appl_id
8147: AND concurrent_program_id = l_prg_id
8148: AND argument2=to_char(l_chr_id)
8149: AND phase_code IN ('P','R');

Line 8307: FROM fnd_concurrent_requests

8303: req_id NUMBER;
8304:
8305: CURSOR c_cascade_req(l_chr_id IN NUMBER,l_prog_appl_id IN NUMBER,l_prg_id IN NUMBER) IS
8306: SELECT max(request_id)
8307: FROM fnd_concurrent_requests
8308: WHERE program_application_id = l_prog_appl_id
8309: AND concurrent_program_id = l_prg_id
8310: AND argument1=to_char(l_chr_id)
8311: AND phase_code IN ('P','R');