APPS.PO_COMMUNICATION_PVT dependencies on PER_PHONES

Line 5957: tab.Now with this fix the buyers phone willbe taken from per_phones work

5953: PO_COMMUNICATION_PVT.g_buyer_email_address := null;
5954: PO_COMMUNICATION_PVT.g_buyer_fax := null; --Bug5671523
5955:
5956: /* Bug5191404 Buyer phone number was incorrectly taken from office details
5957: tab.Now with this fix the buyers phone willbe taken from per_phones work
5958: phone type.Commenting out the below sql and adding a new sql*/
5959:
5960: -- bug#5999438 modified the below sqls where clause date checking condition for work phone and work fax.
5961: -- added nvl to pph.date_from

Line 5968: FROM per_phones pph,

5964: pap.email_address,
5965: pph.phone_number
5966: INTO PO_COMMUNICATION_PVT.g_buyer_email_address,
5967: PO_COMMUNICATION_PVT.g_buyer_phone
5968: FROM per_phones pph,
5969: per_all_people_f pap
5970: WHERE pph.parent_id(+)=pap.person_id
5971: AND pph.parent_table(+)='PER_ALL_PEOPLE_F'
5972: AND pph.phone_type (+)= 'W1'

Line 5983: FROM per_phones pph,

5979: --Bug5671523 start
5980: SELECT
5981: pph.phone_number
5982: INTO PO_COMMUNICATION_PVT.g_buyer_fax
5983: FROM per_phones pph,
5984: per_all_people_f pap
5985: WHERE pph.parent_id(+)=pap.person_id
5986: AND pph.parent_table(+)='PER_ALL_PEOPLE_F'
5987: AND pph.phone_type(+)='WF'