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_PREM_API dependencies on BEN_PRTT_PREM_F

Line 35: from ben_prtt_prem_f ppe

31: l_proc varchar2(72) := g_package||'recalc_PRTT_PREM';
32: --- FONM p_date param added
33: cursor c_prtt_prem (p_date date ) is
34: select ppe.std_prem_val, ppe.actl_prem_id, ppe.prtt_enrt_rslt_id
35: from ben_prtt_prem_f ppe
36: where ppe.prtt_prem_id = p_prtt_prem_id
37: --and p_effective_date between
38: and p_date between
39: ppe.effective_start_date and ppe.effective_end_date;

Line 361: l_prtt_prem_id ben_prtt_prem_f.prtt_prem_id%TYPE;

357: ) is
358: --
359: -- Declare cursors and local variables
360: --
361: l_prtt_prem_id ben_prtt_prem_f.prtt_prem_id%TYPE;
362: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
363: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
364: l_proc varchar2(72) := g_package||'create_PRTT_PREM';
365: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;

Line 362: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;

358: --
359: -- Declare cursors and local variables
360: --
361: l_prtt_prem_id ben_prtt_prem_f.prtt_prem_id%TYPE;
362: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
363: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
364: l_proc varchar2(72) := g_package||'create_PRTT_PREM';
365: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
366: --

Line 363: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;

359: -- Declare cursors and local variables
360: --
361: l_prtt_prem_id ben_prtt_prem_f.prtt_prem_id%TYPE;
362: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
363: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
364: l_proc varchar2(72) := g_package||'create_PRTT_PREM';
365: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
366: --
367: begin

Line 365: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;

361: l_prtt_prem_id ben_prtt_prem_f.prtt_prem_id%TYPE;
362: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
363: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
364: l_proc varchar2(72) := g_package||'create_PRTT_PREM';
365: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
366: --
367: begin
368: --
369: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 654: l_prtt_prem_id ben_prtt_prem_f.prtt_prem_id%TYPE;

650: ) is
651: --
652: -- Declare cursors and local variables
653: --
654: l_prtt_prem_id ben_prtt_prem_f.prtt_prem_id%TYPE;
655: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
656: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
657: l_proc varchar2(72) := g_package||'create_PRTT_PREM';
658: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;

Line 655: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;

651: --
652: -- Declare cursors and local variables
653: --
654: l_prtt_prem_id ben_prtt_prem_f.prtt_prem_id%TYPE;
655: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
656: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
657: l_proc varchar2(72) := g_package||'create_PRTT_PREM';
658: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
659: l_per_in_ler_id ben_prtt_prem_f.per_in_ler_id%TYPE;

Line 656: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;

652: -- Declare cursors and local variables
653: --
654: l_prtt_prem_id ben_prtt_prem_f.prtt_prem_id%TYPE;
655: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
656: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
657: l_proc varchar2(72) := g_package||'create_PRTT_PREM';
658: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
659: l_per_in_ler_id ben_prtt_prem_f.per_in_ler_id%TYPE;
660: --

Line 658: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;

654: l_prtt_prem_id ben_prtt_prem_f.prtt_prem_id%TYPE;
655: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
656: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
657: l_proc varchar2(72) := g_package||'create_PRTT_PREM';
658: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
659: l_per_in_ler_id ben_prtt_prem_f.per_in_ler_id%TYPE;
660: --
661: cursor c_per_in_ler is
662: select pen.per_in_ler_id

Line 659: l_per_in_ler_id ben_prtt_prem_f.per_in_ler_id%TYPE;

655: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
656: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
657: l_proc varchar2(72) := g_package||'create_PRTT_PREM';
658: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
659: l_per_in_ler_id ben_prtt_prem_f.per_in_ler_id%TYPE;
660: --
661: cursor c_per_in_ler is
662: select pen.per_in_ler_id
663: from ben_prtt_enrt_rslt_f pen

Line 963: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;

959: --
960: -- Declare cursors and local variables
961: --
962: l_proc varchar2(72) := g_package||'update_PRTT_PREM';
963: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
964: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
965: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
966: --
967: begin

Line 964: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;

960: -- Declare cursors and local variables
961: --
962: l_proc varchar2(72) := g_package||'update_PRTT_PREM';
963: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
964: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
965: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
966: --
967: begin
968: --

Line 965: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;

961: --
962: l_proc varchar2(72) := g_package||'update_PRTT_PREM';
963: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
964: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
965: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
966: --
967: begin
968: --
969: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1256: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;

1252: --
1253: -- Declare cursors and local variables
1254: --
1255: l_proc varchar2(72) := g_package||'update_PRTT_PREM';
1256: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
1257: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
1258: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
1259: l_per_in_ler_id ben_prtt_prem_f.per_in_ler_id%TYPE;
1260: --

Line 1257: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;

1253: -- Declare cursors and local variables
1254: --
1255: l_proc varchar2(72) := g_package||'update_PRTT_PREM';
1256: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
1257: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
1258: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
1259: l_per_in_ler_id ben_prtt_prem_f.per_in_ler_id%TYPE;
1260: --
1261: cursor c_per_in_ler is

Line 1258: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;

1254: --
1255: l_proc varchar2(72) := g_package||'update_PRTT_PREM';
1256: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
1257: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
1258: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
1259: l_per_in_ler_id ben_prtt_prem_f.per_in_ler_id%TYPE;
1260: --
1261: cursor c_per_in_ler is
1262: select pen.per_in_ler_id

Line 1259: l_per_in_ler_id ben_prtt_prem_f.per_in_ler_id%TYPE;

1255: l_proc varchar2(72) := g_package||'update_PRTT_PREM';
1256: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
1257: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
1258: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
1259: l_per_in_ler_id ben_prtt_prem_f.per_in_ler_id%TYPE;
1260: --
1261: cursor c_per_in_ler is
1262: select pen.per_in_ler_id
1263: from ben_prtt_enrt_rslt_f pen

Line 1526: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;

1522: --
1523: -- Declare cursors and local variables
1524: --
1525: l_proc varchar2(72) := g_package||'update_PRTT_PREM';
1526: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
1527: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
1528: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
1529: --
1530: begin

Line 1527: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;

1523: -- Declare cursors and local variables
1524: --
1525: l_proc varchar2(72) := g_package||'update_PRTT_PREM';
1526: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
1527: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
1528: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
1529: --
1530: begin
1531: --

Line 1528: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;

1524: --
1525: l_proc varchar2(72) := g_package||'update_PRTT_PREM';
1526: l_object_version_number ben_prtt_prem_f.object_version_number%TYPE;
1527: l_effective_start_date ben_prtt_prem_f.effective_start_date%TYPE;
1528: l_effective_end_date ben_prtt_prem_f.effective_end_date%TYPE;
1529: --
1530: begin
1531: --
1532: hr_utility.set_location('Entering:'|| l_proc, 10);