APPS.PON_UDA_IMPORT_PKG dependencies on PO_UDA_AG_TEMPLATE_USAGES

Line 355: FROM po_uda_ag_template_usages

351: PON_UDA_IMPORT_PKG.DEBUG('l_user_row_identifier ' || l_user_row_identifier, d_progress);
352: d_progress := 150;
353:
354: SELECT ATTRIBUTE_CATEGORY INTO l_attr_category
355: FROM po_uda_ag_template_usages
356: WHERE TEMPLATE_ID=l_uda_template_id AND
357: ATTRIBUTE_GROUP_ID = l_attr_group_id;
358:
359: IF l_attr_category = 'PRICING' THEN

Line 366: po_uda_ag_template_usages u,

362: FROM FND_DESCR_FLEX_CONTEXTS_tl agtl,
363: FND_DESCR_FLEX_CONTEXTS ag,
364: EGO_ATTRS_V attr,
365: po_uda_ag_templates t,
366: po_uda_ag_template_usages u,
367: ego_fnd_dsc_flx_ctx_ext egoag
368: WHERE attr.ATTR_GROUP_TYPE = ag.DESCRIPTIVE_FLEXFIELD_NAME
369: AND attr.ATTR_GROUP_NAME = ag.DESCRIPTIVE_FLEX_CONTEXT_CODE
370: AND ag.DESCRIPTIVE_FLEXFIELD_NAME = agtl.DESCRIPTIVE_FLEXFIELD_NAME

Line 546: FROM po_uda_ag_template_usages

542: WHERE FUNCTIONAL_AREA='SOURCING' AND
543: ENTITY_CODE=l_attr_group_type;
544:
545: SELECT ATTRIBUTE_CATEGORY INTO l_attr_category
546: FROM po_uda_ag_template_usages
547: WHERE TEMPLATE_ID=l_uda_template_id AND
548: ATTRIBUTE_GROUP_ID = l_attr_group_id;
549:
550: d_progress := 80;