eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_DETERMINE_DPNT_ELIGIBILITY

Line 7419: NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0);

7415: -- pass the elig dependent id as input values to
7416: -- rule.
7417: --
7418: l_num_elig_dpnt :=
7419: NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0);
7420: --
7421: IF NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0) > 0 THEN
7422: FOR l_curr_count IN
7423: ben_determine_dpnt_eligibility.g_egd_table.FIRST .. ben_determine_dpnt_eligibility.g_egd_table.LAST LOOP

Line 7421: IF NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0) > 0 THEN

7417: --
7418: l_num_elig_dpnt :=
7419: NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0);
7420: --
7421: IF NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0) > 0 THEN
7422: FOR l_curr_count IN
7423: ben_determine_dpnt_eligibility.g_egd_table.FIRST .. ben_determine_dpnt_eligibility.g_egd_table.LAST LOOP
7424: --
7425: -- Currently we are passing only 20 input values.

Line 7423: ben_determine_dpnt_eligibility.g_egd_table.FIRST .. ben_determine_dpnt_eligibility.g_egd_table.LAST LOOP

7419: NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0);
7420: --
7421: IF NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0) > 0 THEN
7422: FOR l_curr_count IN
7423: ben_determine_dpnt_eligibility.g_egd_table.FIRST .. ben_determine_dpnt_eligibility.g_egd_table.LAST LOOP
7424: --
7425: -- Currently we are passing only 20 input values.
7426: -- Only 20 elig_dpnt_id are passed as input values.
7427: --

Line 7436: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7432: IF l_curr_count = 1 THEN
7433: l_param1 := 'ELIG_DPNT_ID1';
7434: l_param1_value :=
7435: TO_CHAR(
7436: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7437: ELSIF l_curr_count = 2 THEN
7438: l_param2 := 'ELIG_DPNT_ID2';
7439: l_param2_value :=
7440: TO_CHAR(

Line 7441: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7437: ELSIF l_curr_count = 2 THEN
7438: l_param2 := 'ELIG_DPNT_ID2';
7439: l_param2_value :=
7440: TO_CHAR(
7441: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7442: ELSIF l_curr_count = 3 THEN
7443: l_param3 := 'ELIG_DPNT_ID3';
7444: l_param3_value :=
7445: TO_CHAR(

Line 7446: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7442: ELSIF l_curr_count = 3 THEN
7443: l_param3 := 'ELIG_DPNT_ID3';
7444: l_param3_value :=
7445: TO_CHAR(
7446: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7447: ELSIF l_curr_count = 4 THEN
7448: l_param4 := 'ELIG_DPNT_ID4';
7449: l_param4_value :=
7450: TO_CHAR(

Line 7451: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7447: ELSIF l_curr_count = 4 THEN
7448: l_param4 := 'ELIG_DPNT_ID4';
7449: l_param4_value :=
7450: TO_CHAR(
7451: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7452: ELSIF l_curr_count = 5 THEN
7453: l_param5 := 'ELIG_DPNT_ID5';
7454: l_param5_value :=
7455: TO_CHAR(

Line 7456: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7452: ELSIF l_curr_count = 5 THEN
7453: l_param5 := 'ELIG_DPNT_ID5';
7454: l_param5_value :=
7455: TO_CHAR(
7456: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7457: ELSIF l_curr_count = 6 THEN
7458: l_param6 := 'ELIG_DPNT_ID6';
7459: l_param6_value :=
7460: TO_CHAR(

Line 7461: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7457: ELSIF l_curr_count = 6 THEN
7458: l_param6 := 'ELIG_DPNT_ID6';
7459: l_param6_value :=
7460: TO_CHAR(
7461: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7462: ELSIF l_curr_count = 7 THEN
7463: l_param7 := 'ELIG_DPNT_ID7';
7464: l_param7_value :=
7465: TO_CHAR(

Line 7466: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7462: ELSIF l_curr_count = 7 THEN
7463: l_param7 := 'ELIG_DPNT_ID7';
7464: l_param7_value :=
7465: TO_CHAR(
7466: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7467: ELSIF l_curr_count = 8 THEN
7468: l_param8 := 'ELIG_DPNT_ID8';
7469: l_param8_value :=
7470: TO_CHAR(

Line 7471: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7467: ELSIF l_curr_count = 8 THEN
7468: l_param8 := 'ELIG_DPNT_ID8';
7469: l_param8_value :=
7470: TO_CHAR(
7471: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7472: ELSIF l_curr_count = 9 THEN
7473: l_param9 := 'ELIG_DPNT_ID9';
7474: l_param9_value :=
7475: TO_CHAR(

Line 7476: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7472: ELSIF l_curr_count = 9 THEN
7473: l_param9 := 'ELIG_DPNT_ID9';
7474: l_param9_value :=
7475: TO_CHAR(
7476: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7477: ELSIF l_curr_count = 10 THEN
7478: l_param10 := 'ELIG_DPNT_ID10';
7479: l_param10_value :=
7480: TO_CHAR(

Line 7481: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7477: ELSIF l_curr_count = 10 THEN
7478: l_param10 := 'ELIG_DPNT_ID10';
7479: l_param10_value :=
7480: TO_CHAR(
7481: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7482: ELSIF l_curr_count = 11 THEN
7483: l_param11 := 'ELIG_DPNT_ID11';
7484: l_param11_value :=
7485: TO_CHAR(

Line 7486: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7482: ELSIF l_curr_count = 11 THEN
7483: l_param11 := 'ELIG_DPNT_ID11';
7484: l_param11_value :=
7485: TO_CHAR(
7486: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7487: ELSIF l_curr_count = 12 THEN
7488: l_param12 := 'ELIG_DPNT_ID12';
7489: l_param12_value :=
7490: TO_CHAR(

Line 7491: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7487: ELSIF l_curr_count = 12 THEN
7488: l_param12 := 'ELIG_DPNT_ID12';
7489: l_param12_value :=
7490: TO_CHAR(
7491: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7492: ELSIF l_curr_count = 13 THEN
7493: l_param13 := 'ELIG_DPNT_ID13';
7494: l_param13_value :=
7495: TO_CHAR(

Line 7496: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7492: ELSIF l_curr_count = 13 THEN
7493: l_param13 := 'ELIG_DPNT_ID13';
7494: l_param13_value :=
7495: TO_CHAR(
7496: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7497: ELSIF l_curr_count = 14 THEN
7498: l_param14 := 'ELIG_DPNT_ID14';
7499: l_param14_value :=
7500: TO_CHAR(

Line 7501: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7497: ELSIF l_curr_count = 14 THEN
7498: l_param14 := 'ELIG_DPNT_ID14';
7499: l_param14_value :=
7500: TO_CHAR(
7501: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7502: ELSIF l_curr_count = 15 THEN
7503: l_param15 := 'ELIG_DPNT_ID15';
7504: l_param15_value :=
7505: TO_CHAR(

Line 7506: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7502: ELSIF l_curr_count = 15 THEN
7503: l_param15 := 'ELIG_DPNT_ID15';
7504: l_param15_value :=
7505: TO_CHAR(
7506: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7507: ELSIF l_curr_count = 16 THEN
7508: l_param16 := 'ELIG_DPNT_ID16';
7509: l_param16_value :=
7510: TO_CHAR(

Line 7511: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7507: ELSIF l_curr_count = 16 THEN
7508: l_param16 := 'ELIG_DPNT_ID16';
7509: l_param16_value :=
7510: TO_CHAR(
7511: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7512: ELSIF l_curr_count = 17 THEN
7513: l_param17 := 'ELIG_DPNT_ID17';
7514: l_param17_value :=
7515: TO_CHAR(

Line 7516: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7512: ELSIF l_curr_count = 17 THEN
7513: l_param17 := 'ELIG_DPNT_ID17';
7514: l_param17_value :=
7515: TO_CHAR(
7516: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7517: ELSIF l_curr_count = 18 THEN
7518: l_param18 := 'ELIG_DPNT_ID18';
7519: l_param18_value :=
7520: TO_CHAR(

Line 7521: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7517: ELSIF l_curr_count = 18 THEN
7518: l_param18 := 'ELIG_DPNT_ID18';
7519: l_param18_value :=
7520: TO_CHAR(
7521: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7522: ELSIF l_curr_count = 19 THEN
7523: l_param19 := 'ELIG_DPNT_ID19';
7524: l_param19_value :=
7525: TO_CHAR(

Line 7526: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7522: ELSIF l_curr_count = 19 THEN
7523: l_param19 := 'ELIG_DPNT_ID19';
7524: l_param19_value :=
7525: TO_CHAR(
7526: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7527: ELSIF l_curr_count = 20 THEN
7528: l_param20 := 'ELIG_DPNT_ID20';
7529: l_param20_value :=
7530: TO_CHAR(

Line 7531: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7527: ELSIF l_curr_count = 20 THEN
7528: l_param20 := 'ELIG_DPNT_ID20';
7529: l_param20_value :=
7530: TO_CHAR(
7531: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7532: END IF;
7533: --
7534: END LOOP;
7535: --

Line 7739: NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0);

7735: -- pass the elig dependent id as input values to
7736: -- rule.
7737: --
7738: l_num_elig_dpnt :=
7739: NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0);
7740: --
7741: IF NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0) > 0 THEN
7742: FOR l_curr_count IN
7743: ben_determine_dpnt_eligibility.g_egd_table.FIRST .. ben_determine_dpnt_eligibility.g_egd_table.LAST LOOP

Line 7741: IF NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0) > 0 THEN

7737: --
7738: l_num_elig_dpnt :=
7739: NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0);
7740: --
7741: IF NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0) > 0 THEN
7742: FOR l_curr_count IN
7743: ben_determine_dpnt_eligibility.g_egd_table.FIRST .. ben_determine_dpnt_eligibility.g_egd_table.LAST LOOP
7744: --
7745: -- Currently we are passing only 20 input values.

Line 7743: ben_determine_dpnt_eligibility.g_egd_table.FIRST .. ben_determine_dpnt_eligibility.g_egd_table.LAST LOOP

7739: NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0);
7740: --
7741: IF NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0) > 0 THEN
7742: FOR l_curr_count IN
7743: ben_determine_dpnt_eligibility.g_egd_table.FIRST .. ben_determine_dpnt_eligibility.g_egd_table.LAST LOOP
7744: --
7745: -- Currently we are passing only 20 input values.
7746: -- Only 20 elig_dpnt_id are passed as input values.
7747: --

Line 7756: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7752: IF l_curr_count = 1 THEN
7753: l_param1 := 'ELIG_DPNT_ID1';
7754: l_param1_value :=
7755: TO_CHAR(
7756: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7757: ELSIF l_curr_count = 2 THEN
7758: l_param2 := 'ELIG_DPNT_ID2';
7759: l_param2_value :=
7760: TO_CHAR(

Line 7761: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7757: ELSIF l_curr_count = 2 THEN
7758: l_param2 := 'ELIG_DPNT_ID2';
7759: l_param2_value :=
7760: TO_CHAR(
7761: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7762: ELSIF l_curr_count = 3 THEN
7763: l_param3 := 'ELIG_DPNT_ID3';
7764: l_param3_value :=
7765: TO_CHAR(

Line 7766: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7762: ELSIF l_curr_count = 3 THEN
7763: l_param3 := 'ELIG_DPNT_ID3';
7764: l_param3_value :=
7765: TO_CHAR(
7766: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7767: ELSIF l_curr_count = 4 THEN
7768: l_param4 := 'ELIG_DPNT_ID4';
7769: l_param4_value :=
7770: TO_CHAR(

Line 7771: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7767: ELSIF l_curr_count = 4 THEN
7768: l_param4 := 'ELIG_DPNT_ID4';
7769: l_param4_value :=
7770: TO_CHAR(
7771: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7772: ELSIF l_curr_count = 5 THEN
7773: l_param5 := 'ELIG_DPNT_ID5';
7774: l_param5_value :=
7775: TO_CHAR(

Line 7776: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7772: ELSIF l_curr_count = 5 THEN
7773: l_param5 := 'ELIG_DPNT_ID5';
7774: l_param5_value :=
7775: TO_CHAR(
7776: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7777: ELSIF l_curr_count = 6 THEN
7778: l_param6 := 'ELIG_DPNT_ID6';
7779: l_param6_value :=
7780: TO_CHAR(

Line 7781: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7777: ELSIF l_curr_count = 6 THEN
7778: l_param6 := 'ELIG_DPNT_ID6';
7779: l_param6_value :=
7780: TO_CHAR(
7781: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7782: ELSIF l_curr_count = 7 THEN
7783: l_param7 := 'ELIG_DPNT_ID7';
7784: l_param7_value :=
7785: TO_CHAR(

Line 7786: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7782: ELSIF l_curr_count = 7 THEN
7783: l_param7 := 'ELIG_DPNT_ID7';
7784: l_param7_value :=
7785: TO_CHAR(
7786: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7787: ELSIF l_curr_count = 8 THEN
7788: l_param8 := 'ELIG_DPNT_ID8';
7789: l_param8_value :=
7790: TO_CHAR(

Line 7791: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7787: ELSIF l_curr_count = 8 THEN
7788: l_param8 := 'ELIG_DPNT_ID8';
7789: l_param8_value :=
7790: TO_CHAR(
7791: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7792: ELSIF l_curr_count = 9 THEN
7793: l_param9 := 'ELIG_DPNT_ID9';
7794: l_param9_value :=
7795: TO_CHAR(

Line 7796: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7792: ELSIF l_curr_count = 9 THEN
7793: l_param9 := 'ELIG_DPNT_ID9';
7794: l_param9_value :=
7795: TO_CHAR(
7796: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7797: ELSIF l_curr_count = 10 THEN
7798: l_param10 := 'ELIG_DPNT_ID10';
7799: l_param10_value :=
7800: TO_CHAR(

Line 7801: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7797: ELSIF l_curr_count = 10 THEN
7798: l_param10 := 'ELIG_DPNT_ID10';
7799: l_param10_value :=
7800: TO_CHAR(
7801: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7802: ELSIF l_curr_count = 11 THEN
7803: l_param11 := 'ELIG_DPNT_ID11';
7804: l_param11_value :=
7805: TO_CHAR(

Line 7806: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7802: ELSIF l_curr_count = 11 THEN
7803: l_param11 := 'ELIG_DPNT_ID11';
7804: l_param11_value :=
7805: TO_CHAR(
7806: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7807: ELSIF l_curr_count = 12 THEN
7808: l_param12 := 'ELIG_DPNT_ID12';
7809: l_param12_value :=
7810: TO_CHAR(

Line 7811: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7807: ELSIF l_curr_count = 12 THEN
7808: l_param12 := 'ELIG_DPNT_ID12';
7809: l_param12_value :=
7810: TO_CHAR(
7811: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7812: ELSIF l_curr_count = 13 THEN
7813: l_param13 := 'ELIG_DPNT_ID13';
7814: l_param13_value :=
7815: TO_CHAR(

Line 7816: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7812: ELSIF l_curr_count = 13 THEN
7813: l_param13 := 'ELIG_DPNT_ID13';
7814: l_param13_value :=
7815: TO_CHAR(
7816: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7817: ELSIF l_curr_count = 14 THEN
7818: l_param14 := 'ELIG_DPNT_ID14';
7819: l_param14_value :=
7820: TO_CHAR(

Line 7821: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7817: ELSIF l_curr_count = 14 THEN
7818: l_param14 := 'ELIG_DPNT_ID14';
7819: l_param14_value :=
7820: TO_CHAR(
7821: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7822: ELSIF l_curr_count = 15 THEN
7823: l_param15 := 'ELIG_DPNT_ID15';
7824: l_param15_value :=
7825: TO_CHAR(

Line 7826: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7822: ELSIF l_curr_count = 15 THEN
7823: l_param15 := 'ELIG_DPNT_ID15';
7824: l_param15_value :=
7825: TO_CHAR(
7826: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7827: ELSIF l_curr_count = 16 THEN
7828: l_param16 := 'ELIG_DPNT_ID16';
7829: l_param16_value :=
7830: TO_CHAR(

Line 7831: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7827: ELSIF l_curr_count = 16 THEN
7828: l_param16 := 'ELIG_DPNT_ID16';
7829: l_param16_value :=
7830: TO_CHAR(
7831: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7832: ELSIF l_curr_count = 17 THEN
7833: l_param17 := 'ELIG_DPNT_ID17';
7834: l_param17_value :=
7835: TO_CHAR(

Line 7836: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7832: ELSIF l_curr_count = 17 THEN
7833: l_param17 := 'ELIG_DPNT_ID17';
7834: l_param17_value :=
7835: TO_CHAR(
7836: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7837: ELSIF l_curr_count = 18 THEN
7838: l_param18 := 'ELIG_DPNT_ID18';
7839: l_param18_value :=
7840: TO_CHAR(

Line 7841: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7837: ELSIF l_curr_count = 18 THEN
7838: l_param18 := 'ELIG_DPNT_ID18';
7839: l_param18_value :=
7840: TO_CHAR(
7841: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7842: ELSIF l_curr_count = 19 THEN
7843: l_param19 := 'ELIG_DPNT_ID19';
7844: l_param19_value :=
7845: TO_CHAR(

Line 7846: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7842: ELSIF l_curr_count = 19 THEN
7843: l_param19 := 'ELIG_DPNT_ID19';
7844: l_param19_value :=
7845: TO_CHAR(
7846: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7847: ELSIF l_curr_count = 20 THEN
7848: l_param20 := 'ELIG_DPNT_ID20';
7849: l_param20_value :=
7850: TO_CHAR(

Line 7851: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);

7847: ELSIF l_curr_count = 20 THEN
7848: l_param20 := 'ELIG_DPNT_ID20';
7849: l_param20_value :=
7850: TO_CHAR(
7851: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7852: END IF;
7853: --
7854: END LOOP;
7855: --

Line 10424: ben_determine_dpnt_eligibility.g_egd_table.DELETE;

10420: -- start 5092244
10421:
10422: IF NVL (l_pl_enrt_cd, '-1') = 'RL'
10423: THEN
10424: ben_determine_dpnt_eligibility.g_egd_table.DELETE;
10425: ben_determine_dpnt_eligibility.g_egd_table :=
10426: ben_determine_dpnt_eligibility.g_egd_table_temp;
10427: OPEN c_elig_dpnt (l_epe_id);
10428: if g_debug then

Line 10425: ben_determine_dpnt_eligibility.g_egd_table :=

10421:
10422: IF NVL (l_pl_enrt_cd, '-1') = 'RL'
10423: THEN
10424: ben_determine_dpnt_eligibility.g_egd_table.DELETE;
10425: ben_determine_dpnt_eligibility.g_egd_table :=
10426: ben_determine_dpnt_eligibility.g_egd_table_temp;
10427: OPEN c_elig_dpnt (l_epe_id);
10428: if g_debug then
10429: hr_utility.set_location('SS Populating g_egd_table',9909);

Line 10426: ben_determine_dpnt_eligibility.g_egd_table_temp;

10422: IF NVL (l_pl_enrt_cd, '-1') = 'RL'
10423: THEN
10424: ben_determine_dpnt_eligibility.g_egd_table.DELETE;
10425: ben_determine_dpnt_eligibility.g_egd_table :=
10426: ben_determine_dpnt_eligibility.g_egd_table_temp;
10427: OPEN c_elig_dpnt (l_epe_id);
10428: if g_debug then
10429: hr_utility.set_location('SS Populating g_egd_table',9909);
10430: end if;

Line 10435: NVL (ben_determine_dpnt_eligibility.g_egd_table.LAST, 0)

10431: LOOP
10432: FETCH c_elig_dpnt INTO l_elig_dpnt;
10433: EXIT WHEN c_elig_dpnt%NOTFOUND;
10434: l_next_row :=
10435: NVL (ben_determine_dpnt_eligibility.g_egd_table.LAST, 0)
10436: + 1;
10437: ben_determine_dpnt_eligibility.g_egd_table (l_next_row).object_version_number :=
10438: l_elig_dpnt.object_version_number;
10439: ben_determine_dpnt_eligibility.g_egd_table (l_next_row).elig_dpnt_id :=

Line 10437: ben_determine_dpnt_eligibility.g_egd_table (l_next_row).object_version_number :=

10433: EXIT WHEN c_elig_dpnt%NOTFOUND;
10434: l_next_row :=
10435: NVL (ben_determine_dpnt_eligibility.g_egd_table.LAST, 0)
10436: + 1;
10437: ben_determine_dpnt_eligibility.g_egd_table (l_next_row).object_version_number :=
10438: l_elig_dpnt.object_version_number;
10439: ben_determine_dpnt_eligibility.g_egd_table (l_next_row).elig_dpnt_id :=
10440: l_elig_dpnt.elig_dpnt_id;
10441: END LOOP;

Line 10439: ben_determine_dpnt_eligibility.g_egd_table (l_next_row).elig_dpnt_id :=

10435: NVL (ben_determine_dpnt_eligibility.g_egd_table.LAST, 0)
10436: + 1;
10437: ben_determine_dpnt_eligibility.g_egd_table (l_next_row).object_version_number :=
10438: l_elig_dpnt.object_version_number;
10439: ben_determine_dpnt_eligibility.g_egd_table (l_next_row).elig_dpnt_id :=
10440: l_elig_dpnt.elig_dpnt_id;
10441: END LOOP;
10442:
10443: CLOSE c_elig_dpnt;