DBA Data[Home] [Help]

APPS.IGIDOSL dependencies on PER_PEOPLE_F

Line 704: per_people_f p,

700: fu.user_name
701: FROM hr_all_positions_f hap,
702: per_all_assignments_f paa,
703: fnd_user fu ,
704: per_people_f p,
705: per_periods_of_service b
706: WHERE
707: fu.user_id = g_userid
708: AND paa.person_id = p.person_id

Line 1796: per_people_f p,

1792: select fu.user_name user_name
1793: FROM hr_all_positions_f hap,
1794: per_all_assignments_f paa,
1795: fnd_user fu ,
1796: per_people_f p,
1797: per_periods_of_service b
1798: WHERE
1799: paa.person_id = p.person_id
1800: AND paa.primary_flag = 'Y'

Line 2915: per_people_f p,

2911: hap.organization_id
2912: FROM
2913: hr_all_positions_f hap,
2914: per_all_assignments_f paa,
2915: per_people_f p,
2916: per_periods_of_service b
2917: WHERE
2918: p.person_id = p_emp_id
2919: AND paa.person_id = p.person_id