APPS.PAY_JP_GENERIC_UPGRADE_PKG dependencies on PER_ALL_PEOPLE_F

Line 341: l_full_name per_all_people_f.full_name%type;

337: l_effective_date date;
338: --
339: l_party_id number;
340: -- l_bg_name per_business_groups_perf.name%type;
341: l_full_name per_all_people_f.full_name%type;
342: --
343: cursor csr_ee is
344: select employment_income,
345: si_prems,

Line 453: from per_all_people_f per,

449: per.full_name
450: into l_party_id,
451: -- l_bg_name,
452: l_full_name
453: from per_all_people_f per,
454: per_business_groups_perf bg
455: where per.person_id = l_person_id
456: and l_effective_date
457: between per.effective_start_date and per.effective_end_date