DBA Data[Home] [Help]

APPS.AMS_ACCESS_DENORM_PVT dependencies on FND_CONCURRENT_PROGRAMS

Line 1835: FROM fnd_concurrent_programs

1831: WHERE arc_user_or_role_type = 'GROUP';
1832:
1833: CURSOR cur_get_conc_program_id IS
1834: SELECT concurrent_program_id
1835: FROM fnd_concurrent_programs
1836: WHERE application_id = 530
1837: AND concurrent_program_name = 'AMSADENO';
1838:
1839: CURSOR cur_get_latest_start_date IS

Line 1966: FROM fnd_concurrent_programs

1962: AND aac.delete_flag='N';
1963:
1964: CURSOR cur_get_conc_program_id IS
1965: SELECT concurrent_program_id
1966: FROM fnd_concurrent_programs
1967: WHERE application_id = 530
1968: AND concurrent_program_name = 'AMSJDENO';
1969:
1970: CURSOR cur_get_latest_start_date IS

Line 2290: FROM fnd_concurrent_programs

2286: );
2287:
2288: CURSOR cur_get_conc_program_id IS
2289: SELECT concurrent_program_id
2290: FROM fnd_concurrent_programs
2291: WHERE concurrent_program_name = 'AMSJDENO';
2292:
2293: CURSOR cur_get_latest_start_date IS
2294: SELECT MAX(actual_start_date)