274: SELECT
275: request_id
276: FROM
277: fnd_concurrent_requests r
278: , fnd_concurrent_programs p
279: WHERE
280: r.phase_code = 'C'
281: AND p.concurrent_program_id = r.concurrent_program_id
282: AND p.concurrent_program_name = 'CSCSTPG'
1715: INTO
1716: l_row_count
1717: FROM
1718: fnd_concurrent_requests r
1719: , fnd_concurrent_programs p
1720: WHERE
1721: r.request_id = p_cost_set_id
1722: AND p.concurrent_program_id = r.concurrent_program_id
1723: AND p.concurrent_program_name = 'CSCSTPG'