APPS.PQH_BDGT dependencies on PQH_BUDGET_VERSIONS

Line 7: from pqh_budget_versions

3: g_package varchar2(100) := 'PQH_BDGT.' ;
4:
5: function get_bgv_budget( p_budget_version_id in number) return number is
6: cursor c1 is select budget_id
7: from pqh_budget_versions
8: where budget_version_id = p_budget_version_id ;
9: l_budget_id number;
10: begin
11: open c1;

Line 837: cursor c0 is select max(version_number) from pqh_budget_versions

833: p_bgv_ul_date out nocopy date,
834: p_status out nocopy varchar2) is
835: l_max_version number;
836: l_min_version number;
837: cursor c0 is select max(version_number) from pqh_budget_versions
838: where budget_id = p_budget_id ;
839: cursor c1 is select min(version_number) from pqh_budget_versions
840: where budget_id = p_budget_id ;
841: -- cursor to fetch the end_date of the last_version

Line 839: cursor c1 is select min(version_number) from pqh_budget_versions

835: l_max_version number;
836: l_min_version number;
837: cursor c0 is select max(version_number) from pqh_budget_versions
838: where budget_id = p_budget_id ;
839: cursor c1 is select min(version_number) from pqh_budget_versions
840: where budget_id = p_budget_id ;
841: -- cursor to fetch the end_date of the last_version
842: cursor c2 is select date_to from pqh_budget_versions
843: where version_number = l_max_version

Line 842: cursor c2 is select date_to from pqh_budget_versions

838: where budget_id = p_budget_id ;
839: cursor c1 is select min(version_number) from pqh_budget_versions
840: where budget_id = p_budget_id ;
841: -- cursor to fetch the end_date of the last_version
842: cursor c2 is select date_to from pqh_budget_versions
843: where version_number = l_max_version
844: and budget_id = p_budget_id;
845: -- cursor to fetch next version from the current version
846: cursor c5 is select date_from from pqh_budget_versions

Line 846: cursor c5 is select date_from from pqh_budget_versions

842: cursor c2 is select date_to from pqh_budget_versions
843: where version_number = l_max_version
844: and budget_id = p_budget_id;
845: -- cursor to fetch next version from the current version
846: cursor c5 is select date_from from pqh_budget_versions
847: where budget_id = p_budget_id
848: and version_number = (select min(version_number)
849: from pqh_budget_versions
850: where budget_id = p_budget_id

Line 849: from pqh_budget_versions

845: -- cursor to fetch next version from the current version
846: cursor c5 is select date_from from pqh_budget_versions
847: where budget_id = p_budget_id
848: and version_number = (select min(version_number)
849: from pqh_budget_versions
850: where budget_id = p_budget_id
851: and version_number > p_version_number) ;
852: -- cursor to fetch previous version from the current version
853: cursor c6 is select date_to from pqh_budget_versions

Line 853: cursor c6 is select date_to from pqh_budget_versions

849: from pqh_budget_versions
850: where budget_id = p_budget_id
851: and version_number > p_version_number) ;
852: -- cursor to fetch previous version from the current version
853: cursor c6 is select date_to from pqh_budget_versions
854: where budget_id = p_budget_id
855: and version_number = (select max(version_number)
856: from pqh_budget_versions
857: where budget_id = p_budget_id

Line 856: from pqh_budget_versions

852: -- cursor to fetch previous version from the current version
853: cursor c6 is select date_to from pqh_budget_versions
854: where budget_id = p_budget_id
855: and version_number = (select max(version_number)
856: from pqh_budget_versions
857: where budget_id = p_budget_id
858: and version_number < p_version_number) ;
859: l_max_end_date date;
860: l_min_start_date date;