APPS.FND_SUBMIT dependencies on FND_REQUEST_SET_PROGRAMS

Line 233: fnd_concurrent_programs CP, fnd_request_set_programs RSP

229: cursor set_programs( set_app_id number, set_id number) is
230: select CP.concurrent_program_name, CP.enabled_flag, RSS.stage_name,
231: RSP.sequence
232: from fnd_request_sets RS, fnd_request_set_stages RSS,
233: fnd_concurrent_programs CP, fnd_request_set_programs RSP
234: where RS.application_id = set_app_id
235: and RS.request_set_id = set_id
236: and RSS.set_application_id = RS.application_id
237: and RSS.request_set_id = RS.request_set_id

Line 719: -- all options from the fnd_request_set_programs

715: raise program_not_found;
716: end if;
717:
718: -- get the request_set_program_id,prog_app_id, conc_prog_id and
719: -- all options from the fnd_request_set_programs
720:
721: begin
722: select request_set_program_id, program_application_id,
723: RSP.concurrent_program_id, RSP.nls_language,

Line 730: from fnd_request_set_programs RSP, fnd_request_set_stages RSS,

726: into rsp_program_id, rsp_prog_app_id,
727: rsp_conc_prog_id, rsp_nls_lang,
728: rsp_nls_territory, rsp_copies, rsp_printer,
729: rsp_style, rsp_save_output_flag
730: from fnd_request_set_programs RSP, fnd_request_set_stages RSS,
731: fnd_concurrent_programs CP
732: where RSP.set_application_id = P_SET_APP_ID
733: and RSP.request_set_id = P_SET_ID
734: and RSP.set_application_id = RSS.set_application_id

Line 2301: FROM fnd_request_set_programs frsp,

2297: template_request_set_name in varchar2)
2298: return varchar2 is
2299: cursor program_cursor is
2300: select fcp.concurrent_program_name, frsp.critical
2301: FROM fnd_request_set_programs frsp,
2302: fnd_concurrent_programs_vl fcp,
2303: fnd_request_sets_vl frs,
2304: fnd_application fa
2305: WHERE fa.application_short_name = template_appl_name