[Home] [Help]
1136: -- Note when a user starts submission process without clickin on service
1137: -- package button, this means all service packages are being selected
1138: -- even though psb_ws_submit_service_packages will have no records in it.
1139: SELECT COUNT(*) INTO l_service_package_count
1140: FROM dual
1141: WHERE EXISTS
1142: ( SELECT 1
1143: FROM psb_ws_submit_service_packages
1144: WHERE worksheet_id = l_worksheet_id
2842:
2843: /*For Bug No 2115869 Start */
2844: --Fine tuned the following sql by adding the rownum < 2 restriction in sub query
2845: --Also moved the psb_budget_accounts from subquery to main query
2846: SELECT 'Exists' INTO l_exists FROM dual
2847: WHERE EXISTS
2848: (SELECT 1
2849: FROM psb_budget_group_categories cats,
2850: psb_budget_workflow_rules rules,
2891: /*For Bug No 2115869 Start */
2892: --Fine tuned the following sql by adding the rownum < 2 restriction in sub query
2893: --Also moved the psb_budget_positions from subquery to main query
2894:
2895: SELECT 'Exists' INTO l_exists FROM dual
2896: WHERE EXISTS
2897: (SELECT 1
2898: FROM psb_budget_group_categories cats,
2899: psb_budget_workflow_rules rules,
2933: --p_review_group_exists := FND_API.G_FALSE ;
2934: l_exists := NULL;
2935: BEGIN
2936: SELECT 'Exists' INTO l_exists
2937: FROM DUAL
2938: WHERE EXISTS
2939: (SELECT 1
2940: FROM PSB_BUDGET_GROUP_CATEGORIES cats,
2941: PSB_BUDGET_WORKFLOW_RULES rules,