APPS.PA_RP_UTIL dependencies on PA_RP_TEMPLATE_LISTS

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 144: UPDATE pa_rp_template_lists

140: WHERE lobs.rp_id = p_rp_id
141: AND lobs.lob_type = 'DT'
142: FOR UPDATE;
143:
144: UPDATE pa_rp_template_lists
145: SET DT_Process_flag = 'Y'
146: WHERE rp_id = p_rp_id;
147: /*
148: SELECT trimmed_dt