DBA Data[Home] [Help]

APPS.BEN_EXT_SORT dependencies on BEN_EXT_RSLT_DTL

Line 32: l_prmy_val ben_ext_rslt_dtl.val_01%type := null;

28: l_prmy_seq_num number;
29: l_scnd_seq_num number;
30: l_thrd_seq_num number;
31: l_frth_seq_num number;
32: l_prmy_val ben_ext_rslt_dtl.val_01%type := null;
33: l_scnd_val ben_ext_rslt_dtl.val_01%type := null;
34: l_thrd_val ben_ext_rslt_dtl.val_01%type := null;
35: l_frth_val ben_ext_rslt_dtl.val_01%type := null;
36: l_trans_count varchar2(50);

Line 33: l_scnd_val ben_ext_rslt_dtl.val_01%type := null;

29: l_scnd_seq_num number;
30: l_thrd_seq_num number;
31: l_frth_seq_num number;
32: l_prmy_val ben_ext_rslt_dtl.val_01%type := null;
33: l_scnd_val ben_ext_rslt_dtl.val_01%type := null;
34: l_thrd_val ben_ext_rslt_dtl.val_01%type := null;
35: l_frth_val ben_ext_rslt_dtl.val_01%type := null;
36: l_trans_count varchar2(50);
37: l_person_id varchar2(55);

Line 34: l_thrd_val ben_ext_rslt_dtl.val_01%type := null;

30: l_thrd_seq_num number;
31: l_frth_seq_num number;
32: l_prmy_val ben_ext_rslt_dtl.val_01%type := null;
33: l_scnd_val ben_ext_rslt_dtl.val_01%type := null;
34: l_thrd_val ben_ext_rslt_dtl.val_01%type := null;
35: l_frth_val ben_ext_rslt_dtl.val_01%type := null;
36: l_trans_count varchar2(50);
37: l_person_id varchar2(55);
38: l_ext_chg_evt_log_id varchar2(55);

Line 35: l_frth_val ben_ext_rslt_dtl.val_01%type := null;

31: l_frth_seq_num number;
32: l_prmy_val ben_ext_rslt_dtl.val_01%type := null;
33: l_scnd_val ben_ext_rslt_dtl.val_01%type := null;
34: l_thrd_val ben_ext_rslt_dtl.val_01%type := null;
35: l_frth_val ben_ext_rslt_dtl.val_01%type := null;
36: l_trans_count varchar2(50);
37: l_person_id varchar2(55);
38: l_ext_chg_evt_log_id varchar2(55);
39: l_per_cm_prvdd_id varchar2(15);

Line 41: l_dflt_val ben_ext_rslt_dtl.val_01%type := null;

37: l_person_id varchar2(55);
38: l_ext_chg_evt_log_id varchar2(55);
39: l_per_cm_prvdd_id varchar2(15);
40: l_dflt_id number;
41: l_dflt_val ben_ext_rslt_dtl.val_01%type := null;
42: l_prmy_val_max number := 25;
43: l_scnd_val_max number := 25;
44: l_thrd_val_max number := 25;
45: l_frth_val_max number := 25;