DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on PER_ALL_PEOPLE_F

Line 5879: l_rec per_all_people_f%rowtype;

5875: l_inst_count number;
5876: l_insttorrw_num binary_integer;
5877: l_ok boolean := false;
5878: l_rows_found boolean := false;
5879: l_rec per_all_people_f%rowtype;
5880: --
5881: begin
5882: --
5883: hr_utility.set_location('Entering: '||l_proc, 10);

Line 6070: l_rec per_all_people_f%rowtype;

6066: l_inst_count number;
6067: l_insttorrw_num binary_integer;
6068: l_ok boolean := false;
6069: l_rows_found boolean := false;
6070: l_rec per_all_people_f%rowtype;
6071: --
6072: begin
6073: --
6074: hr_utility.set_location('Entering: '||l_proc, 10);

Line 7348: l_rec per_all_people_f%rowtype;

7344: l_inst_count number;
7345: l_insttorrw_num binary_integer;
7346: l_ok boolean := false;
7347: l_rows_found boolean := false;
7348: l_rec per_all_people_f%rowtype;
7349: --
7350: cursor c1(p_person_id in number
7351: ,p_lf_evt_ocrd_dt in date
7352: ,p_pgm_id in number

Line 8922: l_per_rec per_all_people_f%rowtype;

8918: l_elig_rl_cnt number := 0;
8919: l_ctr_count number := 0;
8920: l_jurisdiction_code varchar2(30);
8921: --
8922: l_per_rec per_all_people_f%rowtype;
8923: l_ass_rec per_all_assignments_f%rowtype;
8924: l_ass_rec1 per_all_assignments_f%rowtype; -- Bug 6399423
8925: l_hsc_rec hr_soft_coding_keyflex%rowtype;
8926: l_org_rec hr_all_organization_units%rowtype;

Line 9111: (p_per_rec in out nocopy per_all_people_f%rowtype,

9107: l_benmngle_parm_rec benutils.g_batch_param_rec;
9108: -- Procedure to assign overridden values
9109: --
9110: procedure assign_overriden_values
9111: (p_per_rec in out nocopy per_all_people_f%rowtype,
9112: p_asg_rec in out nocopy per_all_assignments_f%rowtype)
9113: is
9114:
9115: cursor check_gen_criteria(p_short_code varchar2) is