DBA Data[Home] [Help]

APPS.PAY_IE_NES_REPORT_PKG dependencies on PER_ADDRESSES

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

645: l_declarant_phone per_all_people_f.office_number%type ;
646: l_declarant_email_add per_all_people_f.email_address%type;
647: l_declarant_position per_all_positions.name%type;
648:
649: Type tab_address is table of per_addresses.ADDRESS_LINE1%type index by binary_integer;
650: pl_address tab_address;
651: pl_address_final tab_address;
652: k NUMBER(3) := 0;
653:

Line 1314: from per_addresses pa,

1310: null address_line5,
1311: pa.town_or_city city ,
1312: flv.meaning County,
1313: pa.country Country
1314: from per_addresses pa,
1315: per_all_people_f papf,
1316: fnd_lookup_values flv
1317: where papf.person_id = cp_person_id
1318: and papf.person_id=pa.person_id(+)

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

1440: l_org_id hr_organization_units.organization_id%type;
1441: l_normal_hours per_all_assignments_f.normal_hours%type;
1442: l_frequency per_all_assignments_f.frequency%type;
1443:
1444: Type tab_address is table of per_addresses.ADDRESS_LINE1%type index by binary_integer;
1445: pl_address tab_address;
1446: pl_address_final tab_address;
1447: k NUMBER(3) := 0;
1448: