DBA Data[Home] [Help]

APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PER_ALL_POSITIONS

Line 509: ,per_all_positions pap

505: ,papf.email_address declarant_email
506: ,pap.NAME declarant_position
507: from per_all_people_f papf
508: ,per_all_assignments_f paaf
509: ,per_all_positions pap
510: ,per_addresses_v pav
511: where papf.person_id=c_person_id ;
512: and paaf.person_id=papf.person_id
513: and pav.person_id=papf.person_id

Line 543: l_declarant_position per_all_positions.name%type;

539: l_person_id hr_organization_information.org_information13%type;
540: l_declarant_name per_all_people_f.full_name%type;
541: l_declarant_phone per_all_people_f.office_number%type ;
542: l_declarant_email_add per_all_people_f.email_address%type;
543: l_declarant_position per_all_positions.name%type;
544:
545:
546: BEGIN
547: