APPS.CS_STD dependencies on PER_PHONES

Line 1025: from per_phones where phone_type='M'

1021:
1022: if contact_type ='M' then
1023: select phone_number
1024: into ret_val
1025: from per_phones where phone_type='M'
1026: and parent_id= p_resource_id and rownum =1;
1027:
1028: elsif contact_type ='W1' then
1029: select phone_number

Line 1031: from per_phones where phone_type='W1'

1027:
1028: elsif contact_type ='W1' then
1029: select phone_number
1030: into ret_val
1031: from per_phones where phone_type='W1'
1032: and parent_id= p_resource_id
1033: and date_to is null and rownum =1;
1034:
1035: elsif contact_type ='E' then