DBA Data[Home] [Help]

APPS.PA_PRODUCT_INSTALL_UTILS dependencies on PA_PRODUCT_INSTALLATION_V

Line 13: pa_product_installation_v pi

9: /* Commenting for bug 6352484
10: Cursor C is
11: Select 'Y'
12: from PA_PRODUCT_FUNCTIONS PF,
13: pa_product_installation_v pi
14: where PF.object_type = p_object_type
15: and PF.object_code = p_object_code
16: and PF.product_code=pi.product_short_code
17: and pi.installed_flag='Y';

Line 22: pa_product_installation_v pi

18:
19: Cursor C2 is
20: Select 'N'
21: from PA_PRODUCT_FUNCTIONS PF,
22: pa_product_installation_v pi
23: where PF.object_type = p_object_type
24: and PF.object_code = p_object_code
25: and PF.product_code=pi.product_short_code
26: and pi.installed_flag='N';

Line 31: pa_product_installation_v pi

27: */
28: Cursor CNEW is
29: Select nvl(pi.installed_flag,'Y')
30: from PA_PRODUCT_FUNCTIONS PF,
31: pa_product_installation_v pi
32: where PF.object_type = p_object_type
33: and PF.object_code = p_object_code
34: and PF.product_code=pi.product_short_code;
35: