APPS.PV_WORKFLOW_PUB dependencies on AS_OPPORTUNITY_CONTACTS_V

Line 2727: FROM AS_OPPORTUNITY_CONTACTS_V WHERE lead_id = pc_lead_id;

2723: cursor lc_get_contacts (pc_lead_id number) is
2724: SELECT EMAIL_ADDRESS emailAddress, PRIMARY_CONTACT_FLAG primaryContact,
2725: PERSON_PRE_NAME_ADJUNCT title, FIRST_NAME||',' || LAST_NAME fullName,
2726: trim(PHONE_COUNTRY_CODE || ' ' || AREA_CODE || ' ' || PHONE_NUMBER || ' ' ||EXTENSION) phoneNumber
2727: FROM AS_OPPORTUNITY_CONTACTS_V WHERE lead_id = pc_lead_id;
2728:
2729: cursor lc_max_lengths (pc_entity_id number) is
2730: SELECT max(length(EMAIL_ADDRESS)),
2731: max(length(PERSON_PRE_NAME_ADJUNCT)), max(length( FIRST_NAME||',' || LAST_NAME)),

Line 2733: FROM AS_OPPORTUNITY_CONTACTS_V WHERE lead_id = pc_entity_id;

2729: cursor lc_max_lengths (pc_entity_id number) is
2730: SELECT max(length(EMAIL_ADDRESS)),
2731: max(length(PERSON_PRE_NAME_ADJUNCT)), max(length( FIRST_NAME||',' || LAST_NAME)),
2732: max(length(trim(PHONE_COUNTRY_CODE || ' ' || AREA_CODE || ' ' || PHONE_NUMBER || ' ' ||EXTENSION)))
2733: FROM AS_OPPORTUNITY_CONTACTS_V WHERE lead_id = pc_entity_id;
2734:
2735: cursor lc_get_label (pc_notification_id number) is
2736: select attribute_code,attribute_label_long
2737: from ak_attributes_tl ak