APPS.PER_IN_PERSON_LEG_HOOK dependencies on PER_PEOPLE_F

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||''') ';

Line 1515: FROM per_people_f

1511: ,per_information13
1512: ,per_information14
1513: ,per_information15
1514: ,business_group_id
1515: FROM per_people_f
1516: WHERE p_effective_date BETWEEN effective_start_date
1517: AND effective_end_date
1518: AND person_id = p_person_id;
1519: