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_RMT_APRVD_PYMT_API dependencies on BEN_PRTT_RMT_APRVD_FR_PYMT_F

Line 176: l_prtt_rmt_aprvd_fr_pymt_id ben_prtt_rmt_aprvd_fr_pymt_f.prtt_rmt_aprvd_fr_pymt_id%TYPE;

172:
173:
174: -- Declare cursors and local variables
175: --
176: l_prtt_rmt_aprvd_fr_pymt_id ben_prtt_rmt_aprvd_fr_pymt_f.prtt_rmt_aprvd_fr_pymt_id%TYPE;
177: l_effective_start_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_start_date%TYPE;
178: l_effective_end_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_end_date%TYPE;
179: l_proc varchar2(72) := g_package||'create_prtt_rmt_aprvd_pymt';
180: l_object_version_number ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;

Line 177: l_effective_start_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_start_date%TYPE;

173:
174: -- Declare cursors and local variables
175: --
176: l_prtt_rmt_aprvd_fr_pymt_id ben_prtt_rmt_aprvd_fr_pymt_f.prtt_rmt_aprvd_fr_pymt_id%TYPE;
177: l_effective_start_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_start_date%TYPE;
178: l_effective_end_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_end_date%TYPE;
179: l_proc varchar2(72) := g_package||'create_prtt_rmt_aprvd_pymt';
180: l_object_version_number ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;
181: --

Line 178: l_effective_end_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_end_date%TYPE;

174: -- Declare cursors and local variables
175: --
176: l_prtt_rmt_aprvd_fr_pymt_id ben_prtt_rmt_aprvd_fr_pymt_f.prtt_rmt_aprvd_fr_pymt_id%TYPE;
177: l_effective_start_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_start_date%TYPE;
178: l_effective_end_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_end_date%TYPE;
179: l_proc varchar2(72) := g_package||'create_prtt_rmt_aprvd_pymt';
180: l_object_version_number ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;
181: --
182: l_prtt_rt_val_id number;

Line 180: l_object_version_number ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;

176: l_prtt_rmt_aprvd_fr_pymt_id ben_prtt_rmt_aprvd_fr_pymt_f.prtt_rmt_aprvd_fr_pymt_id%TYPE;
177: l_effective_start_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_start_date%TYPE;
178: l_effective_end_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_end_date%TYPE;
179: l_proc varchar2(72) := g_package||'create_prtt_rmt_aprvd_pymt';
180: l_object_version_number ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;
181: --
182: l_prtt_rt_val_id number;
183: l_prtt_enrt_rslt_id number;
184: l_object_version_number_prt ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;

Line 184: l_object_version_number_prt ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;

180: l_object_version_number ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;
181: --
182: l_prtt_rt_val_id number;
183: l_prtt_enrt_rslt_id number;
184: l_object_version_number_prt ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;
185: l_acty_ref_perd_cd varchar2(30);
186: l_pl_id number ;
187: l_cvg_amt_calc_mthd_id number ;
188: l_submitter_person_id number ;

Line 589: select * From ben_prtt_rmt_aprvd_fr_pymt_f pry

585: ) is
586: --
587: -- Declare cursors and local variables
588: cursor c_pry is
589: select * From ben_prtt_rmt_aprvd_fr_pymt_f pry
590: where p_effective_date between pry.effective_start_date
591: and pry.effective_end_date
592: and pry.prtt_rmt_aprvd_fr_pymt_id = p_prtt_rmt_aprvd_fr_pymt_id;
593:

Line 681: l_object_version_number ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;

677: --
678: l_input_value_id ben_acty_base_rt_f.input_value_id%type;
679: l_element_type_id ben_acty_base_rt_f.element_type_id%type ;
680: l_proc varchar2(72) := g_package||'update_prtt_rmt_aprvd_pymt';
681: l_object_version_number ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;
682: l_effective_start_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_start_date%TYPE;
683: l_effective_end_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_end_date%TYPE;
684: l_submitter_person_id number ;
685: l_dummy_number number ;

Line 682: l_effective_start_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_start_date%TYPE;

678: l_input_value_id ben_acty_base_rt_f.input_value_id%type;
679: l_element_type_id ben_acty_base_rt_f.element_type_id%type ;
680: l_proc varchar2(72) := g_package||'update_prtt_rmt_aprvd_pymt';
681: l_object_version_number ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;
682: l_effective_start_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_start_date%TYPE;
683: l_effective_end_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_end_date%TYPE;
684: l_submitter_person_id number ;
685: l_dummy_number number ;
686: l_pgm_id number;

Line 683: l_effective_end_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_end_date%TYPE;

679: l_element_type_id ben_acty_base_rt_f.element_type_id%type ;
680: l_proc varchar2(72) := g_package||'update_prtt_rmt_aprvd_pymt';
681: l_object_version_number ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;
682: l_effective_start_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_start_date%TYPE;
683: l_effective_end_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_end_date%TYPE;
684: l_submitter_person_id number ;
685: l_dummy_number number ;
686: l_pgm_id number;
687: l_prtt_enrt_rslt_id number;

Line 1038: select * From ben_prtt_rmt_aprvd_fr_pymt_f pry

1034: -- Declare cursors and local variables
1035:
1036:
1037: cursor c_pry is
1038: select * From ben_prtt_rmt_aprvd_fr_pymt_f pry
1039: where p_effective_date between pry.effective_start_date
1040: and pry.effective_end_date
1041: and pry.prtt_rmt_aprvd_fr_pymt_id = p_prtt_rmt_aprvd_fr_pymt_id;
1042: --

Line 1050: ben_prtt_rmt_aprvd_fr_pymt_f pyr

1046: select prc.submitter_person_id
1047: ,prc.prtt_reimbmt_rqst_id
1048: ,prc.business_group_id
1049: from ben_prtt_reimbmt_rqst_f prc ,
1050: ben_prtt_rmt_aprvd_fr_pymt_f pyr
1051: where prtt_rmt_aprvd_fr_pymt_id = p_prtt_rmt_aprvd_fr_pymt_id
1052: and prc.prtt_reimbmt_rqst_id = pyr.prtt_reimbmt_rqst_id
1053: and p_effective_date between
1054: pyr.effective_start_date and

Line 1064: l_object_version_number ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;

1060:
1061:
1062: --
1063: l_proc varchar2(72) := g_package||'delete_prtt_rmt_aprvd_pymt';
1064: l_object_version_number ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;
1065: l_effective_start_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_start_date%TYPE;
1066: l_effective_end_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_end_date%TYPE;
1067: l_submitter_person_id number ;
1068: l_prtt_reimbmt_rqst_id number ;

Line 1065: l_effective_start_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_start_date%TYPE;

1061:
1062: --
1063: l_proc varchar2(72) := g_package||'delete_prtt_rmt_aprvd_pymt';
1064: l_object_version_number ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;
1065: l_effective_start_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_start_date%TYPE;
1066: l_effective_end_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_end_date%TYPE;
1067: l_submitter_person_id number ;
1068: l_prtt_reimbmt_rqst_id number ;
1069: l_business_group_id number;

Line 1066: l_effective_end_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_end_date%TYPE;

1062: --
1063: l_proc varchar2(72) := g_package||'delete_prtt_rmt_aprvd_pymt';
1064: l_object_version_number ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;
1065: l_effective_start_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_start_date%TYPE;
1066: l_effective_end_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_end_date%TYPE;
1067: l_submitter_person_id number ;
1068: l_prtt_reimbmt_rqst_id number ;
1069: l_business_group_id number;
1070: