DBA Data[Home] [Help]

APPS.CSTPSMCW dependencies on FND_CONCURRENT_REQUESTS

Line 112: FROM fnd_concurrent_requests fcr

108: l_stmt_num := 10;
109:
110: SELECT nvl(max(fcr.request_id), -1)
111: INTO l_req_id
112: FROM fnd_concurrent_requests fcr
113: WHERE program_application_id = 702
114: AND concurrent_program_id = l_program_id
115: AND argument1 = TO_CHAR(p_org_id)
116: AND phase_code <> 'C'

Line 136: FROM fnd_concurrent_requests fcr

132:
133: l_stmt_num := 30;
134: SELECT nvl(max(fcr.request_id), -1)
135: INTO l_req_id
136: FROM fnd_concurrent_requests fcr
137: WHERE program_application_id = 702
138: AND concurrent_program_id = l_cmcicu_prog_id
139: AND argument1 = TO_CHAR(p_org_id)
140: AND phase_code = 'R';

Line 484: FROM FND_CONCURRENT_REQUESTS

480: INTO l_prog_application_id,
481: l_program_id,
482: l_login_id,
483: l_user_id
484: FROM FND_CONCURRENT_REQUESTS
485: WHERE request_id = p_request_id;
486:
487:
488: /* If Transaction is BONUS at First Operation and Queue Introperation