APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on PER_ALL_ASSIGNMENTS_F

Line 4147: from per_all_assignments_f asg

4143: --
4144: cursor c_normal_hours(p_frequency varchar2,
4145: p_use_all_asnts_elig_flag varchar2) is
4146: select sum(normal_hours)
4147: from per_all_assignments_f asg
4148: where asg.person_id = p_person_id
4149: and asg.business_group_id = p_business_group_id
4150: and (
4151: (nvl(p_use_all_asnts_elig_flag,'N') = 'N' and asg.assignment_id = p_assignment_id)

Line 4822: l_ass_rec per_all_assignments_f%rowtype;

4818: l_ok1 boolean := false;
4819: l_ok2 boolean := false;
4820: l_rows_found boolean := false;
4821: l_dummy varchar2(1);
4822: l_ass_rec per_all_assignments_f%rowtype;
4823: l_aei_rec per_assignment_extra_info%rowtype;
4824: l_crit_passed boolean;
4825: l_score_tab scoreTab;
4826: --

Line 5551: l_ass_rec per_all_assignments_f%rowtype;

5547: l_inst_count number;
5548: l_insttorrw_num binary_integer;
5549: l_ok boolean := false;
5550: l_rows_found boolean := false;
5551: l_ass_rec per_all_assignments_f%rowtype;
5552: l_outputs ff_exec.outputs_t;
5553: l_include_flag varchar2(80);
5554: l_crit_passed boolean;
5555: l_score_tab scoreTab;

Line 8354: per_all_assignments_f asg

8350: IS
8351: SELECT ppr.performance_rating
8352: FROM per_performance_reviews ppr,
8353: per_events pev,
8354: per_all_assignments_f asg
8355: WHERE pev.assignment_id = asg.assignment_id
8356: AND pev.TYPE = p_event_type
8357: AND pev.business_group_id = p_business_group_id
8358: AND p_effective_date BETWEEN NVL (pev.date_start,

Line 8908: l_assignment_id per_all_assignments_f.assignment_id%type;

8904: l_dpnt_pl_id ben_pl_f.pl_id%type;
8905: l_exists varchar2(30);
8906: --
8907: l_terminated per_assignment_status_types.per_system_status%type ;
8908: l_assignment_id per_all_assignments_f.assignment_id%type;
8909: l_found_profile varchar2(1) := 'N';
8910: l_pl_rec ben_pl_f%rowtype;
8911: l_pl3_rec ben_pl_f%rowtype;
8912: l_ptip2_rec ben_ptip_f%rowtype;

Line 8923: l_ass_rec per_all_assignments_f%rowtype;

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;
8927: l_loop_count number;

Line 8924: l_ass_rec1 per_all_assignments_f%rowtype; -- Bug 6399423

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;
8927: l_loop_count number;
8928: --

Line 8929: l_empasg_row per_all_assignments_f%rowtype;

8925: l_hsc_rec hr_soft_coding_keyflex%rowtype;
8926: l_org_rec hr_all_organization_units%rowtype;
8927: l_loop_count number;
8928: --
8929: l_empasg_row per_all_assignments_f%rowtype;
8930: l_benasg_row per_all_assignments_f%rowtype;
8931: l_pil_row ben_per_in_ler%rowtype;
8932: --
8933: l_cagrelig_cnt pls_integer;

Line 8930: l_benasg_row per_all_assignments_f%rowtype;

8926: l_org_rec hr_all_organization_units%rowtype;
8927: l_loop_count number;
8928: --
8929: l_empasg_row per_all_assignments_f%rowtype;
8930: l_benasg_row per_all_assignments_f%rowtype;
8931: l_pil_row ben_per_in_ler%rowtype;
8932: --
8933: l_cagrelig_cnt pls_integer;
8934: l_pl_typ_id number;

Line 9112: p_asg_rec in out nocopy per_all_assignments_f%rowtype)

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
9116: select 'x'