DBA Data[Home] [Help]

APPS.IGIDOSL dependencies on PER_PERIODS_OF_SERVICE

Line 690: per_periods_of_service b

686: FROM hr_all_positions_f hap,
687: per_all_assignments_f paa,
688: fnd_user fu ,
689: per_people_f p,
690: per_periods_of_service b
691: WHERE
692: fu.user_id = g_userid
693: AND paa.person_id = p.person_id
694: AND paa.primary_flag = 'Y'

Line 1726: per_periods_of_service b

1722: FROM hr_all_positions_f hap,
1723: per_all_assignments_f paa,
1724: fnd_user fu ,
1725: per_people_f p,
1726: per_periods_of_service b
1727: WHERE
1728: paa.person_id = p.person_id
1729: AND paa.primary_flag = 'Y'
1730: AND paa.period_of_service_id = b.period_of_service_id

Line 2782: per_periods_of_service b

2778: FROM
2779: hr_all_positions_f hap,
2780: per_all_assignments_f paa,
2781: per_people_f p,
2782: per_periods_of_service b
2783: WHERE
2784: p.person_id = p_emp_id
2785: AND paa.person_id = p.person_id
2786: AND paa.primary_flag = 'Y'