DBA Data[Home] [Help]

APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PER_ADDRESSES

Line 582: ,per_addresses_v pav

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
586: and pap.position_id=paaf.position_id

Line 619: Type tab_address is table of per_addresses.ADDRESS_LINE1%type index by binary_integer;

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;
620: pl_address tab_address;
621: pl_address_final tab_address;
622: k NUMBER(3) := 0;
623: --