APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on FND_REQUEST

Line 326: and fnd.request_id = v_request_id;

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

Line 4838: l_request_id := fnd_request.submit_request

4834: -- be executed and no additional concurrent requests will be submitted.
4835: --
4836: hr_utility.set_location('Sumitting thread : ' || l_count, 25);
4837: --
4838: l_request_id := fnd_request.submit_request
4839: (application => 'BEN'
4840: ,program => 'BENTMPCMT'
4841: ,description => NULL
4842: ,sub_request => FALSE

Line 5033: where fnd.request_id = p_concurrent_request_id

5029: ben_pgm_f pgm2,
5030: hr_locations_all loc,
5031: fnd_concurrent_requests fnd,
5032: fnd_concurrent_programs_tl conc
5033: where fnd.request_id = p_concurrent_request_id
5034: and conc.concurrent_program_id = fnd.concurrent_program_id
5035: and conc.application_id = 805
5036: and conc.language = userenv('LANG') --NLS Fix
5037: and bft.request_id = fnd.request_id

Line 5037: and bft.request_id = fnd.request_id

5033: where fnd.request_id = p_concurrent_request_id
5034: and conc.concurrent_program_id = fnd.concurrent_program_id
5035: and conc.application_id = 805
5036: and conc.language = userenv('LANG') --NLS Fix
5037: and bft.request_id = fnd.request_id
5038: and hr1.lookup_code = bft.mode_cd
5039: and hr1.lookup_type = 'BEN_BENTMPCM_MD'
5040: and hr2.lookup_code = bft.validate_flag
5041: and hr2.lookup_type = 'YES_NO'