121: --bug2319133
122: CURSOR cur_dist_rule
123: IS
124: /* SELECT r.distribution_rule
125: FROM pa_project_type_distributions d, pa_distribution_rules r
126: WHERE d.distribution_rule = r.distribution_rule
127: AND project_type = p_project_type
128: AND default_flag = 'Y';
129: */
129: */
130: --copied from project_folder1.project_type_mir1 when-validate-item validation trigger.
131:
132: select distribution_rule
133: from pa_project_type_distributions
134: where project_type = p_project_type
135: and default_flag = 'Y';
136:
137: l_distribution_rule VARCHAR2(20);
1311:
1312: CURSOR cur_dist_rule
1313: IS
1314: /* SELECT r.distribution_rule
1315: FROM pa_project_type_distributions d, pa_distribution_rules r
1316: WHERE d.distribution_rule = r.distribution_rule
1317: AND project_type = p_project_type
1318: AND default_flag = 'Y';
1319: */
1319: */
1320: --copied from project_folder1.project_type_mir1 when-validate-item validation trigger.
1321:
1322: select distribution_rule
1323: from pa_project_type_distributions
1324: where project_type = p_project_type
1325: and default_flag = 'Y';
1326:
1327: