APPS.BEN_BATCH_UTILS dependencies on FND_REQUEST

Line 1598: And fnd.request_id = p_request_id;

1594: Cursor c_slaves(p_request_id number) is
1595: Select null
1596: From fnd_concurrent_requests fnd
1597: Where fnd.phase_code <> 'C'
1598: And fnd.request_id = p_request_id;
1599: Begin
1600: hr_utility.set_location ('Entering '||l_proc,5);
1601: If g_num_processes <> 0 then
1602: l_actn := 'Checking Slaves.....';

Line 1756: l_request_id := fnd_request.submit_request

1752: l_request_id number;
1753: Begin
1754: hr_utility.set_location('Entering :'||l_proc,10);
1755: If (p_subtitle is NULL) then
1756: l_request_id := fnd_request.submit_request
1757: (application => 'BEN'
1758: ,program => p_program_name
1759: ,description => NULL
1760: ,sub_request => FALSE

Line 1764: l_request_id := fnd_request.submit_request

1760: ,sub_request => FALSE
1761: ,argument1 => p_concurrent_request_id
1762: );
1763: Else
1764: l_request_id := fnd_request.submit_request
1765: (application => 'BEN'
1766: ,program => p_program_name
1767: ,description => NULL
1768: ,sub_request => FALSE

Line 2158: where fnd.request_id = p_concurrent_request_id

2154: fnd_concurrent_requests fnd,
2155: fnd_concurrent_programs_tl conc,
2156: hr_locations lc,
2157: ben_benfts_grp bnfg
2158: where fnd.request_id = p_concurrent_request_id
2159: and conc.concurrent_program_id = fnd.concurrent_program_id
2160: and conc.application_id = 805
2161: and conc.language = userenv('LANG') --Bug 2394141
2162: and bft.request_id = fnd.request_id

Line 2162: and bft.request_id = fnd.request_id

2158: where fnd.request_id = p_concurrent_request_id
2159: and conc.concurrent_program_id = fnd.concurrent_program_id
2160: and conc.application_id = 805
2161: and conc.language = userenv('LANG') --Bug 2394141
2162: and bft.request_id = fnd.request_id
2163: and hr.lookup_code = bft.mode_cd
2164: and hr.lookup_type = 'BEN_BENMNGLE_MD'
2165: and hr1.lookup_code = bft.derivable_factors_flag
2166: and hr1.lookup_type = 'YES_NO'