APPS.FND_REQUEST_SET dependencies on FND_RUN_REQ_PP_ACTIONS

Line 508: from fnd_run_req_pp_actions

504: and critical = 'Y';
505:
506: cursor stage_req_printers(parent_req_id number, set_program_id number) is
507: select arguments printer, number_of_copies
508: from fnd_run_req_pp_actions
509: where parent_request_id = parent_req_id
510: and request_set_program_id = set_program_id
511: and action_type = 1
512: order by sequence;

Line 517: from fnd_run_req_pp_actions

513:
514: cursor stage_req_notifications(parent_req_id number,
515: set_program_id number) is
516: select arguments notify
517: from fnd_run_req_pp_actions
518: where parent_request_id = parent_req_id
519: and request_set_program_id = set_program_id
520: and action_type = 2
521: order by sequence;

Line 526: from fnd_run_req_pp_actions

522:
523: cursor stage_req_layouts(parent_req_id number,
524: set_program_id number) is
525: select argument1, argument2, argument3, argument4, argument5
526: from fnd_run_req_pp_actions
527: where parent_request_id = parent_req_id
528: and request_set_program_id = set_program_id
529: and action_type = 6
530: order by sequence;

Line 536: from fnd_run_req_pp_actions

532: cursor stage_req_delivery(parent_req_id number,
533: set_program_id number) is
534: select argument1, argument2, argument3, argument4, argument5,
535: argument6, argument7, argument8, argument9, argument10
536: from fnd_run_req_pp_actions
537: where parent_request_id = parent_req_id
538: and request_set_program_id = set_program_id
539: and action_type in (7, 8)
540: order by sequence;