94: /* retrieve material cost worker program ID*/
95: l_concurrent_program_name := 'CMCMCW';
96: SELECT concurrent_program_id
97: INTO l_cmcmcw_prog_id
98: FROM fnd_concurrent_programs
99: WHERE application_id = l_application_id
100: AND concurrent_program_name = l_concurrent_program_name;
101:
102: l_stmt_num := 20;
103: /* retrieve actual cost worker program ID*/
104: l_concurrent_program_name := 'CMCACW';
105: SELECT concurrent_program_id
106: INTO l_cmcacw_prog_id
107: FROM fnd_concurrent_programs
108: WHERE application_id = l_application_id
109: AND concurrent_program_name = l_concurrent_program_name;
110:
111: l_stmt_num := 30;
112: /* retrieve layer cost worker program ID*/
113: l_concurrent_program_name := 'CMCLCW';
114: SELECT concurrent_program_id
115: INTO l_cmclcw_prog_id
116: FROM fnd_concurrent_programs
117: WHERE application_id = l_application_id
118: AND concurrent_program_name = l_concurrent_program_name;
119:
120: l_stmt_num := 40;