APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on FND_CONCURRENT_REQUESTS

Line 9627: fnd_concurrent_requests fcr,

9623: and paa.assignment_action_id = pai.locking_action_id;
9624:
9625: /* cursor csr_is_retry_request is
9626: select 'Y' from fnd_concurrent_programs fcp,
9627: fnd_concurrent_requests fcr,
9628: pay_payroll_actions ppa,
9629: pay_assignment_actions paa
9630: where paa.assignment_action_id = p_assactid
9631: and ppa.payroll_action_id = paa.payroll_action_id

Line 13095: l_request_id fnd_concurrent_requests.request_id%TYPE;

13091: SELECT report_type
13092: FROM pay_payroll_actions pact
13093: WHERE pact.payroll_action_id = pactid;
13094: l_is_etext_report VARCHAR2(50);
13095: l_request_id fnd_concurrent_requests.request_id%TYPE;
13096: xml_layout BOOLEAN;
13097:
13098: -- Cursor to fetch Employer details
13099: CURSOR csr_payroll_details(pactid NUMBER)