APPS.PA_CLIENT_EXTN_GEN_ASSET_LINES dependencies on IPA_ASSET_MECH_APIS_PKG

Line 40: AND ( (NVL(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N') = 'Y'

36: and nvl(ppaa.attribute8,'~!@#') = nvl(p_attribute8,'~!@#')
37: and nvl(ppaa.attribute9,'~!@#') = nvl(p_attribute9,'~!@#')
38: and nvl(ppaa.attribute10,'~!@#') = nvl(p_attribute10,'~!@#')
39: /* Start Bug fix:2956569 : attribute6,7 Should be used only when the nl_installed flag = Y*/
40: AND ( (NVL(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N') = 'Y'
41: AND nvl(ppaa.attribute6,'~!@#') = nvl(p_attribute6, '~!@#') --crl_inventory
42: AND nvl(ppaa.attribute7,'~!@#') = nvl(p_attribute7, '~!@#') --serial_number
43: )
44: OR

Line 45: NVL(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N') = 'N'

41: AND nvl(ppaa.attribute6,'~!@#') = nvl(p_attribute6, '~!@#') --crl_inventory
42: AND nvl(ppaa.attribute7,'~!@#') = nvl(p_attribute7, '~!@#') --serial_number
43: )
44: OR
45: NVL(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N') = 'N'
46: );
47: /* End Bug fix:2956569 */
48:
49: