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_REIMBMT_RQST_API dependencies on BEN_PRTT_REIMBMT_RQST_F

Line 122: from ben_prtt_reimbmt_rqst_f prc

118: prc.popl_yr_perd_id_1,
119: prc.popl_yr_perd_id_2,
120: prc.amt_year1,
121: prc.amt_year2
122: from ben_prtt_reimbmt_rqst_f prc
123: where p_prtt_reimbmt_rqst_id = prc.prtt_reimbmt_rqst_id
124: and p_business_group_id = prc.business_group_id
125: and p_effective_Date between prc.effective_start_date
126: and prc.effective_end_date ;

Line 140: from ben_prtt_reimbmt_rqst_f prc,

136: ,pl.cmpr_clms_to_cvg_or_bal_cd
137: ,prc.SUBMITTER_PERSON_ID
138: ,prc.PRTT_ENRT_RSLT_ID
139: ,prc.EXP_INCURD_DT
140: from ben_prtt_reimbmt_rqst_f prc,
141: ben_pl_f pl
142: where prc.prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id
143: and pl.pl_id = prc.pl_id
144: and prc.EXP_INCURD_DT between pl.effective_start_date

Line 152: from ben_prtt_reimbmt_rqst_f prc,

148: cursor c_yr_amount (p_pl_id number ,
149: p_person_id number,
150: p_popl_yr_perd number ) is
151: select sum(nvl(pry.APRVD_FR_PYMT_AMT,0))
152: from ben_prtt_reimbmt_rqst_f prc,
153: ben_prtt_rmt_aprvd_fr_pymt_f pry
154: where prc.submitter_person_id = p_person_id
155: and prc.prtt_reimbmt_rqst_stat_cd not in ('DND','VOIDED','DPLICT')
156: and p_pl_id = prc.pl_id

Line 172: from ben_prtt_reimbmt_rqst_f prc

168: popl_yr_perd_id_1,
169: popl_yr_perd_id_2,
170: amt_year1,
171: amt_year2
172: from ben_prtt_reimbmt_rqst_f prc
173: where prc.submitter_person_id = p_person_id
174: and prc.prtt_reimbmt_rqst_stat_cd not in ('DND','VOIDED','DPLICT')
175: and p_pl_id = prc.pl_id
176: and (( prc.popl_yr_perd_id_1 = p_popl_yr_perd and prc.amt_year2 is not null)

Line 626: l_prtt_reimbmt_rqst_id ben_prtt_reimbmt_rqst_f.prtt_reimbmt_rqst_id%TYPE;

622: l_acty_base_rt c_abr_pl%rowtype;
623:
624: l_cvg_amt_calc_mthd_id number;
625: l_prtt_rmt_aprvd_fr_pymt_id number ;
626: l_prtt_reimbmt_rqst_id ben_prtt_reimbmt_rqst_f.prtt_reimbmt_rqst_id%TYPE;
627: l_effective_start_date ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
628: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
629: l_effective_start_date_pymt ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
630: l_effective_end_date_pymt ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;

Line 627: l_effective_start_date ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;

623:
624: l_cvg_amt_calc_mthd_id number;
625: l_prtt_rmt_aprvd_fr_pymt_id number ;
626: l_prtt_reimbmt_rqst_id ben_prtt_reimbmt_rqst_f.prtt_reimbmt_rqst_id%TYPE;
627: l_effective_start_date ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
628: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
629: l_effective_start_date_pymt ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
630: l_effective_end_date_pymt ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
631: l_proc varchar2(72) := g_package||'create_PRTT_REIMBMT_RQST';

Line 628: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;

624: l_cvg_amt_calc_mthd_id number;
625: l_prtt_rmt_aprvd_fr_pymt_id number ;
626: l_prtt_reimbmt_rqst_id ben_prtt_reimbmt_rqst_f.prtt_reimbmt_rqst_id%TYPE;
627: l_effective_start_date ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
628: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
629: l_effective_start_date_pymt ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
630: l_effective_end_date_pymt ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
631: l_proc varchar2(72) := g_package||'create_PRTT_REIMBMT_RQST';
632: l_object_version_number ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;

Line 629: l_effective_start_date_pymt ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;

625: l_prtt_rmt_aprvd_fr_pymt_id number ;
626: l_prtt_reimbmt_rqst_id ben_prtt_reimbmt_rqst_f.prtt_reimbmt_rqst_id%TYPE;
627: l_effective_start_date ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
628: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
629: l_effective_start_date_pymt ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
630: l_effective_end_date_pymt ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
631: l_proc varchar2(72) := g_package||'create_PRTT_REIMBMT_RQST';
632: l_object_version_number ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
633: l_object_version_number_pymt ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;

Line 630: l_effective_end_date_pymt ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;

626: l_prtt_reimbmt_rqst_id ben_prtt_reimbmt_rqst_f.prtt_reimbmt_rqst_id%TYPE;
627: l_effective_start_date ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
628: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
629: l_effective_start_date_pymt ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
630: l_effective_end_date_pymt ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
631: l_proc varchar2(72) := g_package||'create_PRTT_REIMBMT_RQST';
632: l_object_version_number ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
633: l_object_version_number_pymt ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
634: --

Line 632: l_object_version_number ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;

628: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
629: l_effective_start_date_pymt ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
630: l_effective_end_date_pymt ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
631: l_proc varchar2(72) := g_package||'create_PRTT_REIMBMT_RQST';
632: l_object_version_number ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
633: l_object_version_number_pymt ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
634: --
635: l_pymt_amount number ;
636: l_popl_yr_perd_id_1 number;

Line 633: l_object_version_number_pymt ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;

629: l_effective_start_date_pymt ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
630: l_effective_end_date_pymt ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
631: l_proc varchar2(72) := g_package||'create_PRTT_REIMBMT_RQST';
632: l_object_version_number ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
633: l_object_version_number_pymt ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
634: --
635: l_pymt_amount number ;
636: l_popl_yr_perd_id_1 number;
637: l_popl_yr_perd_id_2 number;

Line 1106: From ben_prtt_reimbmt_rqst_f prc

1102: -- DECLARE CURSORS
1103: --- Select old information to find the status
1104: Cursor c_prcold is
1105: select prc.*
1106: From ben_prtt_reimbmt_rqst_f prc
1107: where prc.prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id
1108: and p_effective_date between
1109: prc.effective_start_date and
1110: prc.effective_end_date;

Line 1133: l_object_version_number ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;

1129: -- Declare cursors and local variables
1130:
1131: l_prtt_rmt_aprvd_fr_pymt_id number ;
1132: l_proc varchar2(72) := g_package||'update_PRTT_REIMBMT_RQST';
1133: l_object_version_number ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
1134: l_object_version_number_pymt ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
1135: l_effective_start_date ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
1136: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
1137: l_effective_start_date_pymt ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;

Line 1134: l_object_version_number_pymt ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;

1130:
1131: l_prtt_rmt_aprvd_fr_pymt_id number ;
1132: l_proc varchar2(72) := g_package||'update_PRTT_REIMBMT_RQST';
1133: l_object_version_number ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
1134: l_object_version_number_pymt ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
1135: l_effective_start_date ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
1136: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
1137: l_effective_start_date_pymt ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
1138: l_effective_end_date_pymt ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;

Line 1135: l_effective_start_date ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;

1131: l_prtt_rmt_aprvd_fr_pymt_id number ;
1132: l_proc varchar2(72) := g_package||'update_PRTT_REIMBMT_RQST';
1133: l_object_version_number ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
1134: l_object_version_number_pymt ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
1135: l_effective_start_date ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
1136: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
1137: l_effective_start_date_pymt ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
1138: l_effective_end_date_pymt ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
1139: --

Line 1136: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;

1132: l_proc varchar2(72) := g_package||'update_PRTT_REIMBMT_RQST';
1133: l_object_version_number ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
1134: l_object_version_number_pymt ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
1135: l_effective_start_date ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
1136: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
1137: l_effective_start_date_pymt ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
1138: l_effective_end_date_pymt ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
1139: --
1140: l_dummy_number number;

Line 1137: l_effective_start_date_pymt ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;

1133: l_object_version_number ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
1134: l_object_version_number_pymt ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
1135: l_effective_start_date ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
1136: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
1137: l_effective_start_date_pymt ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
1138: l_effective_end_date_pymt ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
1139: --
1140: l_dummy_number number;
1141: l_pymt_amount number ;

Line 1138: l_effective_end_date_pymt ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;

1134: l_object_version_number_pymt ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
1135: l_effective_start_date ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
1136: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
1137: l_effective_start_date_pymt ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
1138: l_effective_end_date_pymt ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
1139: --
1140: l_dummy_number number;
1141: l_pymt_amount number ;
1142: l_popl_yr_perd_id_1 number := p_popl_yr_perd_id_1;

Line 1592: l_object_version_number ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;

1588: -- Declare cursors and local variables
1589: --
1590:
1591: l_proc varchar2(72) := g_package||'delete_PRTT_REIMBMT_RQST';
1592: l_object_version_number ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
1593: l_effective_start_date ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
1594: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
1595:
1596: --

Line 1593: l_effective_start_date ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;

1589: --
1590:
1591: l_proc varchar2(72) := g_package||'delete_PRTT_REIMBMT_RQST';
1592: l_object_version_number ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
1593: l_effective_start_date ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
1594: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
1595:
1596: --
1597: begin

Line 1594: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;

1590:
1591: l_proc varchar2(72) := g_package||'delete_PRTT_REIMBMT_RQST';
1592: l_object_version_number ben_prtt_reimbmt_rqst_f.object_version_number%TYPE;
1593: l_effective_start_date ben_prtt_reimbmt_rqst_f.effective_start_date%TYPE;
1594: l_effective_end_date ben_prtt_reimbmt_rqst_f.effective_end_date%TYPE;
1595:
1596: --
1597: begin
1598: --