APPS.PER_IN_PERSON_LEG_HOOK dependencies on DUAL

Line 418: into l_inf_column from dual;

414: ,'Gratuity Number','per_information12'
415: ,'Pension Number','per_information13'
416: ,'PAN Reference Number','per_information14'
417: ,'NSSN','per_information15') inf_column
418: into l_inf_column from dual;
419: IF g_debug THEN
420: pay_in_utils.trace('**************************************************','********************');
421: pay_in_utils.trace('l_inf_column ',l_inf_column);
422: pay_in_utils.trace('**************************************************','********************');

Line 425: l_qry:=' SELECT count(1) from dual where exists(SELECT 1 FROM per_people_f '||

421: pay_in_utils.trace('l_inf_column ',l_inf_column);
422: pay_in_utils.trace('**************************************************','********************');
423: END IF;
424:
425: l_qry:=' SELECT count(1) from dual where exists(SELECT 1 FROM per_people_f '||
426: ' WHERE business_group_id = '||p_business_group_id||
427: ' AND per_information_category = ''IN'' '||
428: ' AND (person_id <>'''|| p_person_id ||''' OR '''|| p_person_id||''' is null)'||
429: ' AND '||l_inf_column||'='''||p_value||''') ';