APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on FND_REQUEST

Line 330: and fnd.request_id = v_request_id;

326: cursor c_slaves(v_request_id number) is
327: select null
328: from fnd_concurrent_requests fnd
329: where fnd.phase_code <> 'C'
330: and fnd.request_id = v_request_id;
331: --
332: cursor c_master is
333: select 'Y'
334: from ben_benefit_actions bft

Line 4903: l_request_id := fnd_request.submit_request

4899: -- be executed and no additional concurrent requests will be submitted.
4900: --
4901: hr_utility.set_location('Sumitting thread : ' || l_count, 25);
4902: --
4903: l_request_id := fnd_request.submit_request
4904: (application => 'BEN'
4905: ,program => 'BENTMPCMT'
4906: ,description => NULL
4907: ,sub_request => FALSE

Line 5098: where fnd.request_id = p_concurrent_request_id

5094: ben_pgm_f pgm2,
5095: hr_locations_all loc,
5096: fnd_concurrent_requests fnd,
5097: fnd_concurrent_programs_tl conc
5098: where fnd.request_id = p_concurrent_request_id
5099: and conc.concurrent_program_id = fnd.concurrent_program_id
5100: and conc.application_id = 805
5101: and conc.language = userenv('LANG') --NLS Fix
5102: and bft.request_id = fnd.request_id

Line 5102: and bft.request_id = fnd.request_id

5098: where fnd.request_id = p_concurrent_request_id
5099: and conc.concurrent_program_id = fnd.concurrent_program_id
5100: and conc.application_id = 805
5101: and conc.language = userenv('LANG') --NLS Fix
5102: and bft.request_id = fnd.request_id
5103: and hr1.lookup_code = bft.mode_cd
5104: and hr1.lookup_type = 'BEN_BENTMPCM_MD'
5105: and hr2.lookup_code = bft.validate_flag
5106: and hr2.lookup_type = 'YES_NO'