APPS.PA_PRODUCT_INSTALL_UTILS dependencies on PA_PRODUCT_INSTALLATION_V

Line 18: pa_product_installation_v pi

14: /* Commenting for bug 6352484
15: Cursor C is
16: Select 'Y'
17: from PA_PRODUCT_FUNCTIONS PF,
18: pa_product_installation_v pi
19: where PF.object_type = p_object_type
20: and PF.object_code = p_object_code
21: and PF.product_code=pi.product_short_code
22: and pi.installed_flag='Y';

Line 27: pa_product_installation_v pi

23:
24: Cursor C2 is
25: Select 'N'
26: from PA_PRODUCT_FUNCTIONS PF,
27: pa_product_installation_v pi
28: where PF.object_type = p_object_type
29: and PF.object_code = p_object_code
30: and PF.product_code=pi.product_short_code
31: and pi.installed_flag='N';

Line 38: pa_product_installation_v pi

34: Cursor CNEW is
35: Select SUM(DECODE(nvl(pi.installed_flag,'Y'),'Y',1,0)) YCnt,
36: SUM(DECODE(nvl(pi.installed_flag,'N'),'N',1,0)) NCnt
37: from PA_PRODUCT_FUNCTIONS PF,
38: pa_product_installation_v pi
39: where PF.object_type = p_object_type
40: and PF.object_code = p_object_code
41: and PF.product_code=pi.product_short_code;
42: