APPS.IGW_BUDGET_OPERATIONS dependencies on IGW_RATE_CLASSES

Line 278: from igw_rate_classes pr

274: , igw_budget_personnel_details pbd
275: where pbd.budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id
276: and pca.budget_personnel_detail_id = pbd.budget_personnel_detail_id
277: and pca.rate_class_id = ( select pr.rate_class_id
278: from igw_rate_classes pr
279: where pca.rate_class_id = pr.rate_class_id
280: and pr.rate_class_type = 'O');
281: EXCEPTION
282: when no_data_found then

Line 294: from igw_rate_classes pr

290: , igw_budget_personnel_details pbd
291: where pbd.budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id
292: and pca.budget_personnel_detail_id = pbd.budget_personnel_detail_id
293: and pca.rate_class_id = ( select pr.rate_class_id
294: from igw_rate_classes pr
295: where pca.rate_class_id = pr.rate_class_id
296: and pr.rate_class_type = 'E');
297: EXCEPTION
298: when no_data_found then

Line 540: from igw_rate_classes pr

536: where proposal_id = p_proposal_id
537: and version_id = p_version_id
538: and budget_period_id = rec_budget_periods.budget_period_id
539: and pc.rate_class_id = ( select pr.rate_class_id
540: from igw_rate_classes pr
541: where pc.rate_class_id = pr.rate_class_id
542: and pr.rate_class_type = 'O');
543: select nvl(sum(calculated_cost_sharing),0)
544: , nvl(sum(calculated_cost),0)

Line 552: from igw_rate_classes pr

548: where proposal_id = p_proposal_id
549: and version_id = p_version_id
550: and budget_period_id = rec_budget_periods.budget_period_id
551: and pc.rate_class_id = ( select pr.rate_class_id
552: from igw_rate_classes pr
553: where pc.rate_class_id = pr.rate_class_id
554: and pr.rate_class_type = 'E');
555:
556: update igw_budget_periods

Line 1091: from igw_rate_classes pr

1087: where proposal_id = p_target_proposal_id
1088: and version_id = l_target_version_id
1089: and budget_period_id = 1
1090: and pc.rate_class_id = ( select pr.rate_class_id
1091: from igw_rate_classes pr
1092: where pc.rate_class_id = pr.rate_class_id
1093: and pr.rate_class_type = 'O');
1094: select nvl(sum(calculated_cost_sharing),0)
1095: , nvl(sum(calculated_cost),0)

Line 1103: from igw_rate_classes pr

1099: where proposal_id = p_target_proposal_id
1100: and version_id = l_target_version_id
1101: and budget_period_id = 1
1102: and pc.rate_class_id = ( select pr.rate_class_id
1103: from igw_rate_classes pr
1104: where pc.rate_class_id = pr.rate_class_id
1105: and pr.rate_class_type = 'E');
1106:
1107: update igw_budget_periods

Line 1515: from igw_rate_classes pr

1511: , igw_budget_personnel_details pbd
1512: where pbd.budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id
1513: and pca.budget_personnel_detail_id = pbd.budget_personnel_detail_id
1514: and pca.rate_class_id = ( select pr.rate_class_id
1515: from igw_rate_classes pr
1516: where pca.rate_class_id = pr.rate_class_id
1517: and pr.rate_class_type = 'O');
1518: EXCEPTION
1519: when no_data_found then

Line 1531: from igw_rate_classes pr

1527: , igw_budget_personnel_details pbd
1528: where pbd.budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id
1529: and pca.budget_personnel_detail_id = pbd.budget_personnel_detail_id
1530: and pca.rate_class_id = ( select pr.rate_class_id
1531: from igw_rate_classes pr
1532: where pca.rate_class_id = pr.rate_class_id
1533: and pr.rate_class_type = 'E');
1534: EXCEPTION
1535: when no_data_found then

Line 1818: from igw_rate_classes pr

1814: where proposal_id = p_proposal_id
1815: and version_id = p_version_id
1816: and budget_period_id = rec_budget_periods.budget_period_id
1817: and pc.rate_class_id = ( select pr.rate_class_id
1818: from igw_rate_classes pr
1819: where pc.rate_class_id = pr.rate_class_id
1820: and pr.rate_class_type = 'O');
1821: select nvl(sum(calculated_cost_sharing),0)
1822: , nvl(sum(calculated_cost),0)

Line 1830: from igw_rate_classes pr

1826: where proposal_id = p_proposal_id
1827: and version_id = p_version_id
1828: and budget_period_id = rec_budget_periods.budget_period_id
1829: and pc.rate_class_id = ( select pr.rate_class_id
1830: from igw_rate_classes pr
1831: where pc.rate_class_id = pr.rate_class_id
1832: and pr.rate_class_type = 'E');
1833:
1834: update igw_budget_periods