DBA Data[Home] [Help]

APPS.AHL_VWP_PROJ_PROD_PVT dependencies on PA_PROJECT_STATUS_CONTROLS

Line 1097: SELECT ENABLED_FLAG FROM PA_PROJECT_STATUS_CONTROLS

1093: WHERE organization_id = p_org_id;
1094:
1095: -- Added by rnahata for Bug 6334682
1096: CURSOR c_new_txns_flag(c_project_status_code IN VARCHAR) IS
1097: SELECT ENABLED_FLAG FROM PA_PROJECT_STATUS_CONTROLS
1098: WHERE PROJECT_STATUS_CODE LIKE c_project_status_code
1099: AND ACTION_CODE LIKE 'NEW_TXNS';
1100:
1101: /*Added by rnahata for Bug 5758813 - fetches the task details for all the tasks in the visit