DBA Data[Home] [Help]

APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_PROJECT_TYPE_DISTRIBUTIONS

Line 125: FROM pa_project_type_distributions d, pa_distribution_rules r

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: */

Line 133: from pa_project_type_distributions

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);

Line 1320: FROM pa_project_type_distributions d, pa_distribution_rules r

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: */

Line 1328: from pa_project_type_distributions

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: