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.

[Home] [Help]

APPS.BEN_BENEFIT_PRVDD_LEDGER_API dependencies on BEN_BNFT_PRVDD_LDGR_F

Line 81: l_prtt_enrt_rslt_id ben_bnft_prvdd_ldgr_f.prtt_enrt_rslt_id%TYPE;

77: ) is
78: --
79: -- Declare cursors and local variables
80: --
81: l_prtt_enrt_rslt_id ben_bnft_prvdd_ldgr_f.prtt_enrt_rslt_id%TYPE;
82: l_bnft_prvdd_ldgr_id ben_bnft_prvdd_ldgr_f.bnft_prvdd_ldgr_id%TYPE;
83: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
84: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
85: l_proc varchar2(72) := g_package||'create_Benefit_Prvdd_Ledger';

Line 82: l_bnft_prvdd_ldgr_id ben_bnft_prvdd_ldgr_f.bnft_prvdd_ldgr_id%TYPE;

78: --
79: -- Declare cursors and local variables
80: --
81: l_prtt_enrt_rslt_id ben_bnft_prvdd_ldgr_f.prtt_enrt_rslt_id%TYPE;
82: l_bnft_prvdd_ldgr_id ben_bnft_prvdd_ldgr_f.bnft_prvdd_ldgr_id%TYPE;
83: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
84: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
85: l_proc varchar2(72) := g_package||'create_Benefit_Prvdd_Ledger';
86: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;

Line 83: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;

79: -- Declare cursors and local variables
80: --
81: l_prtt_enrt_rslt_id ben_bnft_prvdd_ldgr_f.prtt_enrt_rslt_id%TYPE;
82: l_bnft_prvdd_ldgr_id ben_bnft_prvdd_ldgr_f.bnft_prvdd_ldgr_id%TYPE;
83: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
84: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
85: l_proc varchar2(72) := g_package||'create_Benefit_Prvdd_Ledger';
86: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
87: l_prtt_rt_val_id number;

Line 84: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;

80: --
81: l_prtt_enrt_rslt_id ben_bnft_prvdd_ldgr_f.prtt_enrt_rslt_id%TYPE;
82: l_bnft_prvdd_ldgr_id ben_bnft_prvdd_ldgr_f.bnft_prvdd_ldgr_id%TYPE;
83: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
84: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
85: l_proc varchar2(72) := g_package||'create_Benefit_Prvdd_Ledger';
86: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
87: l_prtt_rt_val_id number;
88:

Line 86: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;

82: l_bnft_prvdd_ldgr_id ben_bnft_prvdd_ldgr_f.bnft_prvdd_ldgr_id%TYPE;
83: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
84: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
85: l_proc varchar2(72) := g_package||'create_Benefit_Prvdd_Ledger';
86: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
87: l_prtt_rt_val_id number;
88:
89: l_cmcd_frftd_val number := null;
90: l_cmcd_prvdd_val number := null;

Line 103: from ben_bnft_prvdd_ldgr_f bpl

99: l_acty_ref_perd_cd varchar2(30) := null;
100: l_cmcd_ref_perd_cd varchar2(30) := null;
101: cursor c1 is
102: select object_version_number
103: from ben_bnft_prvdd_ldgr_f bpl
104: where bnft_prvdd_ldgr_id = l_bnft_prvdd_ldgr_id
105: and p_effective_date between bpl.effective_start_date
106: and bpl.effective_end_date;
107: --

Line 602: l_bnft_prvdd_ldgr_id ben_bnft_prvdd_ldgr_f.bnft_prvdd_ldgr_id%TYPE;

598: )is
599: --
600: -- Declare cursors and local variables
601: --
602: l_bnft_prvdd_ldgr_id ben_bnft_prvdd_ldgr_f.bnft_prvdd_ldgr_id%TYPE;
603: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
604: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
605: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
606: l_validate BOOLEAN;

Line 603: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;

599: --
600: -- Declare cursors and local variables
601: --
602: l_bnft_prvdd_ldgr_id ben_bnft_prvdd_ldgr_f.bnft_prvdd_ldgr_id%TYPE;
603: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
604: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
605: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
606: l_validate BOOLEAN;
607:

Line 604: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;

600: -- Declare cursors and local variables
601: --
602: l_bnft_prvdd_ldgr_id ben_bnft_prvdd_ldgr_f.bnft_prvdd_ldgr_id%TYPE;
603: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
604: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
605: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
606: l_validate BOOLEAN;
607:
608: l_proc varchar2(72) := g_package||'create_Benefit_Prvdd_Ledger_w';

Line 605: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;

601: --
602: l_bnft_prvdd_ldgr_id ben_bnft_prvdd_ldgr_f.bnft_prvdd_ldgr_id%TYPE;
603: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
604: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
605: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
606: l_validate BOOLEAN;
607:
608: l_proc varchar2(72) := g_package||'create_Benefit_Prvdd_Ledger_w';
609: --

Line 761: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;

757: --
758: -- Declare cursors and local variables
759: --
760: l_proc varchar2(72) := g_package||'update_Benefit_Prvdd_Ledger';
761: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
762: l_dup_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
763: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
764: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
765: l_bnft_prvdr_pool_id number;

