DBA Data[Home] [Help]

APPS.PER_EEO_MAG_REPORT dependencies on HR_LOOKUPS

Line 2048: hr_lookups hrl,

2044: hrl.lookup_code lookup_code
2045: FROM per_all_people_f peo,
2046: per_all_assignments_f ass,
2047: per_jobs_vl job,
2048: hr_lookups hrl,
2049: per_gen_hierarchy_nodes pgn_est
2050: WHERE peo.person_id = ass.person_id
2051: --AND peo.per_information1 is not NULL commented for fix for #12616269
2052: -- Added for fix for #12616269

Line 2152: hr_lookups hrl,

2148: hrl.lookup_code lookup_code
2149: FROM per_all_people_f peo,
2150: per_all_assignments_f ass,
2151: per_jobs_vl job,
2152: hr_lookups hrl,
2153: per_gen_hierarchy_nodes pgn_est
2154: WHERE peo.person_id = ass.person_id
2155: --AND peo.per_information1 is not NULL commented for fix for #12616269
2156: -- Added for fix for #12616269

Line 2240: hr_lookups hrl,

2236: hrl.lookup_code lookup_code
2237: FROM per_all_people_f peo,
2238: per_all_assignments_f ass,
2239: per_jobs_vl job,
2240: hr_lookups hrl,
2241: per_gen_hierarchy_nodes pgn_est
2242: WHERE peo.person_id = ass.person_id
2243: -- Modified to add function call per_us_hr_utility_pkg.derive_alien_ethnic_origin instead of peo.per_information1
2244: -- AND peo.per_information1 IN ('1','2','3','4','5','6','13') --BUG4410003