APPS.BEN_BENBATCH_PERSONS dependencies on BEN_MANAGE_LIFE_EVENTS

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

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

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

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