APPS.FA_CHK_BOOKSTS_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 972: from fnd_concurrent_requests

968: h_count number;
969:
970: cursor c_parent_request(p_request_id NUMBER) is
971: select parent_request_id
972: from fnd_concurrent_requests
973: where request_id = p_request_id;
974:
975: BEGIN
976:

Line 1024: from fnd_concurrent_requests

1020: into h_count
1021: from v$session a
1022: where a.audsid in
1023: (select ORACLE_SESSION_ID
1024: from fnd_concurrent_requests
1025: where request_id = h_mass_req_id
1026: or parent_request_id = h_mass_req_id);
1027:
1028: if (h_count = 0) then

Line 1108: from fnd_concurrent_requests

1104: into h_count
1105: from v$session a
1106: where a.audsid in
1107: (select ORACLE_SESSION_ID
1108: from fnd_concurrent_requests
1109: where request_id = h_ca_req_id
1110: or parent_request_id = h_ca_req_id);
1111:
1112: if (h_count = 0) then

Line 1263: from fnd_concurrent_requests re

1259: -- process is ruuning,inactive,pending status
1260:
1261: select re.concurrent_program_id
1262: into h_conc_program_id
1263: from fnd_concurrent_requests re
1264: where re.request_id = h_request_id
1265: and re.program_application_id = 140;
1266:
1267: select decode(pr.concurrent_program_name,