APPS.PAY_EOSURVEY_PKG dependencies on FND_COMMON_LOOKUPS

Line 161: fnd_common_lookups fcl

157: ,'APPLICANT'
158: FROM per_assignments_f paf,
159: per_jobs pj,
160: per_assignment_status_types past,
161: fnd_common_lookups fcl
162: WHERE paf.assignment_status_type_id = past.assignment_status_type_id
163: AND --((
164: paf.assignment_type = 'A'
165: and paf.effective_end_date >= l_period_start

Line 198: ,fnd_common_lookups fcl

194: ,per_assignments_f paf
195: ,per_periods_of_service pps
196: ,per_person_types ppt
197: ,per_jobs pj
198: ,fnd_common_lookups fcl
199: WHERE pps.person_id = paf.person_id
200: and pps.actual_termination_date is not null
201: and pps.actual_termination_date
202: between l_period_start and l_period_end

Line 745: fnd_common_lookups fcl

741: ,paf.effective_start_date
742: ,paf.effective_end_date
743: FROM per_assignments_f paf,
744: per_jobs pj,
745: fnd_common_lookups fcl
746: WHERE paf.person_id =l_person_id
747: AND pj.job_id = paf.job_id
748: AND ( ( paf.assignment_type = 'A'
749: and l_person_type = 'EMP_APL'

Line 1820: from fnd_common_lookups

1816: '1','White',
1817: '9','Hispanic or Latino (White race only)',
1818: '3','Hispanic or Latino (all other races)',
1819: '10','Hispanic or Latino (all other races)',null)
1820: from fnd_common_lookups
1821: where lookup_code = c_race_code
1822: and lookup_type = 'US_ETHNIC_GROUP';
1823:
1824: l_ethnic_category fnd_common_lookups.meaning%type;

Line 1824: l_ethnic_category fnd_common_lookups.meaning%type;

1820: from fnd_common_lookups
1821: where lookup_code = c_race_code
1822: and lookup_type = 'US_ETHNIC_GROUP';
1823:
1824: l_ethnic_category fnd_common_lookups.meaning%type;
1825:
1826:
1827: begin
1828: hr_utility.trace('=============================== minority==================================');

Line 2007: FROM fnd_common_lookups

2003:
2004: CURSOR eeo1_job_code
2005: IS
2006: SELECT lookup_code
2007: FROM fnd_common_lookups
2008: WHERE lookup_type = 'US_EEO1_JOB_CATEGORIES'
2009: AND lookup_code <> '10';
2010:
2011: