APPS.PAY_RUN_BALANCE_BUILD dependencies on FND_CONCURRENT_REQUESTS

Line 147: l_request_id fnd_concurrent_requests.request_id%type;

143: );
144: --
145: l_run_bal_stat pay_balance_validation.run_balance_status%type;
146: l_bus_grp pay_payroll_actions.business_group_id%type;
147: l_request_id fnd_concurrent_requests.request_id%type;
148: l_old_balance_load_date pay_balance_validation.balance_load_date%type;
149: --
150: begin
151: g_purge_only := FALSE;

Line 172: from FND_CONCURRENT_REQUESTS fcr,

168: and bd.DIMENSION_LEVEL in ('ASG','GRP'));
169:
170: select fcp.CONCURRENT_PROGRAM_NAME
171: into g_program_name
172: from FND_CONCURRENT_REQUESTS fcr,
173: FND_CONCURRENT_PROGRAMS fcp
174: where fcr.REQUEST_ID = l_request_id
175: and fcp.CONCURRENT_PROGRAM_ID = fcr.CONCURRENT_PROGRAM_ID;
176: hr_utility.trace('get CONCURRENT_PROGRAM_NAME. g_program_name:'||g_program_name);

Line 1830: l_request_id fnd_concurrent_requests.request_id%type;

1826: l_timeout_sec number;
1827: current_time date;
1828: l_run_bal_stat pay_balance_validation.run_balance_status%type;
1829: l_bus_grp pay_payroll_actions.business_group_id%type;
1830: l_request_id fnd_concurrent_requests.request_id%type;
1831: l_old_balance_load_date pay_balance_validation.balance_load_date%type;
1832: l_parm_purge_only varchar2(1);
1833: --
1834: begin

Line 1879: from FND_CONCURRENT_REQUESTS fcr,

1875: where payroll_action_id = p_payroll_action_id;
1876:
1877: select fcp.CONCURRENT_PROGRAM_NAME
1878: into g_program_name
1879: from FND_CONCURRENT_REQUESTS fcr,
1880: FND_CONCURRENT_PROGRAMS fcp
1881: where fcr.REQUEST_ID = l_request_id
1882: and fcp.CONCURRENT_PROGRAM_ID = fcr.CONCURRENT_PROGRAM_ID;
1883: if g_debug then