DBA Data[Home] [Help]

APPS.PA_PROJECTS_MAINT_PUB dependencies on PA_PM_PRODUCT_CONTROL_RULES

Line 3508: FROM pa_pm_product_control_rules pc,

3504:
3505: -- Bug 12809532 : Check if Control Action is defined for 'Update Project Status'
3506: BEGIN
3507: SELECT 'Y' INTO l_cant_update_status
3508: FROM pa_pm_product_control_rules pc,
3509: pa_pm_control_actions pa
3510: WHERE pa.action = 'UPDATE_PROJECT_STATUS'
3511: AND pa.control_rule_id = pc.control_rule_id
3512: AND pc.pm_product_code = l_rec_project_details.pm_product_code