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_PRTT_ENRT_ACTN_API dependencies on BEN_PRTT_ENRT_RSLT_F

Line 29: from ben_prtt_enrt_rslt_f perslt

25: --
26: cursor c_suspend_enrl
27: is
28: select sspndd_flag
29: from ben_prtt_enrt_rslt_f perslt
30: where perslt.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
31: and perslt.prtt_enrt_rslt_stat_cd is null
32: and perslt.business_group_id = p_business_group_id
33: and p_effective_date between perslt.effective_start_date

Line 91: from ben_prtt_enrt_rslt_f perslt

87: --
88: cursor c_suspend_enrl
89: is
90: select sspndd_flag
91: from ben_prtt_enrt_rslt_f perslt
92: where perslt.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
93: and perslt.prtt_enrt_rslt_stat_cd is null
94: and perslt.business_group_id = p_business_group_id
95: and p_effective_date between perslt.effective_start_date

Line 230: from ben_prtt_enrt_rslt_f

226: ,ler_id
227: ,pgm_id
228: ,pl_id
229: ,pl_typ_id
230: from ben_prtt_enrt_rslt_f
231: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
232: and prtt_enrt_rslt_stat_cd is null
233: and p_effective_date between
234: effective_start_date and effective_end_date;

Line 236: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;

232: and prtt_enrt_rslt_stat_cd is null
233: and p_effective_date between
234: effective_start_date and effective_end_date;
235: --
236: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
237: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
238: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
239: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
240: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;

Line 237: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;

233: and p_effective_date between
234: effective_start_date and effective_end_date;
235: --
236: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
237: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
238: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
239: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
240: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
241: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;

Line 238: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;

234: effective_start_date and effective_end_date;
235: --
236: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
237: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
238: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
239: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
240: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
241: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;
242: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;

Line 239: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;

235: --
236: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
237: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
238: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
239: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
240: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
241: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;
242: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
243: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;

Line 240: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;

236: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
237: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
238: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
239: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
240: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
241: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;
242: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
243: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
244: l_proc varchar2(72) := g_package||'create_PRTT_ENRT_ACTN';

Line 477: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');

473: ,l_pl_typ_id;
474: if c_prtt_enrt_rslt%notfound then
475: close c_prtt_enrt_rslt;
476: fnd_message.set_name('BEN','BEN_91916_ENRT_TABLE_NOT_FOUND');
477: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');
478: fnd_message.raise_error;
479: end if;
480: close c_prtt_enrt_rslt;
481: --

Line 607: from ben_prtt_enrt_rslt_f

603: ,pgm_id
604: ,pl_id
605: ,pl_typ_id
606: ,per_in_ler_id
607: from ben_prtt_enrt_rslt_f
608: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
609: and prtt_enrt_rslt_stat_cd is null
610: and p_effective_date between
611: effective_start_date and effective_end_date;

Line 613: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;

609: and prtt_enrt_rslt_stat_cd is null
610: and p_effective_date between
611: effective_start_date and effective_end_date;
612: --
613: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
614: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
615: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
616: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
617: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;

Line 614: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;

610: and p_effective_date between
611: effective_start_date and effective_end_date;
612: --
613: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
614: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
615: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
616: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
617: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
618: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;

Line 615: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;

611: effective_start_date and effective_end_date;
612: --
613: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
614: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
615: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
616: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
617: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
618: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;
619: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;

Line 616: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;

612: --
613: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
614: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
615: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
616: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
617: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
618: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;
619: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
620: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;

Line 617: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;

613: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
614: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
615: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
616: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
617: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
618: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;
619: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
620: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
621: l_proc varchar2(72) := g_package||'create_PRTT_ENRT_ACTN';

Line 648: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');

644: ,l_per_in_ler_id;
645: if c_prtt_enrt_rslt%notfound then
646: close c_prtt_enrt_rslt;
647: fnd_message.set_name('BEN','BEN_91916_ENRT_TABLE_NOT_FOUND');
648: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');
649: fnd_message.raise_error;
650: end if;
651: close c_prtt_enrt_rslt;
652: --

Line 1006: from ben_prtt_enrt_rslt_f

1002: ,ler_id
1003: ,pgm_id
1004: ,pl_id
1005: ,pl_typ_id
1006: from ben_prtt_enrt_rslt_f
1007: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1008: and prtt_enrt_rslt_stat_cd is null
1009: and p_effective_date between
1010: effective_start_date and effective_end_date;

