APPS.PQP_HROSS_INTEGRATION dependencies on PER_ADDRESSES

Line 13: l_add_rec per_addresses%ROWTYPE;

9: g_emp_num_gen Varchar2(5);
10: g_debug_on Boolean;
11: l_per_rec per_all_people_f%ROWTYPE;
12: l_asg_rec per_all_assignments_f%ROWTYPE;
13: l_add_rec per_addresses%ROWTYPE;
14: l_cntct_rec per_contact_relationships%ROWTYPE;
15: l_phones_rec per_phones%ROWTYPE;
16: l_hr_soft_rec hr_soft_coding_keyflex%ROWTYPE;
17: l_ppl_grp_rec pay_people_groups%ROWTYPE;

Line 386: FROM per_addresses

382: ,c_business_group_id IN Number
383: ,c_effective_date IN Date
384: ,c_primary_flag IN Varchar2) IS
385: SELECT *
386: FROM per_addresses
387: WHERE person_id = c_person_id
388: AND business_group_id = c_business_group_id
389: AND primary_flag = c_primary_flag
390: AND c_effective_date BETWEEN date_from

Line 986: FROM per_addresses pad

982: ,c_business_group_id IN Number
983: ,c_effective_date IN Date
984: ,c_primary_flag IN Varchar2) IS
985: SELECT *
986: FROM per_addresses pad
987: WHERE pad.person_id = c_person_id
988: AND pad.business_group_id = c_business_group_id
989: AND pad.primary_flag = c_primary_flag
990: AND c_effective_date BETWEEN pad.date_from

Line 992: l_cur_add_rec per_addresses%ROWTYPE;

988: AND pad.business_group_id = c_business_group_id
989: AND pad.primary_flag = c_primary_flag
990: AND c_effective_date BETWEEN pad.date_from
991: AND NVL(pad.date_to, c_effective_date);
992: l_cur_add_rec per_addresses%ROWTYPE;
993: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'InsUpd_Address';
994: l_error_msg Varchar2(2000);
995:
996: BEGIN

Line 2737: l_cur_add_rec per_addresses%ROWTYPE;

2733: l_upd_chg_ins Boolean;
2734:
2735: l_cont_object_version_num
2736: per_contact_relationships.object_version_number%TYPE;
2737: l_cur_add_rec per_addresses%ROWTYPE;
2738: l_cont_rec per_contact_relationships%ROWTYPE;
2739: l_pay_basis_name per_pay_bases.NAME%TYPE;
2740: l_organization_name hr_all_organization_units.NAME%TYPE;
2741: l_location_code hr_locations_all.location_code%TYPE;

Line 6882: -- Primary Address: Per_Addresses

6878: ,p_per_information27 IN Varchar2
6879: ,p_per_information28 IN Varchar2
6880: ,p_per_information29 IN Varchar2
6881: ,p_per_information30 IN Varchar2
6882: -- Primary Address: Per_Addresses
6883: ,p_pradd_ovlapval_override IN Varchar2
6884: ,p_address_type IN Varchar2
6885: ,p_adr_comments IN Varchar2
6886: ,p_primary_flag IN Varchar2