APPS.FND_PROGRAM dependencies on FND_REQUEST_SET_PROGRAMS

Line 1525: DELETE FROM fnd_request_set_programs

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

Line 1554: FROM fnd_request_set_programs frsp

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

Line 1561: DELETE FROM fnd_request_set_programs frs

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

Line 1713: from fnd_request_set_programs sp

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