DBA Data[Home] [Help]

APPS.PQP_PERASGADD_RIW dependencies on PER_PEOPLE_F

Line 4807: l_party_id per_people_f.party_id%type;

4803:
4804: l_cur_add_rec per_addresses%rowtype;
4805: l_proc_name constant varchar2(150):= g_pkg ||'InsUpd_Address';
4806: l_error_msg varchar2(2000);
4807: l_party_id per_people_f.party_id%type;
4808:
4809:
4810: begin
4811: hr_utility.set_location('Entering: ' || l_proc_name, 10);

Line 10372: l_national_identifier per_people_f.national_identifier%type;

10368: --
10369: -- Type declarations
10370: --
10371: l_chk_per chk_party%rowtype;
10372: l_national_identifier per_people_f.national_identifier%type;
10373: l_party_id per_people_f.party_id%type;
10374: l_dff_ctx fnd_descr_flex_contexts.descriptive_flex_context_code%type;
10375:
10376: -- added by dbansal

Line 10373: l_party_id per_people_f.party_id%type;

10369: -- Type declarations
10370: --
10371: l_chk_per chk_party%rowtype;
10372: l_national_identifier per_people_f.national_identifier%type;
10373: l_party_id per_people_f.party_id%type;
10374: l_dff_ctx fnd_descr_flex_contexts.descriptive_flex_context_code%type;
10375:
10376: -- added by dbansal
10377: l_gre_name HR_ALL_ORGANIZATION_UNITS_TL.name%type;