DBA Data[Home] [Help]

APPS.IGIDOSL dependencies on PER_PERIODS_OF_SERVICE

Line 705: per_periods_of_service b

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
709: AND paa.primary_flag = 'Y'

Line 1797: per_periods_of_service b

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'
1801: AND paa.period_of_service_id = b.period_of_service_id

Line 2916: per_periods_of_service b

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
2920: AND paa.primary_flag = 'Y'