APPS.PAY_EOSURVEY_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 160: per_assignment_status_types past,

156: paf.assignment_status_type_id
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'

Line 289: per_assignment_status_types.assignment_status_type_id%type)

285:
286: /* An assignment_type of 'A' is checked if its an ACCEPTED assignment.*/
287:
288: CURSOR applicant_accepted(l_asgn_status_id
289: per_assignment_status_types.assignment_status_type_id%type)
290: is
291: select 'x'
292: from per_assignment_status_types
293: where per_system_status = 'ACCEPTED'

Line 292: from per_assignment_status_types

288: CURSOR applicant_accepted(l_asgn_status_id
289: per_assignment_status_types.assignment_status_type_id%type)
290: is
291: select 'x'
292: from per_assignment_status_types
293: where per_system_status = 'ACCEPTED'
294: and assignment_status_type_id = l_asgn_status_id;
295:
296: /* This cursor checks if applicant was also an ACTIVE_APL in the same period.

Line 305: per_assignment_Status_types past

301: l_period_end date)
302: is
303: select 'x'
304: from per_assignments_f paf,
305: per_assignment_Status_types past
306: where paf.assignment_id = l_asgn_id
307: and paf.assignment_type = 'A'
308: and paf.assignment_status_type_id = past.assignment_status_type_id
309: and past.per_system_status = 'ACTIVE_APL'