APPS.BEN_BENBATCH_PERSONS dependencies on BEN_MANAGE_LIFE_EVENTS

Line 1383: l_assignment_id_bind := ben_manage_life_events.g_irec_ass_rec.assignment_id;

1379: --
1380: -- IREC
1381: -- if its iREC pick up only applicants
1382: IF p_mode = 'I' THEN
1383: l_assignment_id_bind := ben_manage_life_events.g_irec_ass_rec.assignment_id;
1384: l_irec_whclause := ' and exists ( select ''x'' from per_person_type_usages_f ptu, '||
1385: ' per_person_types ppt, per_all_assignments_f apl_ass '||
1386: ' where ppt.person_type_id = ptu.person_type_id '||
1387: ' and ppt.system_person_type in( ''APL'', ''APL_EX_APL'',''EMP_APL'', ''EX_EMP_APL'')'||

Line 1404: l_assignment_id_bind := -1;--ben_manage_life_events.g_irec_ass_rec.assignment_id;

1400: --
1401: -- Bug 2279394 : where clause is not formed correctly, as and is missing
1402: -- in where clause.
1403: --
1404: l_assignment_id_bind := -1;--ben_manage_life_events.g_irec_ass_rec.assignment_id;
1405: l_irec_whclause := ' and :effective_date is NOT NULL and :assignment_id =-1 and :effective_date is NOT NULL ' ;
1406: l_query_str := l_query_str||l_irec_whclause ;
1407: --
1408: END IF;