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);
1316:
1317: CURSOR cur_dist_rule
1318: IS
1319: /* SELECT r.distribution_rule
1320: FROM pa_project_type_distributions d, pa_distribution_rules r
1321: WHERE d.distribution_rule = r.distribution_rule
1322: AND project_type = p_project_type
1323: AND default_flag = 'Y';
1324: */
1324: */
1325: --copied from project_folder1.project_type_mir1 when-validate-item validation trigger.
1326:
1327: select distribution_rule
1328: from pa_project_type_distributions
1329: where project_type = p_project_type
1330: and default_flag = 'Y';
1331:
1332: