APPS.BEN_ECL_BUS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 297: from per_assignment_status_types a,

293: l_dummy varchar2(1);
294: --
295: cursor c1 is
296: select null
297: from per_assignment_status_types a,
298: ben_elig_ee_stat_prte_f b
299: where b.eligy_prfl_id = p_eligy_prfl_id
300: and b.assignment_status_type_id = a.assignment_status_type_id
301: and a.per_system_status = 'TERM_ASSIGN'