APPS.PAY_GB_RTI_FPS dependencies on FND_CONCURRENT_REQUESTS

Line 8992: fnd_concurrent_requests fcr,

8988: and paa.assignment_action_id = pai.locking_action_id;
8989:
8990: /* cursor csr_is_retry_request is
8991: select 'Y' from fnd_concurrent_programs fcp,
8992: fnd_concurrent_requests fcr,
8993: pay_payroll_actions ppa,
8994: pay_assignment_actions paa
8995: where paa.assignment_action_id = p_assactid
8996: and ppa.payroll_action_id = paa.payroll_action_id

Line 12354: l_request_id fnd_concurrent_requests.request_id%TYPE;

12350: SELECT report_type
12351: FROM pay_payroll_actions pact
12352: WHERE pact.payroll_action_id = pactid;
12353: l_is_etext_report VARCHAR2(50);
12354: l_request_id fnd_concurrent_requests.request_id%TYPE;
12355: xml_layout BOOLEAN;
12356:
12357: -- Cursor to fetch Employer details
12358: CURSOR csr_payroll_details(pactid NUMBER)