APPS.XTR_FPS1_P dependencies on XTR_PRODUCT_TYPES

Line 16: from XTR_PRODUCT_TYPES a

12: l_client_prod CHAR(1);
13: --
14: cursor PROD_LEVEL_ADV is
15: select nvl(a.CPARTY_ADVICE,'Y'),nvl(a.CLIENT_ADVICE,'Y')
16: from XTR_PRODUCT_TYPES a
17: where a.DEAL_TYPE = l_deal_type
18: and a.PRODUCT_TYPE = l_product;
19: --
20: cursor CPARTY_LEVEL_ADV is