APPS.OTA_COMPETENCE_SS dependencies on PER_ALL_PEOPLE_F

Line 276: l_business_group_id per_all_people_f.business_group_id%type;

272: l_result varchar2(100) default null;
273: l_old_transaction_step_id number;
274: l_old_object_version_number number;
275: l_activity_id number :=0;
276: l_business_group_id per_all_people_f.business_group_id%type;
277:
278: cursor get_person_business_grp is ----Bug#6869342
279: select business_group_id from per_all_people_f
280: where person_id= p_person_id

Line 279: select business_group_id from per_all_people_f

275: l_activity_id number :=0;
276: l_business_group_id per_all_people_f.business_group_id%type;
277:
278: cursor get_person_business_grp is ----Bug#6869342
279: select business_group_id from per_all_people_f
280: where person_id= p_person_id
281: and trunc(sysdate) between trunc(effective_start_date) and trunc(nvl(effective_end_date,sysdate+1));
282:
283: begin

Line 953: l_business_group_id per_all_people_f.business_group_id%type;

949: l_competence_created number(10);
950:
951: l_level_value_to_use number(10);
952:
953: l_business_group_id per_all_people_f.business_group_id%type;
954:
955: l_old_level_id number(15);
956: l_attr_chk boolean := TRUE;
957: l_fwd_to_username varchar2(1000);

Line 1429: l_creator_person_id per_all_people_f.person_id%type;

1425:
1426: l_creator_username varchar2(80):= fnd_profile.value('USERNAME');
1427: l_creator_user_Id number := fnd_profile.value('USER_ID');
1428:
1429: l_creator_person_id per_all_people_f.person_id%type;
1430: l_ntf_url varchar2(4000);
1431: l_comp_ids varchar2(4000);
1432: l_level_ids varchar2(4000);
1433: l_eff_date_from varchar2(4000);

Line 1437: l_person_full_name per_all_people_f.full_name%TYPE;

1433: l_eff_date_from varchar2(4000);
1434: l_eff_date_to varchar2(4000);
1435:
1436: --l_person_details ota_learner_enroll_ss.csr_person_to_enroll_details%ROWTYPE;
1437: l_person_full_name per_all_people_f.full_name%TYPE;
1438: l_role_name wf_roles.name%type;
1439: l_role_display_name wf_roles.display_name%type;
1440:
1441: l_assignment varchar2(100);

Line 1443: l_supervisor_id per_all_people_f.person_id%Type;

1439: l_role_display_name wf_roles.display_name%type;
1440:
1441: l_assignment varchar2(100);
1442:
1443: l_supervisor_id per_all_people_f.person_id%Type;
1444: l_supervisor_username fnd_user.user_name%TYPE;
1445: l_supervisor_full_name per_all_people_f.full_name%TYPE;
1446:
1447: l_event_name ota_events.title%type;

Line 1445: l_supervisor_full_name per_all_people_f.full_name%TYPE;

1441: l_assignment varchar2(100);
1442:
1443: l_supervisor_id per_all_people_f.person_id%Type;
1444: l_supervisor_username fnd_user.user_name%TYPE;
1445: l_supervisor_full_name per_all_people_f.full_name%TYPE;
1446:
1447: l_event_name ota_events.title%type;
1448:
1449: l_course_name ota_activity_versions.version_name%type;

Line 1502: FROM per_all_people_f ppf

1498: order by paf.effective_end_date;
1499:
1500: Cursor get_person_full_name is
1501: Select ppf.full_name
1502: FROM per_all_people_f ppf
1503: where ppf.person_id = p_person_id
1504: AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date
1505: AND ppf.effective_end_date;
1506:

Line 1511: per_all_people_f per

1507:
1508: CURSOR csr_supervisor_id IS
1509: SELECT asg.supervisor_id, per.full_name
1510: FROM per_all_assignments_f asg,
1511: per_all_people_f per
1512: WHERE asg.person_id = p_person_id
1513: AND per.person_id = asg.supervisor_id
1514: AND asg.primary_flag = 'Y'
1515: AND trunc(sysdate)

Line 1543: per_all_people_f

1539:
1540: cursor chk_person_business_grp
1541: is
1542: Select 1 from
1543: per_all_people_f
1544: where person_id= p_person_id
1545: and (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null or --Bug#6869342
1546: business_group_id = ota_general.get_business_group_id);
1547:

Line 1565: l_business_group_id per_all_people_f.business_group_id%type;

1561: instr(web_html_call, '&', instr(web_html_call, param), 1))-instr(web_html_call, param))), '=')+1)) "paramvalue"
1562: FROM fnd_form_functions
1563: WHERE function_name = 'OTA_LEARNER_HOME_SS';
1564:
1565: l_business_group_id per_all_people_f.business_group_id%type;
1566: l_ntfFyiParamVal varchar2(5) := 'N';
1567:
1568:
1569: BEGIN