APPS.BEN_PERSON_OBJECT dependencies on BEN_BNFTS_BAL_F

Line 44: ben_bnfts_bal_f.

40: 115.9 16-Aug-99 gperry Used nocopy compiler directive.
41: 115.10 17-Aug-99 gperry Removed business group id check from
42: set_ast_object.
43: 115.11 18-Aug-99 gperry Added new cache structures for
44: ben_bnfts_bal_f.
45: 115.12 23-Aug-99 gperry Cache full time info using assignment id.
46: Removed trace messages.
47: Hashing done locally now.
48: 115.13 26-Aug-99 gperry Added benefits assignment cache.

Line 186: procedure set_object(p_rec in out NOCOPY ben_bnfts_bal_f%rowtype) is

182: g_cache_per_rec(l_index):=p_rec;
183: --
184: end set_object;
185: --
186: procedure set_object(p_rec in out NOCOPY ben_bnfts_bal_f%rowtype) is
187: --
188: l_proc varchar2(80) := g_package||'set_object bnb';
189: l_index pls_integer;
190: --

Line 1116: p_rec in out nocopy ben_bnfts_bal_f%rowtype) is

1112: procedure set_bnb_object
1113: (p_bnfts_bal_id in number,
1114: p_business_group_id in number,
1115: p_effective_date in date,
1116: p_rec in out nocopy ben_bnfts_bal_f%rowtype) is
1117: --
1118: l_proc varchar2(80) := g_package||'set_bnb_object';
1119: --
1120: -- FONM

Line 1125: from ben_bnfts_bal_f bnb

1121: l_effective_date date ;
1122: --
1123: cursor c1 is
1124: select bnb.*
1125: from ben_bnfts_bal_f bnb
1126: where bnb.bnfts_bal_id = p_bnfts_bal_id
1127: and bnb.business_group_id = p_business_group_id
1128: and l_effective_date
1129: between bnb.effective_start_date

Line 1132: --l_rec ben_bnfts_bal_f%rowtype;

1128: and l_effective_date
1129: between bnb.effective_start_date
1130: and bnb.effective_end_date;
1131: --
1132: --l_rec ben_bnfts_bal_f%rowtype;
1133: --115.23 - comment out unneeded record
1134: --
1135: begin
1136: --

Line 2284: p_rec in out nocopy ben_bnfts_bal_f%rowtype) is

2280: --
2281: end get_object;
2282: --
2283: procedure get_object(p_bnfts_bal_id in number,
2284: p_rec in out nocopy ben_bnfts_bal_f%rowtype) is
2285: --
2286: l_proc varchar2(80) := g_package||'get_object bnb';
2287: l_index pls_integer;
2288: --l_not_hash_found boolean;

Line 2290: --l_rec ben_bnfts_bal_f%rowtype;

2286: l_proc varchar2(80) := g_package||'get_object bnb';
2287: l_index pls_integer;
2288: --l_not_hash_found boolean;
2289: l_env ben_env_object.g_global_env_rec_type;
2290: --l_rec ben_bnfts_bal_f%rowtype;
2291: -- FONM
2292: l_effective_date date;
2293: --
2294: --

Line 3808: l_cache_last_bnb_rec ben_bnfts_bal_f%rowtype;

3804: l_cache_last_pil_rec ben_per_in_ler%rowtype;
3805: l_cache_last_date_rec g_person_date_info_rec;
3806: l_cache_last_fte_rec g_person_fte_info_rec;
3807: l_cache_last_bal_rec ben_per_bnfts_bal_f%rowtype;
3808: l_cache_last_bnb_rec ben_bnfts_bal_f%rowtype;
3809: l_cache_last_hsc_rec hr_soft_coding_keyflex%rowtype;
3810: --
3811: begin
3812: --

Line 3871: l_cache_last_bnb_rec ben_bnfts_bal_f%rowtype;

3867: l_cache_last_pil_rec ben_per_in_ler%rowtype;
3868: l_cache_last_date_rec g_person_date_info_rec;
3869: l_cache_last_fte_rec g_person_fte_info_rec;
3870: l_cache_last_bal_rec ben_per_bnfts_bal_f%rowtype;
3871: l_cache_last_bnb_rec ben_bnfts_bal_f%rowtype;
3872: l_cache_last_hsc_rec hr_soft_coding_keyflex%rowtype;
3873: --
3874: begin
3875: --