Line 1012: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;

1008: and prtt_enrt_rslt_stat_cd is null
1009: and p_effective_date between
1010: effective_start_date and effective_end_date;
1011: --
1012: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
1013: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
1014: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
1015: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
1016: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;

Line 1013: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;

1009: and p_effective_date between
1010: effective_start_date and effective_end_date;
1011: --
1012: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
1013: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
1014: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
1015: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
1016: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
1017: --

Line 1014: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;

1010: effective_start_date and effective_end_date;
1011: --
1012: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
1013: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
1014: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
1015: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
1016: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
1017: --
1018: l_proc varchar2(72) := g_package||'update_PRTT_ENRT_ACTN';

Line 1015: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;

1011: --
1012: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
1013: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
1014: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
1015: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
1016: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
1017: --
1018: l_proc varchar2(72) := g_package||'update_PRTT_ENRT_ACTN';
1019: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;

Line 1016: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;

1012: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
1013: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
1014: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
1015: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
1016: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
1017: --
1018: l_proc varchar2(72) := g_package||'update_PRTT_ENRT_ACTN';
1019: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
1020: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;

Line 1297: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');

1293: ,l_pl_typ_id;
1294: if c_prtt_enrt_rslt%notfound then
1295: close c_prtt_enrt_rslt;
1296: fnd_message.set_name('BEN','BEN_91916_ENRT_TABLE_NOT_FOUND');
1297: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');
1298: fnd_message.raise_error;
1299: end if;
1300: close c_prtt_enrt_rslt;
1301: --

Line 1451: from ben_prtt_enrt_rslt_f

1447: ,pgm_id
1448: ,pl_id
1449: ,pl_typ_id
1450: ,per_in_ler_id
1451: from ben_prtt_enrt_rslt_f
1452: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1453: and prtt_enrt_rslt_stat_cd is null
1454: and p_effective_date between
1455: effective_start_date and effective_end_date;

Line 1457: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;

1453: and prtt_enrt_rslt_stat_cd is null
1454: and p_effective_date between
1455: effective_start_date and effective_end_date;
1456: --
1457: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
1458: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
1459: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
1460: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
1461: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;

Line 1458: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;

1454: and p_effective_date between
1455: effective_start_date and effective_end_date;
1456: --
1457: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
1458: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
1459: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
1460: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
1461: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
1462: l_per_in_ler_id ben_prtt_enrt_rslt_f.per_in_ler_id%TYPE;

Line 1459: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;

1455: effective_start_date and effective_end_date;
1456: --
1457: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
1458: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
1459: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
1460: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
1461: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
1462: l_per_in_ler_id ben_prtt_enrt_rslt_f.per_in_ler_id%TYPE;
1463: --

Line 1460: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;

1456: --
1457: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
1458: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
1459: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
1460: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
1461: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
1462: l_per_in_ler_id ben_prtt_enrt_rslt_f.per_in_ler_id%TYPE;
1463: --
1464: l_proc varchar2(72) := g_package||'update_PRTT_ENRT_ACTN';

Line 1461: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;

1457: l_person_id ben_prtt_enrt_rslt_f.person_id%TYPE;
1458: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
1459: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
1460: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
1461: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
1462: l_per_in_ler_id ben_prtt_enrt_rslt_f.per_in_ler_id%TYPE;
1463: --
1464: l_proc varchar2(72) := g_package||'update_PRTT_ENRT_ACTN';
1465: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;

Line 1462: l_per_in_ler_id ben_prtt_enrt_rslt_f.per_in_ler_id%TYPE;

1458: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
1459: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
1460: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
1461: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
1462: l_per_in_ler_id ben_prtt_enrt_rslt_f.per_in_ler_id%TYPE;
1463: --
1464: l_proc varchar2(72) := g_package||'update_PRTT_ENRT_ACTN';
1465: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
1466: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;

Line 1502: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');

1498: ,l_per_in_ler_id;
1499: if c_prtt_enrt_rslt%notfound then
1500: close c_prtt_enrt_rslt;
1501: fnd_message.set_name('BEN','BEN_91916_ENRT_TABLE_NOT_FOUND');
1502: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');
1503: fnd_message.raise_error;
1504: end if;
1505: close c_prtt_enrt_rslt;
1506: --