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 7555: NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0);

7551: -- pass the elig dependent id as input values to
7552: -- rule.
7553: --
7554: l_num_elig_dpnt :=
7555: NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0);
7556: --
7557: IF NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0) > 0 THEN
7558: FOR l_curr_count IN
7559: ben_determine_dpnt_eligibility.g_egd_table.FIRST .. ben_determine_dpnt_eligibility.g_egd_table.LAST LOOP

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

7553: --
7554: l_num_elig_dpnt :=
7555: NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0);
7556: --
7557: IF NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0) > 0 THEN
7558: FOR l_curr_count IN
7559: ben_determine_dpnt_eligibility.g_egd_table.FIRST .. ben_determine_dpnt_eligibility.g_egd_table.LAST LOOP
7560: --
7561: -- Currently we are passing only 20 input values.

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

7555: NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0);
7556: --
7557: IF NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0) > 0 THEN
7558: FOR l_curr_count IN
7559: ben_determine_dpnt_eligibility.g_egd_table.FIRST .. ben_determine_dpnt_eligibility.g_egd_table.LAST LOOP
7560: --
7561: -- Currently we are passing only 20 input values.
7562: -- Only 20 elig_dpnt_id are passed as input values.
7563: --

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

7568: IF l_curr_count = 1 THEN
7569: l_param1 := 'ELIG_DPNT_ID1';
7570: l_param1_value :=
7571: TO_CHAR(
7572: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7573: ELSIF l_curr_count = 2 THEN
7574: l_param2 := 'ELIG_DPNT_ID2';
7575: l_param2_value :=
7576: TO_CHAR(

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

7573: ELSIF l_curr_count = 2 THEN
7574: l_param2 := 'ELIG_DPNT_ID2';
7575: l_param2_value :=
7576: TO_CHAR(
7577: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7578: ELSIF l_curr_count = 3 THEN
7579: l_param3 := 'ELIG_DPNT_ID3';
7580: l_param3_value :=
7581: TO_CHAR(

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

7578: ELSIF l_curr_count = 3 THEN
7579: l_param3 := 'ELIG_DPNT_ID3';
7580: l_param3_value :=
7581: TO_CHAR(
7582: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7583: ELSIF l_curr_count = 4 THEN
7584: l_param4 := 'ELIG_DPNT_ID4';
7585: l_param4_value :=
7586: TO_CHAR(

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

7583: ELSIF l_curr_count = 4 THEN
7584: l_param4 := 'ELIG_DPNT_ID4';
7585: l_param4_value :=
7586: TO_CHAR(
7587: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7588: ELSIF l_curr_count = 5 THEN
7589: l_param5 := 'ELIG_DPNT_ID5';
7590: l_param5_value :=
7591: TO_CHAR(

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

7588: ELSIF l_curr_count = 5 THEN
7589: l_param5 := 'ELIG_DPNT_ID5';
7590: l_param5_value :=
7591: TO_CHAR(
7592: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7593: ELSIF l_curr_count = 6 THEN
7594: l_param6 := 'ELIG_DPNT_ID6';
7595: l_param6_value :=
7596: TO_CHAR(

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

7593: ELSIF l_curr_count = 6 THEN
7594: l_param6 := 'ELIG_DPNT_ID6';
7595: l_param6_value :=
7596: TO_CHAR(
7597: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7598: ELSIF l_curr_count = 7 THEN
7599: l_param7 := 'ELIG_DPNT_ID7';
7600: l_param7_value :=
7601: TO_CHAR(

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

7598: ELSIF l_curr_count = 7 THEN
7599: l_param7 := 'ELIG_DPNT_ID7';
7600: l_param7_value :=
7601: TO_CHAR(
7602: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7603: ELSIF l_curr_count = 8 THEN
7604: l_param8 := 'ELIG_DPNT_ID8';
7605: l_param8_value :=
7606: TO_CHAR(

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

7603: ELSIF l_curr_count = 8 THEN
7604: l_param8 := 'ELIG_DPNT_ID8';
7605: l_param8_value :=
7606: TO_CHAR(
7607: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7608: ELSIF l_curr_count = 9 THEN
7609: l_param9 := 'ELIG_DPNT_ID9';
7610: l_param9_value :=
7611: TO_CHAR(

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

7608: ELSIF l_curr_count = 9 THEN
7609: l_param9 := 'ELIG_DPNT_ID9';
7610: l_param9_value :=
7611: TO_CHAR(
7612: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7613: ELSIF l_curr_count = 10 THEN
7614: l_param10 := 'ELIG_DPNT_ID10';
7615: l_param10_value :=
7616: TO_CHAR(

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

7613: ELSIF l_curr_count = 10 THEN
7614: l_param10 := 'ELIG_DPNT_ID10';
7615: l_param10_value :=
7616: TO_CHAR(
7617: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7618: ELSIF l_curr_count = 11 THEN
7619: l_param11 := 'ELIG_DPNT_ID11';
7620: l_param11_value :=
7621: TO_CHAR(

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

7618: ELSIF l_curr_count = 11 THEN
7619: l_param11 := 'ELIG_DPNT_ID11';
7620: l_param11_value :=
7621: TO_CHAR(
7622: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7623: ELSIF l_curr_count = 12 THEN
7624: l_param12 := 'ELIG_DPNT_ID12';
7625: l_param12_value :=
7626: TO_CHAR(

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

7623: ELSIF l_curr_count = 12 THEN
7624: l_param12 := 'ELIG_DPNT_ID12';
7625: l_param12_value :=
7626: TO_CHAR(
7627: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7628: ELSIF l_curr_count = 13 THEN
7629: l_param13 := 'ELIG_DPNT_ID13';
7630: l_param13_value :=
7631: TO_CHAR(

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

7628: ELSIF l_curr_count = 13 THEN
7629: l_param13 := 'ELIG_DPNT_ID13';
7630: l_param13_value :=
7631: TO_CHAR(
7632: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7633: ELSIF l_curr_count = 14 THEN
7634: l_param14 := 'ELIG_DPNT_ID14';
7635: l_param14_value :=
7636: TO_CHAR(

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

7633: ELSIF l_curr_count = 14 THEN
7634: l_param14 := 'ELIG_DPNT_ID14';
7635: l_param14_value :=
7636: TO_CHAR(
7637: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7638: ELSIF l_curr_count = 15 THEN
7639: l_param15 := 'ELIG_DPNT_ID15';
7640: l_param15_value :=
7641: TO_CHAR(

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

7638: ELSIF l_curr_count = 15 THEN
7639: l_param15 := 'ELIG_DPNT_ID15';
7640: l_param15_value :=
7641: TO_CHAR(
7642: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7643: ELSIF l_curr_count = 16 THEN
7644: l_param16 := 'ELIG_DPNT_ID16';
7645: l_param16_value :=
7646: TO_CHAR(

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

7643: ELSIF l_curr_count = 16 THEN
7644: l_param16 := 'ELIG_DPNT_ID16';
7645: l_param16_value :=
7646: TO_CHAR(
7647: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7648: ELSIF l_curr_count = 17 THEN
7649: l_param17 := 'ELIG_DPNT_ID17';
7650: l_param17_value :=
7651: TO_CHAR(

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

7648: ELSIF l_curr_count = 17 THEN
7649: l_param17 := 'ELIG_DPNT_ID17';
7650: l_param17_value :=
7651: TO_CHAR(
7652: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7653: ELSIF l_curr_count = 18 THEN
7654: l_param18 := 'ELIG_DPNT_ID18';
7655: l_param18_value :=
7656: TO_CHAR(

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

7653: ELSIF l_curr_count = 18 THEN
7654: l_param18 := 'ELIG_DPNT_ID18';
7655: l_param18_value :=
7656: TO_CHAR(
7657: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7658: ELSIF l_curr_count = 19 THEN
7659: l_param19 := 'ELIG_DPNT_ID19';
7660: l_param19_value :=
7661: TO_CHAR(

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

7658: ELSIF l_curr_count = 19 THEN
7659: l_param19 := 'ELIG_DPNT_ID19';
7660: l_param19_value :=
7661: TO_CHAR(
7662: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7663: ELSIF l_curr_count = 20 THEN
7664: l_param20 := 'ELIG_DPNT_ID20';
7665: l_param20_value :=
7666: TO_CHAR(

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

7663: ELSIF l_curr_count = 20 THEN
7664: l_param20 := 'ELIG_DPNT_ID20';
7665: l_param20_value :=
7666: TO_CHAR(
7667: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7668: END IF;
7669: --
7670: END LOOP;
7671: --

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

7871: -- pass the elig dependent id as input values to
7872: -- rule.
7873: --
7874: l_num_elig_dpnt :=
7875: NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0);
7876: --
7877: IF NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0) > 0 THEN
7878: FOR l_curr_count IN
7879: ben_determine_dpnt_eligibility.g_egd_table.FIRST .. ben_determine_dpnt_eligibility.g_egd_table.LAST LOOP

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

7873: --
7874: l_num_elig_dpnt :=
7875: NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0);
7876: --
7877: IF NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0) > 0 THEN
7878: FOR l_curr_count IN
7879: ben_determine_dpnt_eligibility.g_egd_table.FIRST .. ben_determine_dpnt_eligibility.g_egd_table.LAST LOOP
7880: --
7881: -- Currently we are passing only 20 input values.

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

7875: NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0);
7876: --
7877: IF NVL(ben_determine_dpnt_eligibility.g_egd_table.LAST, 0) > 0 THEN
7878: FOR l_curr_count IN
7879: ben_determine_dpnt_eligibility.g_egd_table.FIRST .. ben_determine_dpnt_eligibility.g_egd_table.LAST LOOP
7880: --
7881: -- Currently we are passing only 20 input values.
7882: -- Only 20 elig_dpnt_id are passed as input values.
7883: --

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

7888: IF l_curr_count = 1 THEN
7889: l_param1 := 'ELIG_DPNT_ID1';
7890: l_param1_value :=
7891: TO_CHAR(
7892: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7893: ELSIF l_curr_count = 2 THEN
7894: l_param2 := 'ELIG_DPNT_ID2';
7895: l_param2_value :=
7896: TO_CHAR(

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

7893: ELSIF l_curr_count = 2 THEN
7894: l_param2 := 'ELIG_DPNT_ID2';
7895: l_param2_value :=
7896: TO_CHAR(
7897: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7898: ELSIF l_curr_count = 3 THEN
7899: l_param3 := 'ELIG_DPNT_ID3';
7900: l_param3_value :=
7901: TO_CHAR(

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

7898: ELSIF l_curr_count = 3 THEN
7899: l_param3 := 'ELIG_DPNT_ID3';
7900: l_param3_value :=
7901: TO_CHAR(
7902: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7903: ELSIF l_curr_count = 4 THEN
7904: l_param4 := 'ELIG_DPNT_ID4';
7905: l_param4_value :=
7906: TO_CHAR(

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

7903: ELSIF l_curr_count = 4 THEN
7904: l_param4 := 'ELIG_DPNT_ID4';
7905: l_param4_value :=
7906: TO_CHAR(
7907: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7908: ELSIF l_curr_count = 5 THEN
7909: l_param5 := 'ELIG_DPNT_ID5';
7910: l_param5_value :=
7911: TO_CHAR(

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

7908: ELSIF l_curr_count = 5 THEN
7909: l_param5 := 'ELIG_DPNT_ID5';
7910: l_param5_value :=
7911: TO_CHAR(
7912: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7913: ELSIF l_curr_count = 6 THEN
7914: l_param6 := 'ELIG_DPNT_ID6';
7915: l_param6_value :=
7916: TO_CHAR(

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

7913: ELSIF l_curr_count = 6 THEN
7914: l_param6 := 'ELIG_DPNT_ID6';
7915: l_param6_value :=
7916: TO_CHAR(
7917: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7918: ELSIF l_curr_count = 7 THEN
7919: l_param7 := 'ELIG_DPNT_ID7';
7920: l_param7_value :=
7921: TO_CHAR(

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

7918: ELSIF l_curr_count = 7 THEN
7919: l_param7 := 'ELIG_DPNT_ID7';
7920: l_param7_value :=
7921: TO_CHAR(
7922: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7923: ELSIF l_curr_count = 8 THEN
7924: l_param8 := 'ELIG_DPNT_ID8';
7925: l_param8_value :=
7926: TO_CHAR(

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

7923: ELSIF l_curr_count = 8 THEN
7924: l_param8 := 'ELIG_DPNT_ID8';
7925: l_param8_value :=
7926: TO_CHAR(
7927: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7928: ELSIF l_curr_count = 9 THEN
7929: l_param9 := 'ELIG_DPNT_ID9';
7930: l_param9_value :=
7931: TO_CHAR(

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

7928: ELSIF l_curr_count = 9 THEN
7929: l_param9 := 'ELIG_DPNT_ID9';
7930: l_param9_value :=
7931: TO_CHAR(
7932: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7933: ELSIF l_curr_count = 10 THEN
7934: l_param10 := 'ELIG_DPNT_ID10';
7935: l_param10_value :=
7936: TO_CHAR(

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

7933: ELSIF l_curr_count = 10 THEN
7934: l_param10 := 'ELIG_DPNT_ID10';
7935: l_param10_value :=
7936: TO_CHAR(
7937: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7938: ELSIF l_curr_count = 11 THEN
7939: l_param11 := 'ELIG_DPNT_ID11';
7940: l_param11_value :=
7941: TO_CHAR(

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

7938: ELSIF l_curr_count = 11 THEN
7939: l_param11 := 'ELIG_DPNT_ID11';
7940: l_param11_value :=
7941: TO_CHAR(
7942: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7943: ELSIF l_curr_count = 12 THEN
7944: l_param12 := 'ELIG_DPNT_ID12';
7945: l_param12_value :=
7946: TO_CHAR(

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

7943: ELSIF l_curr_count = 12 THEN
7944: l_param12 := 'ELIG_DPNT_ID12';
7945: l_param12_value :=
7946: TO_CHAR(
7947: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7948: ELSIF l_curr_count = 13 THEN
7949: l_param13 := 'ELIG_DPNT_ID13';
7950: l_param13_value :=
7951: TO_CHAR(

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

7948: ELSIF l_curr_count = 13 THEN
7949: l_param13 := 'ELIG_DPNT_ID13';
7950: l_param13_value :=
7951: TO_CHAR(
7952: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7953: ELSIF l_curr_count = 14 THEN
7954: l_param14 := 'ELIG_DPNT_ID14';
7955: l_param14_value :=
7956: TO_CHAR(

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

7953: ELSIF l_curr_count = 14 THEN
7954: l_param14 := 'ELIG_DPNT_ID14';
7955: l_param14_value :=
7956: TO_CHAR(
7957: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7958: ELSIF l_curr_count = 15 THEN
7959: l_param15 := 'ELIG_DPNT_ID15';
7960: l_param15_value :=
7961: TO_CHAR(

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

7958: ELSIF l_curr_count = 15 THEN
7959: l_param15 := 'ELIG_DPNT_ID15';
7960: l_param15_value :=
7961: TO_CHAR(
7962: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7963: ELSIF l_curr_count = 16 THEN
7964: l_param16 := 'ELIG_DPNT_ID16';
7965: l_param16_value :=
7966: TO_CHAR(

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

7963: ELSIF l_curr_count = 16 THEN
7964: l_param16 := 'ELIG_DPNT_ID16';
7965: l_param16_value :=
7966: TO_CHAR(
7967: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7968: ELSIF l_curr_count = 17 THEN
7969: l_param17 := 'ELIG_DPNT_ID17';
7970: l_param17_value :=
7971: TO_CHAR(

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

7968: ELSIF l_curr_count = 17 THEN
7969: l_param17 := 'ELIG_DPNT_ID17';
7970: l_param17_value :=
7971: TO_CHAR(
7972: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7973: ELSIF l_curr_count = 18 THEN
7974: l_param18 := 'ELIG_DPNT_ID18';
7975: l_param18_value :=
7976: TO_CHAR(

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

7973: ELSIF l_curr_count = 18 THEN
7974: l_param18 := 'ELIG_DPNT_ID18';
7975: l_param18_value :=
7976: TO_CHAR(
7977: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7978: ELSIF l_curr_count = 19 THEN
7979: l_param19 := 'ELIG_DPNT_ID19';
7980: l_param19_value :=
7981: TO_CHAR(

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

7978: ELSIF l_curr_count = 19 THEN
7979: l_param19 := 'ELIG_DPNT_ID19';
7980: l_param19_value :=
7981: TO_CHAR(
7982: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7983: ELSIF l_curr_count = 20 THEN
7984: l_param20 := 'ELIG_DPNT_ID20';
7985: l_param20_value :=
7986: TO_CHAR(

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

7983: ELSIF l_curr_count = 20 THEN
7984: l_param20 := 'ELIG_DPNT_ID20';
7985: l_param20_value :=
7986: TO_CHAR(
7987: ben_determine_dpnt_eligibility.g_egd_table(l_curr_count).elig_dpnt_id);
7988: END IF;
7989: --
7990: END LOOP;
7991: --

Line 10617: ben_determine_dpnt_eligibility.g_egd_table.DELETE;

10613: -- start 5092244
10614:
10615: IF NVL (l_pl_enrt_cd, '-1') = 'RL'
10616: THEN
10617: ben_determine_dpnt_eligibility.g_egd_table.DELETE;
10618: ben_determine_dpnt_eligibility.g_egd_table :=
10619: ben_determine_dpnt_eligibility.g_egd_table_temp;
10620: OPEN c_elig_dpnt (l_epe_id);
10621: if g_debug then

Line 10618: ben_determine_dpnt_eligibility.g_egd_table :=

10614:
10615: IF NVL (l_pl_enrt_cd, '-1') = 'RL'
10616: THEN
10617: ben_determine_dpnt_eligibility.g_egd_table.DELETE;
10618: ben_determine_dpnt_eligibility.g_egd_table :=
10619: ben_determine_dpnt_eligibility.g_egd_table_temp;
10620: OPEN c_elig_dpnt (l_epe_id);
10621: if g_debug then
10622: hr_utility.set_location('SS Populating g_egd_table',9909);

Line 10619: ben_determine_dpnt_eligibility.g_egd_table_temp;

10615: IF NVL (l_pl_enrt_cd, '-1') = 'RL'
10616: THEN
10617: ben_determine_dpnt_eligibility.g_egd_table.DELETE;
10618: ben_determine_dpnt_eligibility.g_egd_table :=
10619: ben_determine_dpnt_eligibility.g_egd_table_temp;
10620: OPEN c_elig_dpnt (l_epe_id);
10621: if g_debug then
10622: hr_utility.set_location('SS Populating g_egd_table',9909);
10623: end if;

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

10624: LOOP
10625: FETCH c_elig_dpnt INTO l_elig_dpnt;
10626: EXIT WHEN c_elig_dpnt%NOTFOUND;
10627: l_next_row :=
10628: NVL (ben_determine_dpnt_eligibility.g_egd_table.LAST, 0)
10629: + 1;
10630: ben_determine_dpnt_eligibility.g_egd_table (l_next_row).object_version_number :=
10631: l_elig_dpnt.object_version_number;
10632: ben_determine_dpnt_eligibility.g_egd_table (l_next_row).elig_dpnt_id :=

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

10626: EXIT WHEN c_elig_dpnt%NOTFOUND;
10627: l_next_row :=
10628: NVL (ben_determine_dpnt_eligibility.g_egd_table.LAST, 0)
10629: + 1;
10630: ben_determine_dpnt_eligibility.g_egd_table (l_next_row).object_version_number :=
10631: l_elig_dpnt.object_version_number;
10632: ben_determine_dpnt_eligibility.g_egd_table (l_next_row).elig_dpnt_id :=
10633: l_elig_dpnt.elig_dpnt_id;
10634: END LOOP;

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

10628: NVL (ben_determine_dpnt_eligibility.g_egd_table.LAST, 0)
10629: + 1;
10630: ben_determine_dpnt_eligibility.g_egd_table (l_next_row).object_version_number :=
10631: l_elig_dpnt.object_version_number;
10632: ben_determine_dpnt_eligibility.g_egd_table (l_next_row).elig_dpnt_id :=
10633: l_elig_dpnt.elig_dpnt_id;
10634: END LOOP;
10635:
10636: CLOSE c_elig_dpnt;