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 1315: FROM pa_project_type_distributions d, pa_distribution_rules r

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

Line 1323: from pa_project_type_distributions

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: