APPS.PAY_SG_AWCAP_ARCHIVE dependencies on PER_ADDRESSES

Line 34: telephone_number per_addresses.telephone_number_1%type) ;

30: employee_name per_all_people_f.per_information1%type ,
31: employee_number per_all_people_f.employee_number%type ,
32: cpf_number per_all_people_f.per_information14%type,
33: person_id per_all_people_f.person_id%type,
34: telephone_number per_addresses.telephone_number_1%type) ;
35: --
36: emp_details_rec emp_details_store_rec;
37: --
38: -----------------------------------------------------

Line 262: per_addresses addr

258: nvl(pap.per_information14,pap.national_identifier) cpf_number, --CPF Number/National Identifier
259: pap.person_id person_id, --Person ID
260: nvl(addr.telephone_number_1,nvl(addr.telephone_number_2,addr.telephone_number_3)) telephone_number
261: from per_people_f pap,
262: per_addresses addr
263: where pap.person_id = c_person_id
264: and addr.person_id (+)= pap.person_id
265: and addr.primary_flag (+)= 'Y'
266: and pap.effective_start_date = (