APPS.BEN_BATCH_UTILS dependencies on FND_REQUEST

Line 1608: And fnd.request_id = p_request_id;

1604: Cursor c_slaves(p_request_id number) is
1605: Select null
1606: From fnd_concurrent_requests fnd
1607: Where fnd.phase_code <> 'C'
1608: And fnd.request_id = p_request_id;
1609: Begin
1610: hr_utility.set_location ('Entering '||l_proc,5);
1611: If g_num_processes <> 0 then
1612: l_actn := 'Checking Slaves.....';

Line 1766: l_request_id := fnd_request.submit_request

1762: l_request_id number;
1763: Begin
1764: hr_utility.set_location('Entering :'||l_proc,10);
1765: If (p_subtitle is NULL) then
1766: l_request_id := fnd_request.submit_request
1767: (application => 'BEN'
1768: ,program => p_program_name
1769: ,description => NULL
1770: ,sub_request => FALSE

Line 1774: l_request_id := fnd_request.submit_request

1770: ,sub_request => FALSE
1771: ,argument1 => p_concurrent_request_id
1772: );
1773: Else
1774: l_request_id := fnd_request.submit_request
1775: (application => 'BEN'
1776: ,program => p_program_name
1777: ,description => NULL
1778: ,sub_request => FALSE

Line 2168: where fnd.request_id = p_concurrent_request_id

2164: fnd_concurrent_requests fnd,
2165: fnd_concurrent_programs_tl conc,
2166: hr_locations lc,
2167: ben_benfts_grp bnfg
2168: where fnd.request_id = p_concurrent_request_id
2169: and conc.concurrent_program_id = fnd.concurrent_program_id
2170: and conc.application_id = 805
2171: and conc.language = userenv('LANG') --Bug 2394141
2172: and bft.request_id = fnd.request_id

Line 2172: and bft.request_id = fnd.request_id

2168: where fnd.request_id = p_concurrent_request_id
2169: and conc.concurrent_program_id = fnd.concurrent_program_id
2170: and conc.application_id = 805
2171: and conc.language = userenv('LANG') --Bug 2394141
2172: and bft.request_id = fnd.request_id
2173: and hr.lookup_code = bft.mode_cd
2174: and hr.lookup_type = 'BEN_BENMNGLE_MD'
2175: and hr1.lookup_code = bft.derivable_factors_flag
2176: and hr1.lookup_type = 'YES_NO'