APPS.FND_PROGRAM dependencies on FND_REQUEST_SET_PROGRAMS

Line 1522: DELETE FROM fnd_request_set_programs

1518: AND request_set_id = set_id;
1519:
1520: -- Remove member programs
1521:
1522: DELETE FROM fnd_request_set_programs
1523: WHERE set_application_id = program_application_id
1524: AND request_set_id = set_id;
1525:
1526: -- Remove the set

Line 1551: FROM fnd_request_set_programs frsp

1547: DELETE FROM fnd_request_set_program_args
1548: WHERE application_id = program_application_id
1549: AND request_set_program_id in
1550: (SELECT request_set_program_id
1551: FROM fnd_request_set_programs frsp
1552: WHERE frsp.program_application_id
1553: = delete_program.program_application_id
1554: AND concurrent_program_id = program_id);
1555:

Line 1558: DELETE FROM fnd_request_set_programs frs

1554: AND concurrent_program_id = program_id);
1555:
1556: -- Remove the program from request sets
1557:
1558: DELETE FROM fnd_request_set_programs frs
1559: WHERE frs.program_application_id = delete_program.program_application_id
1560: AND concurrent_program_id = program_id;
1561:
1562: -- Remove the program from request groups

Line 1710: from fnd_request_set_programs sp

1706: where (a.application_id, a.request_set_id, a.request_set_program_id)
1707: in (select sp.set_application_id,
1708: sp.request_set_id,
1709: sp.request_set_program_id
1710: from fnd_request_set_programs sp
1711: where sp.program_application_id = program_appl_id
1712: and sp.concurrent_program_id = program_id)
1713: and (a.descriptive_flex_appl_id,
1714: a.descriptive_flexfield_name,