DBA Data[Home] [Help]

APPS.BEN_TEST_HARNESS dependencies on BEN_PER_IN_LER

Line 1409: from ben_per_in_ler pil

1405: )
1406: is
1407: select pil.ler_id,
1408: pil.LF_EVT_OCRD_DT
1409: from ben_per_in_ler pil
1410: where pil.per_in_ler_id =
1411: (select max(pil1.per_in_ler_id)
1412: from ben_per_in_ler pil1
1413: where pil1.person_id = pil.person_id

Line 1412: from ben_per_in_ler pil1

1408: pil.LF_EVT_OCRD_DT
1409: from ben_per_in_ler pil
1410: where pil.per_in_ler_id =
1411: (select max(pil1.per_in_ler_id)
1412: from ben_per_in_ler pil1
1413: where pil1.person_id = pil.person_id
1414: and pil1.PER_IN_LER_STAT_CD not in ('VOIDD','BCKDT')
1415: )
1416: and pil.person_id = c_per_id