APPS.JA_CN_ITEMIZATION_INTERFACE dependencies on PER_ALL_PEOPLE_F

Line 312: from PER_ALL_PEOPLE_F

308: -------------------------------------------------------
309: if l_error_flag<>'Y' and l_PERSONNEL_ID is not null then
310: select count(*)
311: into l_count
312: from PER_ALL_PEOPLE_F
313: where PERSON_ID = l_PERSONNEL_ID
314: and effective_start_date<=l_effective_date
315: and effective_end_date>=l_effective_date;
316: if l_count=0 then

Line 428: from Per_All_People_f

424: if l_error_flag<>'Y' and l_JOURNAL_CREATOR is not null then
425: begin
426: select Last_Name || First_Name Full_Name
427: into l_creator
428: from Per_All_People_f
429: where person_id = l_JOURNAL_CREATOR
430: AND EFFECTIVE_START_DATE<=L_EFFECTIVE_DATE
431: AND EFFECTIVE_END_DATE>=L_EFFECTIVE_DATE;
432: /*

Line 449: from Per_All_People_f

445: if l_error_flag<>'Y' and l_JOURNAL_APPROVER is not null then
446: begin
447: select Last_Name || First_Name Full_Name
448: into l_approver
449: from Per_All_People_f
450: where person_id =l_JOURNAL_APPROVER
451: AND EFFECTIVE_START_DATE<=L_EFFECTIVE_DATE
452: AND EFFECTIVE_END_DATE>=L_EFFECTIVE_DATE;
453: /*

Line 470: from Per_All_People_f

466: if l_error_flag<>'Y' and l_JOURNAL_POSTER is not null then
467: begin
468: select Last_Name || First_Name Full_Name
469: into l_poster
470: from Per_All_People_f
471: where person_id = l_JOURNAL_POSTER
472: AND EFFECTIVE_START_DATE<=L_EFFECTIVE_DATE
473: AND EFFECTIVE_END_DATE>=L_EFFECTIVE_DATE;
474: /*

Line 2321: from Per_All_People_f

2317: fetch c_PERSONNEL into l_PERSONNEL_id,L_EFFECTIVE_DATE;
2318: exit when c_PERSONNEL%notfound;
2319: select employee_number--, Last_Name || First_Name Full_Name
2320: into l_PERSONNEL_NUMBER
2321: from Per_All_People_f
2322: where person_id = l_PERSONNEL_id
2323: AND EFFECTIVE_START_DATE<=L_EFFECTIVE_DATE
2324: AND EFFECTIVE_END_DATE>=L_EFFECTIVE_DATE;
2325: update ja_cn_journal_lines

Line 2338: from Per_All_People_f

2334: fetch c_creator into l_creator_id, L_EFFECTIVE_DATE;
2335: exit when c_creator%notfound;
2336: select Last_Name || First_Name Full_Name
2337: into l_creator
2338: from Per_All_People_f
2339: where person_id = to_number(l_creator_id)
2340: AND EFFECTIVE_START_DATE<=L_EFFECTIVE_DATE
2341: AND EFFECTIVE_END_DATE>=L_EFFECTIVE_DATE;
2342:

Line 2356: from Per_All_People_f

2352: fetch c_approver into l_approver_id,L_EFFECTIVE_DATE;
2353: exit when c_approver%notfound;
2354: select Last_Name || First_Name Full_Name
2355: into l_approver
2356: from Per_All_People_f
2357: where person_id = to_number(l_approver_id )
2358: AND EFFECTIVE_START_DATE<=L_EFFECTIVE_DATE
2359: AND EFFECTIVE_END_DATE>=L_EFFECTIVE_DATE;
2360:

Line 2373: from Per_All_People_f

2369: fetch c_poster into l_poster_id, L_EFFECTIVE_DATE;
2370: exit when c_poster%notfound;
2371: select Last_Name || First_Name Full_Name
2372: into l_poster
2373: from Per_All_People_f
2374: where person_id = to_number(l_poster_id)
2375: AND EFFECTIVE_START_DATE<=L_EFFECTIVE_DATE
2376: AND EFFECTIVE_END_DATE>=L_EFFECTIVE_DATE;
2377: