APPS.BEN_PLAN_BENEFICIARY_API dependencies on BEN_PL_BNF_CTFN_PRVDD_F

Line 1093: l2_object_version_number ben_pl_bnf_ctfn_prvdd_f.object_version_number%TYPE;

1089: l_effective_start_date ben_pl_bnf_f.effective_start_date%TYPE;
1090: l_effective_end_date ben_pl_bnf_f.effective_end_date%TYPE;
1091: --
1092: l_pl_bnf_ctfn_prvdd_id number;
1093: l2_object_version_number ben_pl_bnf_ctfn_prvdd_f.object_version_number%TYPE;
1094: l2_effective_start_date ben_pl_bnf_ctfn_prvdd_f.effective_start_date%TYPE;
1095: l2_effective_end_date ben_pl_bnf_ctfn_prvdd_f.effective_end_date%TYPE;
1096: --mactec
1097: l_effective_date date;

Line 1094: l2_effective_start_date ben_pl_bnf_ctfn_prvdd_f.effective_start_date%TYPE;

1090: l_effective_end_date ben_pl_bnf_f.effective_end_date%TYPE;
1091: --
1092: l_pl_bnf_ctfn_prvdd_id number;
1093: l2_object_version_number ben_pl_bnf_ctfn_prvdd_f.object_version_number%TYPE;
1094: l2_effective_start_date ben_pl_bnf_ctfn_prvdd_f.effective_start_date%TYPE;
1095: l2_effective_end_date ben_pl_bnf_ctfn_prvdd_f.effective_end_date%TYPE;
1096: --mactec
1097: l_effective_date date;
1098: l_datetrack_mode varchar2(30);

Line 1095: l2_effective_end_date ben_pl_bnf_ctfn_prvdd_f.effective_end_date%TYPE;

1091: --
1092: l_pl_bnf_ctfn_prvdd_id number;
1093: l2_object_version_number ben_pl_bnf_ctfn_prvdd_f.object_version_number%TYPE;
1094: l2_effective_start_date ben_pl_bnf_ctfn_prvdd_f.effective_start_date%TYPE;
1095: l2_effective_end_date ben_pl_bnf_ctfn_prvdd_f.effective_end_date%TYPE;
1096: --mactec
1097: l_effective_date date;
1098: l_datetrack_mode varchar2(30);
1099: --

Line 1112: from ben_pl_bnf_ctfn_prvdd_f

1108: cursor bnf_ctfn_c is
1109: select pl_bnf_ctfn_prvdd_id,
1110: object_version_number,
1111: effective_end_date
1112: from ben_pl_bnf_ctfn_prvdd_f
1113: where pl_bnf_id = p_pl_bnf_id
1114: and business_group_id = p_business_group_id
1115: and l_effective_date between effective_start_date
1116: and effective_end_date;

Line 1121: from ben_pl_bnf_ctfn_prvdd_f

1117: --
1118: cursor c_future_row (p_pl_bnf_ctfn_prvdd_id number,
1119: p_effective_date date) is
1120: select null
1121: from ben_pl_bnf_ctfn_prvdd_f
1122: where pl_bnf_ctfn_prvdd_id = p_pl_bnf_ctfn_prvdd_id
1123: and effective_start_date > p_effective_date;
1124: --
1125: cursor bnf_ctfn_id_zap_c is

Line 1127: from ben_pl_bnf_ctfn_prvdd_f

1123: and effective_start_date > p_effective_date;
1124: --
1125: cursor bnf_ctfn_id_zap_c is
1126: select distinct pl_bnf_ctfn_prvdd_id
1127: from ben_pl_bnf_ctfn_prvdd_f
1128: where pl_bnf_id = p_pl_bnf_id;
1129: --
1130: cursor bnf_ctfn_ovn_zap_c(l_pl_bnf_ctfn_prvdd_id in number) is
1131: select max(object_version_number)

Line 1132: from ben_pl_bnf_ctfn_prvdd_f

1128: where pl_bnf_id = p_pl_bnf_id;
1129: --
1130: cursor bnf_ctfn_ovn_zap_c(l_pl_bnf_ctfn_prvdd_id in number) is
1131: select max(object_version_number)
1132: from ben_pl_bnf_ctfn_prvdd_f
1133: where pl_bnf_ctfn_prvdd_id = l_pl_bnf_ctfn_prvdd_id;
1134: --
1135: l_dummy varchar2(300);
1136: begin