APPS.PQH_RBC_STAGE dependencies on BEN_ELIGY_CRITERIA

Line 20: p_crit_rec out nocopy ben_eligy_criteria%rowtype) is

16: raise;
17: end;
18: procedure get_criteria(p_criteria_short_code in varchar2,
19: p_business_group_id in number,
20: p_crit_rec out nocopy ben_eligy_criteria%rowtype) is
21: begin
22: select *
23: into p_crit_rec
24: from ben_eligy_criteria

Line 24: from ben_eligy_criteria

20: p_crit_rec out nocopy ben_eligy_criteria%rowtype) is
21: begin
22: select *
23: into p_crit_rec
24: from ben_eligy_criteria
25: where short_code =p_criteria_short_code
26: and business_group_id = p_business_group_id;
27: exception
28: when no_data_found then

Line 33: from ben_eligy_criteria

29: hr_utility.set_location('no bg specific row exists for short_code'||p_criteria_short_code,25);
30: begin
31: select *
32: into p_crit_rec
33: from ben_eligy_criteria
34: where short_code =p_criteria_short_code
35: and business_group_id is null;
36: exception
37: when no_data_found then

Line 95: l_crit ben_eligy_criteria%rowtype;

91: raise;
92: end;
93: function get_crit_type(p_criteria_short_code in varchar2,
94: p_business_group_id in number) return varchar2 is
95: l_crit ben_eligy_criteria%rowtype;
96: begin
97: get_criteria(p_criteria_short_code => p_criteria_short_code,
98: p_business_group_id => p_business_group_id,
99: p_crit_rec => l_crit);

Line 213: l_crt_rec ben_eligy_criteria%rowtype;

209: p_business_group_id in number,
210: p_node_short_code in varchar2 default null,
211: p_effective_date in date) return varchar2 is
212: l_crit_short_code varchar2(80);
213: l_crt_rec ben_eligy_criteria%rowtype;
214: l_node1_desc varchar2(2000);
215: l_node2_desc varchar2(2000);
216: l_node_sum_desc varchar2(2000);
217: l_node_name varchar2(2000);

Line 1653: l_crit ben_eligy_criteria%rowtype;

1649:
1650: l_crt_tr_id number;
1651: l_crit_type varchar2(30);
1652: l_crt_tr_name varchar2(80);
1653: l_crit ben_eligy_criteria%rowtype;
1654: l_crt_cer_id number;
1655: l_crt_cer_ovn number;
1656: l_status_flag number := 0;
1657: l_parent_id number;