APPS.PAY_PAYSGI21_XMLP_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 159: from per_people_extra_info

155: v_ir21_date date;
156: begin
157: select max(to_date(pei_information1,'yyyy/mm/dd hh24:mi:ss'))
158: into v_ir21_date
159: from per_people_extra_info
160: --where person_id = p_person_id
161: where person_id = lp_person_id
162: and information_type = 'HR_IR21_PROCESSING_DATES_SG';
163:

Line 288: from per_people_extra_info ppeo,

284: to_date('31/12/'||to_char(yrtbl.yr),'dd/mm/yyyy')) to_date,
285: ppeo.pei_information3 no_days,
286: ppeo.pei_information4 no_employees,
287: yrtbl.yr yr
288: from per_people_extra_info ppeo,
289: (select (lp_basis_year) yr from dual union
290: select (lp_basis_year - 1) yr from dual union
291: select (lp_basis_year - 2) yr from dual) yrtbl
292: where ppeo.person_id = person_id

Line 296: from per_people_extra_info ppeo2

292: where ppeo.person_id = person_id
293: and ppeo.information_type = 'HR_IR21A_CESSATION_INFO_SG'
294: and fnd_date.canonical_to_date(ppeo.pei_information1) =
295: (select max(fnd_date.canonical_to_date(ppeo2.pei_information1))
296: from per_people_extra_info ppeo2
297: where ppeo.person_id = ppeo2.person_id
298: and ppeo2.information_type = 'HR_IR21A_CESSATION_INFO_SG'
299: and fnd_date.canonical_to_date(ppeo2.pei_information1) <=
300: to_date('31-12-'||to_char(yrtbl.yr),'dd-mm-yyyy')

Line 341: from per_people_extra_info ppeo

337: v_ir21_date_exists boolean := FALSE;
338:
339: cursor c_ir21_dates is
340: select fnd_date.canonical_to_date(pei_information1) ir21_date
341: from per_people_extra_info ppeo
342: --where ppeo.person_id = lp_person_id
343: where ppeo.person_id = lp_person_id
344: and information_type = 'HR_IR21_PROCESSING_DATES_SG'
345: and fnd_date.canonical_to_date(pei_information1) = trunc(sysdate);

Line 355: insert into per_people_extra_info (

351: exit;
352: end loop;
353:
354: if v_ir21_date_exists = FALSE then
355: insert into per_people_extra_info (
356: person_extra_info_id,
357: person_id,
358: information_type,
359: pei_information_category,

Line 366: per_people_extra_info_s.nextval,

362: last_update_date,
363: creation_date
364: )
365: values (
366: per_people_extra_info_s.nextval,
367: --p_person_id,
368: lp_person_id,
369: 'HR_IR21_PROCESSING_DATES_SG',
370: 'HR_IR21_PROCESSING_DATES_SG',

Line 384: v_granted per_people_extra_info.pei_information4%type;

380: END set_ir21_date;
381:
382: function CF_stock_outstandingFormula (date_start in date,actual_termination_date in date,organization_id in varchar2)return Number is
383:
384: v_granted per_people_extra_info.pei_information4%type;
385: v_exercised per_people_extra_info.pei_information6%type;
386:
387: cursor c_granted is
388: select

Line 385: v_exercised per_people_extra_info.pei_information6%type;

381:
382: function CF_stock_outstandingFormula (date_start in date,actual_termination_date in date,organization_id in varchar2)return Number is
383:
384: v_granted per_people_extra_info.pei_information4%type;
385: v_exercised per_people_extra_info.pei_information6%type;
386:
387: cursor c_granted is
388: select
389: sum(pei2.pei_information4)

Line 390: from per_people_extra_info pei2

386:
387: cursor c_granted is
388: select
389: sum(pei2.pei_information4)
390: from per_people_extra_info pei2
391: --where pei2.person_id = lp_person_id
392: where pei2.person_id = lp_person_id
393: and pei2.information_type = 'HR_STOCK_GRANT_SG'
394: and to_date(pei2.pei_information3,'YYYY/MM/DD HH24:MI:SS')< to_date('01/01/2003','DD/MM/YYYY')

Line 399: from per_people_extra_info pei,

395: group by pei2.person_id;
396:
397: cursor c_exercised is
398: select sum(pei.pei_information6)
399: from per_people_extra_info pei,
400: per_people_extra_info pei2
401: --where pei.person_id = p_person_id
402: where pei.person_id = lp_person_id
403: and pei.person_id = pei2.person_id

Line 400: per_people_extra_info pei2

396:
397: cursor c_exercised is
398: select sum(pei.pei_information6)
399: from per_people_extra_info pei,
400: per_people_extra_info pei2
401: --where pei.person_id = p_person_id
402: where pei.person_id = lp_person_id
403: and pei.person_id = pei2.person_id
404: and pei.information_type = 'HR_STOCK_EXERCISE_SG'