APPS.IGF_AP_LOADER_LAUNCH_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 76: FROM fnd_concurrent_requests fcr, fnd_concurrent_programs ucpn

72: */
73:
74: CURSOR get_parameter_cur IS
75: SELECT fcr.argument1
76: FROM fnd_concurrent_requests fcr, fnd_concurrent_programs ucpn
77: WHERE fcr.program_application_id = ucpn.application_id
78: AND fcr.concurrent_program_id = ucpn.concurrent_program_id
79: AND fcr.phase_code = 'R'
80: AND ucpn.concurrent_program_name = 'IGFAPX06'

Line 85: l_parameter_value fnd_concurrent_requests.argument1%TYPE;

81: AND ucpn.application_id = 8405;
82:
83: -- IGFAPX02 is the executable name for ISIR Loader Process
84:
85: l_parameter_value fnd_concurrent_requests.argument1%TYPE;
86: l_file_name VARCHAR2(100);
87: BEGIN
88:
89: -- get the parameter value