APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on PER_ALL_ASSIGNMENTS_F

Line 4136: from per_all_assignments_f asg

4132: --
4133: cursor c_normal_hours(p_frequency varchar2,
4134: p_use_all_asnts_elig_flag varchar2) is
4135: select sum(normal_hours)
4136: from per_all_assignments_f asg
4137: where asg.person_id = p_person_id
4138: and asg.business_group_id = p_business_group_id
4139: and (
4140: (nvl(p_use_all_asnts_elig_flag,'N') = 'N' and asg.assignment_id = p_assignment_id)

Line 4811: l_ass_rec per_all_assignments_f%rowtype;

4807: l_ok1 boolean := false;
4808: l_ok2 boolean := false;
4809: l_rows_found boolean := false;
4810: l_dummy varchar2(1);
4811: l_ass_rec per_all_assignments_f%rowtype;
4812: l_aei_rec per_assignment_extra_info%rowtype;
4813: l_crit_passed boolean;
4814: l_score_tab scoreTab;
4815: --

Line 5539: l_ass_rec per_all_assignments_f%rowtype;

5535: l_inst_count number;
5536: l_insttorrw_num binary_integer;
5537: l_ok boolean := false;
5538: l_rows_found boolean := false;
5539: l_ass_rec per_all_assignments_f%rowtype;
5540: l_outputs ff_exec.outputs_t;
5541: l_include_flag varchar2(80);
5542: l_crit_passed boolean;
5543: l_score_tab scoreTab;

Line 8336: per_all_assignments_f asg

8332: IS
8333: SELECT ppr.performance_rating
8334: FROM per_performance_reviews ppr,
8335: per_events pev,
8336: per_all_assignments_f asg
8337: WHERE pev.assignment_id = asg.assignment_id
8338: AND pev.TYPE = p_event_type
8339: AND pev.business_group_id = p_business_group_id
8340: AND p_effective_date BETWEEN NVL (pev.date_start,

Line 8889: l_assignment_id per_all_assignments_f.assignment_id%type;

8885: l_dpnt_pl_id ben_pl_f.pl_id%type;
8886: l_exists varchar2(30);
8887: --
8888: l_terminated per_assignment_status_types.per_system_status%type ;
8889: l_assignment_id per_all_assignments_f.assignment_id%type;
8890: l_found_profile varchar2(1) := 'N';
8891: l_pl_rec ben_pl_f%rowtype;
8892: l_pl3_rec ben_pl_f%rowtype;
8893: l_ptip2_rec ben_ptip_f%rowtype;

Line 8904: l_ass_rec per_all_assignments_f%rowtype;

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

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

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

Line 8910: l_empasg_row per_all_assignments_f%rowtype;

8906: l_hsc_rec hr_soft_coding_keyflex%rowtype;
8907: l_org_rec hr_all_organization_units%rowtype;
8908: l_loop_count number;
8909: --
8910: l_empasg_row per_all_assignments_f%rowtype;
8911: l_benasg_row per_all_assignments_f%rowtype;
8912: l_pil_row ben_per_in_ler%rowtype;
8913: --
8914: l_cagrelig_cnt pls_integer;

Line 8911: l_benasg_row per_all_assignments_f%rowtype;

8907: l_org_rec hr_all_organization_units%rowtype;
8908: l_loop_count number;
8909: --
8910: l_empasg_row per_all_assignments_f%rowtype;
8911: l_benasg_row per_all_assignments_f%rowtype;
8912: l_pil_row ben_per_in_ler%rowtype;
8913: --
8914: l_cagrelig_cnt pls_integer;
8915: l_pl_typ_id number;

Line 9093: p_asg_rec in out nocopy per_all_assignments_f%rowtype)

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