DBA Data[Home] [Help]

APPS.PA_PROJECTS_MAINT_PUB dependencies on PA_PM_CONTROL_ACTIONS

Line 3509: pa_pm_control_actions pa

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
3513: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE))