1981: hrl.lookup_code lookup_code
1982: FROM per_all_people_f peo,
1983: per_all_assignments_f ass,
1984: per_jobs_vl job,
1985: hr_lookups hrl,
1986: per_gen_hierarchy_nodes pgn_est
1987: WHERE peo.person_id = ass.person_id
1988: AND peo.per_information1 IS not NULL
1989: AND peo.per_information_category = 'US'
2055: hrl.lookup_code lookup_code
2056: FROM per_all_people_f peo,
2057: per_all_assignments_f ass,
2058: per_jobs_vl job,
2059: hr_lookups hrl,
2060: per_gen_hierarchy_nodes pgn_est
2061: WHERE peo.person_id = ass.person_id
2062: AND peo.per_information1 IS NOT NULL
2063: AND peo.per_information_category = 'US'
2124: hrl.lookup_code lookup_code
2125: FROM per_all_people_f peo,
2126: per_all_assignments_f ass,
2127: per_jobs_vl job,
2128: hr_lookups hrl,
2129: per_gen_hierarchy_nodes pgn_est
2130: WHERE peo.person_id = ass.person_id
2131: AND peo.per_information1 IN ('1','2','3','4','5','6','13') --BUG4410003
2132: AND peo.per_information_category = 'US'