DBA Data[Home] [Help]

APPS.HR_WPM_UTIL dependencies on FND_GLOBAL

Line 1119: WHERE ppf.person_id <> fnd_global.employee_id

1115: per_people_f ppf,
1116: per_assignments_f paf,
1117: per_assignments_f pa1,
1118: per_assignment_status_types pas
1119: WHERE ppf.person_id <> fnd_global.employee_id
1120: AND ppf.person_id = paf.person_id
1121: AND paf.primary_flag = 'Y'
1122: AND pa1.primary_flag = 'Y'
1123: AND paf.assignment_type IN ('E','C')

Line 1184: AND ppf.person_id <> fnd_global.employee_id

1180: per_assignments_f paf,
1181: per_assignments_f pa1,
1182: per_assignment_status_types pas
1183: WHERE sp.plan_id = p_plan_id
1184: AND ppf.person_id <> fnd_global.employee_id
1185: AND ppf.person_id = paf.person_id
1186: AND paf.primary_flag = 'Y'
1187: AND paf.assignment_type IN ('E','C')
1188: AND (pa1.assignment_type='A' OR (pa1.assignment_type IN ('E','C') AND pa1.primary_flag = 'Y'))