APPS.OTA_ELIG_PROFILE_UTIL dependencies on PER_ASSIGNMENTS_F

Line 15: ,per_assignments_f paf

11: , paf.assignment_id
12: , paf.assignment_type
13: , paf.business_group_id
14: FROM per_people_f ppf
15: ,per_assignments_f paf
16: ,per_person_type_usages_f ptu
17: ,per_person_types pts
18: ,per_business_groups pbg
19: WHERE

Line 265: person_id per_assignments_f.person_id%type,

261: l_counter number:=0;
262: l_learner_group_element_id ota_user_group_elements.user_group_element_id%type;
263:
264: TYPE learner_rec IS RECORD(
265: person_id per_assignments_f.person_id%type,
266: assignment_id per_assignments_f.assignment_id%type,
267: assignment_type per_assignments_f.assignment_type%type,
268: business_group_id per_assignments_f.business_group_id%type
269: );

Line 266: assignment_id per_assignments_f.assignment_id%type,

262: l_learner_group_element_id ota_user_group_elements.user_group_element_id%type;
263:
264: TYPE learner_rec IS RECORD(
265: person_id per_assignments_f.person_id%type,
266: assignment_id per_assignments_f.assignment_id%type,
267: assignment_type per_assignments_f.assignment_type%type,
268: business_group_id per_assignments_f.business_group_id%type
269: );
270:

Line 267: assignment_type per_assignments_f.assignment_type%type,

263:
264: TYPE learner_rec IS RECORD(
265: person_id per_assignments_f.person_id%type,
266: assignment_id per_assignments_f.assignment_id%type,
267: assignment_type per_assignments_f.assignment_type%type,
268: business_group_id per_assignments_f.business_group_id%type
269: );
270:
271: lrnr_rec learner_rec;

Line 268: business_group_id per_assignments_f.business_group_id%type

264: TYPE learner_rec IS RECORD(
265: person_id per_assignments_f.person_id%type,
266: assignment_id per_assignments_f.assignment_id%type,
267: assignment_type per_assignments_f.assignment_type%type,
268: business_group_id per_assignments_f.business_group_id%type
269: );
270:
271: lrnr_rec learner_rec;
272:

Line 394: per_assignments_f

390: assignment_id,
391: assignment_type,
392: business_group_id
393: from
394: per_assignments_f
395: where
396: trunc(sysdate) between effective_start_date and effective_end_date
397: and((assignment_type in (''E'',''C'') and PRIMARY_FLAG = ''Y'') OR (assignment_type = ''A''))
398: and ((fnd_profile.value(''OTA_HR_GLOBAL_BUSINESS_GROUP_ID'') is not null and business_group_id = '||l_elig_pro_bg_id||') or (business_group_id = fnd_profile.value(''PER_BUSINESS_GROUP_ID''))))

Line 487: person_id per_assignments_f.person_id%type,

483: p_enable_logging in varchar2 default 'N') is
484:
485:
486: TYPE learner_rec IS RECORD(
487: person_id per_assignments_f.person_id%type,
488: assignment_id per_assignments_f.assignment_id%type,
489: assignment_type per_assignments_f.assignment_type%type,
490: business_group_id per_assignments_f.business_group_id%type
491: );

Line 488: assignment_id per_assignments_f.assignment_id%type,

484:
485:
486: TYPE learner_rec IS RECORD(
487: person_id per_assignments_f.person_id%type,
488: assignment_id per_assignments_f.assignment_id%type,
489: assignment_type per_assignments_f.assignment_type%type,
490: business_group_id per_assignments_f.business_group_id%type
491: );
492:

Line 489: assignment_type per_assignments_f.assignment_type%type,

485:
486: TYPE learner_rec IS RECORD(
487: person_id per_assignments_f.person_id%type,
488: assignment_id per_assignments_f.assignment_id%type,
489: assignment_type per_assignments_f.assignment_type%type,
490: business_group_id per_assignments_f.business_group_id%type
491: );
492:
493: lrnr_rec learner_rec;

Line 490: business_group_id per_assignments_f.business_group_id%type

486: TYPE learner_rec IS RECORD(
487: person_id per_assignments_f.person_id%type,
488: assignment_id per_assignments_f.assignment_id%type,
489: assignment_type per_assignments_f.assignment_type%type,
490: business_group_id per_assignments_f.business_group_id%type
491: );
492:
493: lrnr_rec learner_rec;
494:

Line 515: l_pre_person_id per_assignments_f.person_id%type := -1;

511: l_end_person_action_id number(15);
512: l_commit number;
513: l_num_row number := 0;
514: l_validate varchar2(1) := 'N';
515: l_pre_person_id per_assignments_f.person_id%type := -1;
516:
517: ug_whereclause varchar2(200);
518:
519: TYPE ug_rec IS RECORD(

Line 933: TYPE learner_rec IS RECORD (person_id per_assignments_f.person_id%TYPE

929: assignment_whereclause varchar2(100);
930: l_elig_obj_id number;
931: l_counter number DEFAULT 0;
932: l_learner_group_element_id ota_user_group_elements.user_group_element_id%TYPE;
933: TYPE learner_rec IS RECORD (person_id per_assignments_f.person_id%TYPE
934: ,assignment_id per_assignments_f.assignment_id%TYPE
935: ,business_group_id per_assignments_f.business_group_id%TYPE);
936: TYPE t_learner_rec IS TABLE OF learner_rec INDEX BY binary_integer;
937: lrnr_rec t_learner_rec;

Line 934: ,assignment_id per_assignments_f.assignment_id%TYPE

930: l_elig_obj_id number;
931: l_counter number DEFAULT 0;
932: l_learner_group_element_id ota_user_group_elements.user_group_element_id%TYPE;
933: TYPE learner_rec IS RECORD (person_id per_assignments_f.person_id%TYPE
934: ,assignment_id per_assignments_f.assignment_id%TYPE
935: ,business_group_id per_assignments_f.business_group_id%TYPE);
936: TYPE t_learner_rec IS TABLE OF learner_rec INDEX BY binary_integer;
937: lrnr_rec t_learner_rec;
938: TYPE ug_rec IS RECORD (user_group_id ota_user_group_elements.user_group_id%TYPE

Line 935: ,business_group_id per_assignments_f.business_group_id%TYPE);

931: l_counter number DEFAULT 0;
932: l_learner_group_element_id ota_user_group_elements.user_group_element_id%TYPE;
933: TYPE learner_rec IS RECORD (person_id per_assignments_f.person_id%TYPE
934: ,assignment_id per_assignments_f.assignment_id%TYPE
935: ,business_group_id per_assignments_f.business_group_id%TYPE);
936: TYPE t_learner_rec IS TABLE OF learner_rec INDEX BY binary_integer;
937: lrnr_rec t_learner_rec;
938: TYPE ug_rec IS RECORD (user_group_id ota_user_group_elements.user_group_id%TYPE
939: ,elig_prfl_id ota_user_group_elements.elig_prfl_id%TYPE