APPS.FND_SUBMIT dependencies on FND_REQUEST_SET_PROGRAMS

Line 207: fnd_concurrent_programs CP, fnd_request_set_programs RSP

203: cursor set_programs( set_app_id number, set_id number) is
204: select CP.concurrent_program_name, CP.enabled_flag, RSS.stage_name,
205: RSP.sequence
206: from fnd_request_sets RS, fnd_request_set_stages RSS,
207: fnd_concurrent_programs CP, fnd_request_set_programs RSP
208: where RS.application_id = set_app_id
209: and RS.request_set_id = set_id
210: and RSS.set_application_id = RS.application_id
211: and RSS.request_set_id = RS.request_set_id

Line 693: -- all options from the fnd_request_set_programs

689: raise program_not_found;
690: end if;
691:
692: -- get the request_set_program_id,prog_app_id, conc_prog_id and
693: -- all options from the fnd_request_set_programs
694:
695: begin
696: select request_set_program_id, program_application_id,
697: RSP.concurrent_program_id, RSP.nls_language,

Line 704: from fnd_request_set_programs RSP, fnd_request_set_stages RSS,

700: into rsp_program_id, rsp_prog_app_id,
701: rsp_conc_prog_id, rsp_nls_lang,
702: rsp_nls_territory, rsp_copies, rsp_printer,
703: rsp_style, rsp_save_output_flag
704: from fnd_request_set_programs RSP, fnd_request_set_stages RSS,
705: fnd_concurrent_programs CP
706: where RSP.set_application_id = P_SET_APP_ID
707: and RSP.request_set_id = P_SET_ID
708: and RSP.set_application_id = RSS.set_application_id

Line 1854: FROM fnd_request_set_programs frsp,

1850: template_request_set_name in varchar2)
1851: return varchar2 is
1852: cursor program_cursor is
1853: select fcp.concurrent_program_name, frsp.critical
1854: FROM fnd_request_set_programs frsp,
1855: fnd_concurrent_programs_vl fcp,
1856: fnd_request_sets_vl frs,
1857: fnd_application fa
1858: WHERE fa.application_short_name = template_appl_name