DBA Data[Home] [Help]

APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PER_ALL_POSITIONS

Line 581: ,per_all_positions pap

577: ,papf.email_address declarant_email
578: ,pap.NAME declarant_position
579: from per_all_people_f papf
580: ,per_all_assignments_f paaf
581: ,per_all_positions pap
582: ,per_addresses_v pav
583: where papf.person_id=c_person_id ;
584: and paaf.person_id=papf.person_id
585: and pav.person_id=papf.person_id

Line 615: l_declarant_position per_all_positions.name%type;

611: l_person_id hr_organization_information.org_information13%type;
612: l_declarant_name per_all_people_f.full_name%type;
613: l_declarant_phone per_all_people_f.office_number%type ;
614: l_declarant_email_add per_all_people_f.email_address%type;
615: l_declarant_position per_all_positions.name%type;
616:
617: /* 9719281 */
618: --
619: Type tab_address is table of per_addresses.ADDRESS_LINE1%type index by binary_integer;