APPS.AMW_LOAD_CONSTRAINT_DATA dependencies on FND_CONCURRENT_PROGRAMS

Line 47: select application_id from fnd_concurrent_programs

43: -- Added by QLIU. Temporary fix for Application_ID
44: l_application_id NUMBER := null;
45:
46: CURSOR c_cp_appl_id (c_conc_program_id NUMBER) IS
47: select application_id from fnd_concurrent_programs
48: where concurrent_program_id = c_conc_program_id;
49:
50: CURSOR c_resp_appl_id (c_resp_id NUMBER) IS
51: select application_id from fnd_responsibility

Line 807: and (select count(1) from fnd_concurrent_programs cp

803: select intf.cst_interface_id
804: from amw_constraint_interface intf
805: where intf.batch_id=p_batch_id
806: and intf.cst_violat_obj_type='CP'
807: and (select count(1) from fnd_concurrent_programs cp
808: where cp.concurrent_program_id = intf.cst_entries_function_id)>1;
809:
810: cursor c_chk_ambiguous_resp is
811: select intf.cst_interface_id