APPS.PER_CAGR_EVALUATION_PKG dependencies on BEN_BATCH_ELIG_INFO

Line 1311: from ben_batch_elig_info bbe

1307: PGM_ID,
1308: PL_ID,
1309: OIPL_ID,
1310: ELIG_FLAG
1311: from ben_batch_elig_info bbe
1312: where bbe.BENEFIT_ACTION_ID = p_benefit_action_id
1313: and bbe.OIPL_ID is not null;
1314:
1315: l_proc constant VARCHAR2(61) := g_pkg || '.' || 'get_BEN_eligibility_info';

Line 1362: FROM ben_batch_elig_info bbe

1358: -- Bug 13703461
1359: l_person_id per_all_people_f.person_id%TYPE;
1360: CURSOR csr_check_elig IS
1361: SELECT person_id
1362: FROM ben_batch_elig_info bbe
1363: WHERE bbe.benefit_action_id = g_benefit_action_id
1364: AND oipl_id = p_oipl_id
1365: AND person_id = p_person_id
1366: AND elig_flag = 'Y'

Line 1369: l_oipl_id ben_batch_elig_info.oipl_id%TYPE;

1365: AND person_id = p_person_id
1366: AND elig_flag = 'Y'
1367: AND oipl_id IS NOT NULL;
1368:
1369: l_oipl_id ben_batch_elig_info.oipl_id%TYPE;
1370: CURSOR csr_check_oipl IS
1371: SELECT oipl_id
1372: FROM ben_batch_elig_info bbe
1373: WHERE bbe.benefit_action_id = g_benefit_action_id

Line 1372: FROM ben_batch_elig_info bbe

1368:
1369: l_oipl_id ben_batch_elig_info.oipl_id%TYPE;
1370: CURSOR csr_check_oipl IS
1371: SELECT oipl_id
1372: FROM ben_batch_elig_info bbe
1373: WHERE bbe.benefit_action_id = g_benefit_action_id
1374: AND oipl_id = p_oipl_id
1375: AND oipl_id IS NOT NULL;
1376: