DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on PER_ALL_PEOPLE_F

Line 5867: l_rec per_all_people_f%rowtype;

5863: l_inst_count number;
5864: l_insttorrw_num binary_integer;
5865: l_ok boolean := false;
5866: l_rows_found boolean := false;
5867: l_rec per_all_people_f%rowtype;
5868: --
5869: begin
5870: --
5871: hr_utility.set_location('Entering: '||l_proc, 10);

Line 6058: l_rec per_all_people_f%rowtype;

6054: l_inst_count number;
6055: l_insttorrw_num binary_integer;
6056: l_ok boolean := false;
6057: l_rows_found boolean := false;
6058: l_rec per_all_people_f%rowtype;
6059: --
6060: begin
6061: --
6062: hr_utility.set_location('Entering: '||l_proc, 10);

Line 7334: l_rec per_all_people_f%rowtype;

7330: l_inst_count number;
7331: l_insttorrw_num binary_integer;
7332: l_ok boolean := false;
7333: l_rows_found boolean := false;
7334: l_rec per_all_people_f%rowtype;
7335: --
7336: cursor c1(p_person_id in number
7337: ,p_lf_evt_ocrd_dt in date
7338: ,p_pgm_id in number

Line 8903: l_per_rec per_all_people_f%rowtype;

8899: l_elig_rl_cnt number := 0;
8900: l_ctr_count number := 0;
8901: l_jurisdiction_code varchar2(30);
8902: --
8903: l_per_rec per_all_people_f%rowtype;
8904: l_ass_rec per_all_assignments_f%rowtype;
8905: l_ass_rec1 per_all_assignments_f%rowtype; -- Bug 6399423
8906: l_hsc_rec hr_soft_coding_keyflex%rowtype;
8907: l_org_rec hr_all_organization_units%rowtype;

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

9088: l_benmngle_parm_rec benutils.g_batch_param_rec;
9089: -- Procedure to assign overridden values
9090: --
9091: procedure assign_overriden_values
9092: (p_per_rec in out nocopy per_all_people_f%rowtype,
9093: p_asg_rec in out nocopy per_all_assignments_f%rowtype)
9094: is
9095:
9096: cursor check_gen_criteria(p_short_code varchar2) is