eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_PERASGADD_RIW dependencies on PER_ADDRESSES

Line 17: g_add_rec per_addresses%rowtype;

13: g_business_group_id number(15);
14:
15: g_per_rec per_all_people_f%rowtype;
16: g_scl_rec hr_soft_coding_keyflex%rowtype;
17: g_add_rec per_addresses%rowtype;
18: g_grp_rec pay_people_groups%rowtype;
19: g_asg_rec per_all_assignments_f%rowtype;
20: g_phn_rec per_phones%rowtype;
21: g_cnt_rec per_contact_relationships%rowtype;

Line 456: from per_addresses

452: ,c_business_group_id in number
453: ,c_effective_date in date
454: ,c_primary_flag in varchar2) is
455: select *
456: from per_addresses
457: where person_id = c_person_id
458: and business_group_id = c_business_group_id
459: and primary_flag = c_primary_flag
460: and c_effective_date between date_from

Line 4023: from per_addresses pad

4019: ,c_business_group_id in number
4020: ,c_date_from in date
4021: ,c_primary_flag in varchar2) is
4022: select *
4023: from per_addresses pad
4024: where pad.person_id = c_person_id
4025: and pad.business_group_id = c_business_group_id
4026: and pad.primary_flag = c_primary_flag
4027: and c_date_from between pad.date_from

Line 4038: from per_addresses pad

4034: ,c_address_type in varchar2
4035: ,c_date_from in date
4036: ,c_effective_date in date) is
4037: select *
4038: from per_addresses pad
4039: where pad.business_group_id = c_business_group_id
4040: and pad.person_id = c_person_id
4041: and pad.primary_flag = c_primary_flag
4042: and pad.STYLE = c_style

Line 4048: l_cur_add_rec per_addresses%rowtype;

4044: and trunc(pad.date_from) = trunc(c_date_from);
4045: /* and c_effective_date between pad.date_from
4046: and NVL(pad.date_to, c_effective_date); */
4047:
4048: l_cur_add_rec per_addresses%rowtype;
4049: l_proc_name constant varchar2(150):= g_pkg ||'InsUpd_Batch_Address';
4050: l_pradd_ovlapval_override boolean;
4051: l_error_msg varchar2(2000);
4052:

Line 4444: from per_addresses pad

4440: ,c_business_group_id in number
4441: ,c_date_from in date
4442: ,c_primary_flag in varchar2) is
4443: select *
4444: from per_addresses pad
4445: where pad.person_id = c_person_id
4446: and pad.business_group_id = c_business_group_id
4447: and pad.primary_flag = c_primary_flag
4448: and c_date_from between pad.date_from

Line 4459: from per_addresses pad

4455: ,c_address_type in varchar2
4456: ,c_date_from in date
4457: ,c_effective_date in date) is
4458: select *
4459: from per_addresses pad
4460: where pad.business_group_id = c_business_group_id
4461: and pad.person_id = c_person_id
4462: and pad.primary_flag = c_primary_flag
4463: and pad.STYLE = c_style

Line 4469: l_cur_add_rec per_addresses%rowtype;

4465: and trunc(pad.date_from) = trunc(c_date_from);
4466: /* and c_effective_date between pad.date_from
4467: and NVL(pad.date_to, c_effective_date); */
4468:
4469: l_cur_add_rec per_addresses%rowtype;
4470: l_proc_name constant varchar2(150):= g_pkg ||'InsUpd_Address';
4471: l_error_msg varchar2(2000);
4472: l_party_id per_people_f.party_id%type;
4473: