DBA Data[Home] [Help]

APPS.PV_WORKFLOW_PUB dependencies on AK_ATTRIBUTES_TL

Line 2656: from ak_attributes_tl ak

2652: and b.product_category_id = c.category_id;
2653:
2654: cursor lc_get_label (pc_notification_id number) is
2655: select attribute_code,attribute_label_long
2656: from ak_attributes_tl ak
2657: where attribute_application_id = 522
2658: AND ATTRIBUTE_code in ('ASF_AMOUNT','ASF_PRODUCT_CATEGORY')
2659: AND ak.language= userenv('LANG');
2660:

Line 2737: from ak_attributes_tl ak

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
2738: where attribute_application_id = 522
2739: AND ATTRIBUTE_code in ('ASF_EMAIL','ASF_PRIMARY','ASF_TITLE','ASF_PHONE','ASF_CONTACT_NAME')
2740: AND ak.language= userenv('LANG');
2741:

Line 2848: from ak_attributes_tl ak

2844: AND NOTE_STATUS = 'E';
2845:
2846: cursor lc_get_label (pc_notification_id number) is
2847: select attribute_code,attribute_label_long
2848: from ak_attributes_tl ak
2849: where attribute_application_id = 522
2850: AND ATTRIBUTE_code in ('ASF_DATE','ASF_CREATED_BY','ASF_NOTE')
2851: AND ak.language= userenv('LANG');
2852: