228: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_str_0);
229: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
230:
231: --get the query for the members in the group passed
232: L_str := igs_pe_dynamic_persid_group.get_dynamic_sql(p_pid_group,l_status, l_group_type);
233: IF l_status <> 'S' THEN
234: RAISE NO_DATA_FOUND;
235: END IF;
236: L_select := L_select||'('||L_str||')';
497: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_str_0);
498: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
499:
500: --get the query for the members in the group passed
501: L_str := igs_pe_dynamic_persid_group.get_dynamic_sql(p_pid_group,l_status, l_group_type); -- skpandey
502: IF l_status <> 'S' THEN
503: RAISE NO_DATA_FOUND;
504: END IF;
505: L_select := L_select||'('||L_str||')';