Line 762: l_dup_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;

758: -- Declare cursors and local variables
759: --
760: l_proc varchar2(72) := g_package||'update_Benefit_Prvdd_Ledger';
761: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
762: l_dup_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
763: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
764: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
765: l_bnft_prvdr_pool_id number;
766: l_person_id number;

Line 763: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;

759: --
760: l_proc varchar2(72) := g_package||'update_Benefit_Prvdd_Ledger';
761: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
762: l_dup_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
763: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
764: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
765: l_bnft_prvdr_pool_id number;
766: l_person_id number;
767: l_acty_base_rt_id number;

Line 764: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;

760: l_proc varchar2(72) := g_package||'update_Benefit_Prvdd_Ledger';
761: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
762: l_dup_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
763: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
764: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
765: l_bnft_prvdr_pool_id number;
766: l_person_id number;
767: l_acty_base_rt_id number;
768: l_per_in_ler_id number;

Line 781: from ben_bnft_prvdd_ldgr_f bpl,

777: bpl.acty_base_rt_id,
778: bpl.per_in_ler_id,
779: bpl.used_val,
780: pen.enrt_mthd_cd
781: from ben_bnft_prvdd_ldgr_f bpl,
782: ben_prtt_enrt_rslt_f pen,
783: -- Bug : 1634870 : UK changes
784: ben_per_in_ler pil
785: where bpl.bnft_prvdd_ldgr_id=p_bnft_prvdd_ldgr_id and

Line 801: from ben_bnft_prvdd_ldgr_f bpl

797: --
798: -- Bug: 3611160/4169180: Added this cursor.
799: cursor c1 is
800: select object_version_number
801: from ben_bnft_prvdd_ldgr_f bpl
802: where bnft_prvdd_ldgr_id = p_bnft_prvdd_ldgr_id
803: and p_effective_date between bpl.effective_start_date
804: and bpl.effective_end_date;
805: --

Line 1256: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;

1252: ) is
1253: --
1254: -- Declare cursors and local variables
1255: --
1256: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
1257: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
1258: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
1259: l_validate BOOLEAN;
1260: --

Line 1257: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;

1253: --
1254: -- Declare cursors and local variables
1255: --
1256: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
1257: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
1258: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
1259: l_validate BOOLEAN;
1260: --
1261: l_proc varchar2(72) := g_package||'update_Benefit_Prvdd_Ledger_w';

Line 1258: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;

1254: -- Declare cursors and local variables
1255: --
1256: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
1257: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
1258: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
1259: l_validate BOOLEAN;
1260: --
1261: l_proc varchar2(72) := g_package||'update_Benefit_Prvdd_Ledger_w';
1262: --

Line 1354: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;

1350: --
1351: -- Declare cursors and local variables
1352: --
1353: l_proc varchar2(72) := g_package||'delete_Benefit_Prvdd_Ledger';
1354: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
1355: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
1356: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
1357: l_bnft_prvdr_pool_id number;
1358: l_person_id number;

Line 1355: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;

1351: -- Declare cursors and local variables
1352: --
1353: l_proc varchar2(72) := g_package||'delete_Benefit_Prvdd_Ledger';
1354: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
1355: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
1356: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
1357: l_bnft_prvdr_pool_id number;
1358: l_person_id number;
1359: l_acty_base_rt_id number;

Line 1356: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;

1352: --
1353: l_proc varchar2(72) := g_package||'delete_Benefit_Prvdd_Ledger';
1354: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
1355: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
1356: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
1357: l_bnft_prvdr_pool_id number;
1358: l_person_id number;
1359: l_acty_base_rt_id number;
1360: l_per_in_ler_id number;

Line 1375: from ben_bnft_prvdd_ldgr_f bpl,

1371: bpl.per_in_ler_id,
1372: bpl.used_val,
1373: pen.enrt_mthd_cd,
1374: bpl.prtt_ro_of_unusd_amt_flag
1375: from ben_bnft_prvdd_ldgr_f bpl,
1376: ben_prtt_enrt_rslt_f pen,
1377: -- UK Changes.
1378: ben_per_in_ler pil
1379: where bpl.bnft_prvdd_ldgr_id=p_bnft_prvdd_ldgr_id and

Line 1609: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;

1605: ) is
1606: --
1607: -- Declare cursors and local variables
1608: --
1609: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
1610: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
1611: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
1612: l_validate BOOLEAN;
1613: --

Line 1610: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;

1606: --
1607: -- Declare cursors and local variables
1608: --
1609: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
1610: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
1611: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
1612: l_validate BOOLEAN;
1613: --
1614: l_proc varchar2(72) := g_package||'delete_Benefit_Prvdd_Ledger';

Line 1611: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;

1607: -- Declare cursors and local variables
1608: --
1609: l_object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%TYPE;
1610: l_effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%TYPE;
1611: l_effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%TYPE;
1612: l_validate BOOLEAN;
1613: --
1614: l_proc varchar2(72) := g_package||'delete_Benefit_Prvdd_Ledger';
1615: --