APPS.IGW_GENERATE_PERIODS dependencies on IGW_RATE_CLASSES

Line 685: from igw_rate_classes pr

681: , igw_budget_personnel_details pbd
682: where pbd.budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id
683: and pca.budget_personnel_detail_id = pbd.budget_personnel_detail_id
684: and pca.rate_class_id = (select pr.rate_class_id
685: from igw_rate_classes pr
686: where pca.rate_class_id = pr.rate_class_id
687: and pr.rate_class_type = 'O');
688: EXCEPTION
689: when no_data_found then null;

Line 700: from igw_rate_classes pr

696: , igw_budget_personnel_details pbd
697: where pbd.budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id
698: and pca.budget_personnel_detail_id = pbd.budget_personnel_detail_id
699: and pca.rate_class_id = (select pr.rate_class_id
700: from igw_rate_classes pr
701: where pca.rate_class_id = pr.rate_class_id
702: and pr.rate_class_type = 'E');
703: EXCEPTION
704: when no_data_found then null;

Line 985: from igw_rate_classes pr

981: where proposal_id = p_proposal_id
982: and version_id = p_version_id
983: and budget_period_id = i+1
984: and pc.rate_class_id = ( select pr.rate_class_id
985: from igw_rate_classes pr
986: where pc.rate_class_id = pr.rate_class_id
987: and pr.rate_class_type = 'O');
988: select nvl(sum(calculated_cost_sharing),0)
989: , nvl(sum(calculated_cost),0)

Line 997: from igw_rate_classes pr

993: where proposal_id = p_proposal_id
994: and version_id = p_version_id
995: and budget_period_id = i+1
996: and pc.rate_class_id = ( select pr.rate_class_id
997: from igw_rate_classes pr
998: where pc.rate_class_id = pr.rate_class_id
999: and pr.rate_class_type = 'E');
1000:
1001: update igw_budget_periods

Line 1585: from igw_rate_classes pr

1581: , igw_budget_personnel_details pbd
1582: where pbd.budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id
1583: and pca.budget_personnel_detail_id = pbd.budget_personnel_detail_id
1584: and pca.rate_class_id = ( select pr.rate_class_id
1585: from igw_rate_classes pr
1586: where pca.rate_class_id = pr.rate_class_id
1587: and pr.rate_class_type = 'O');
1588: EXCEPTION
1589: when no_data_found then null;

Line 1600: from igw_rate_classes pr

1596: , igw_budget_personnel_details pbd
1597: where pbd.budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id
1598: and pca.budget_personnel_detail_id = pbd.budget_personnel_detail_id
1599: and pca.rate_class_id = ( select pr.rate_class_id
1600: from igw_rate_classes pr
1601: where pca.rate_class_id = pr.rate_class_id
1602: and pr.rate_class_type = 'E');
1603: EXCEPTION
1604: when no_data_found then null;

Line 1837: from igw_rate_classes pr

1833: where proposal_id = p_proposal_id
1834: and version_id = p_version_id
1835: and budget_period_id = i
1836: and pc.rate_class_id = ( select pr.rate_class_id
1837: from igw_rate_classes pr
1838: where pc.rate_class_id = pr.rate_class_id
1839: and pr.rate_class_type = 'O');
1840: select nvl(sum(calculated_cost_sharing),0)
1841: , nvl(sum(calculated_cost),0)

Line 1849: from igw_rate_classes pr

1845: where proposal_id = p_proposal_id
1846: and version_id = p_version_id
1847: and budget_period_id = i
1848: and pc.rate_class_id = ( select pr.rate_class_id
1849: from igw_rate_classes pr
1850: where pc.rate_class_id = pr.rate_class_id
1851: and pr.rate_class_type = 'E');
1852:
1853: update igw_budget_periods