APPS.PAY_KR_YEA_PDF_PKG dependencies on PER_ALL_PEOPLE_F

Line 3766: per_all_people_f pp_con

3762: is
3763: select pcr.contact_relationship_id
3764: from per_all_assignments_f pa,
3765: per_contact_relationships pcr,
3766: per_all_people_f pp_con
3767: where pa.assignment_id = p_assignment_id
3768: and p_effective_date
3769: between pa.effective_start_date and pa.effective_end_date
3770: and pcr.person_id = pa.person_id

Line 4042: l_ni_num per_all_people_f.national_identifier%type;

4038: l_proc varchar2(80) := c_package||'main_xml';
4039: --
4040: l_status varchar2(1);
4041: --
4042: l_ni_num per_all_people_f.national_identifier%type;
4043: --
4044: xml xmltype;
4045: xml_doc dbms_xmldom.domdocument;
4046: --