DBA Data[Home] [Help]

APPS.PA_RP_UTIL dependencies on XDO_LOBS

Line 80: PA_RP_Definitions_B rp, PA_RP_Template_Lists templates, XDO_LOBS xdo

76:
77: SELECT COUNT(*)
78: INTO l_count
79: FROM
80: PA_RP_Definitions_B rp, PA_RP_Template_Lists templates, XDO_LOBS xdo
81: WHERE rp.rp_Id = p_rp_id
82: AND rp.rp_Id = templates.rp_Id
83: AND templates.template_code = xdo.LOB_CODE
84: AND xdo.application_short_name = p_app_short_name

Line 93: PA_RP_Definitions_B rp, PA_RP_TYPES_b TYPES, XDO_LOBS xdo

89: IF l_count = 0 THEN
90: SELECT COUNT(*)
91: INTO l_count
92: FROM
93: PA_RP_Definitions_B rp, PA_RP_TYPES_b TYPES, XDO_LOBS xdo
94: WHERE rp.rp_Id = p_rp_id
95: AND rp.rp_type_Id = types.rp_type_Id
96: AND types.seeded_dt_code = xdo.LOB_CODE
97: AND xdo.application_short_name = p_app_short_name