APPS.PQH_WKS_BUDGET dependencies on PQH_BUDGET_VERSIONS

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

652: p_wks_ll_date out nocopy date,
653: p_wks_ul_date out nocopy date,
654: p_status out nocopy varchar2) is
655: l_max_version number;
656: cursor c0 is select max(version_number) from pqh_budget_versions
657: where budget_id = p_budget_id ;
658: cursor c1 is select 'x' from pqh_budget_versions
659: where budget_version_id = p_budget_version_id
660: and budget_id = p_budget_id;

Line 658: cursor c1 is select 'x' from pqh_budget_versions

654: p_status out nocopy varchar2) is
655: l_max_version number;
656: cursor c0 is select max(version_number) from pqh_budget_versions
657: where budget_id = p_budget_id ;
658: cursor c1 is select 'x' from pqh_budget_versions
659: where budget_version_id = p_budget_version_id
660: and budget_id = p_budget_id;
661: cursor c2 is select date_to from pqh_budget_versions
662: where version_number = l_max_version

Line 661: cursor c2 is select date_to from pqh_budget_versions

657: where budget_id = p_budget_id ;
658: cursor c1 is select 'x' from pqh_budget_versions
659: where budget_version_id = p_budget_version_id
660: and budget_id = p_budget_id;
661: cursor c2 is select date_to from pqh_budget_versions
662: where version_number = l_max_version
663: and budget_id = p_budget_id;
664: cursor c3 is select version_number from pqh_budget_versions
665: where budget_version_id = p_budget_version_id;

Line 664: cursor c3 is select version_number from pqh_budget_versions

660: and budget_id = p_budget_id;
661: cursor c2 is select date_to from pqh_budget_versions
662: where version_number = l_max_version
663: and budget_id = p_budget_id;
664: cursor c3 is select version_number from pqh_budget_versions
665: where budget_version_id = p_budget_version_id;
666: l_max_end_date date;
667: l_ver_chk varchar2(15);
668: l_version_number number;

Line 863: from pqh_budgets bgt, pqh_budget_versions bgv

859: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;
860: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%type;
861:
862: cursor c0 is select budget_start_date,budget_end_date,valid_grade_reqd_flag,budgeted_entity_cd
863: from pqh_budgets bgt, pqh_budget_versions bgv
864: where bgv.budget_id = bgt.budget_id
865: and bgv.budget_version_id = p_budget_version_id;
866: cursor c1 is select grade_id from per_grades a
867: where business_group_id = p_business_group_id

Line 925: from pqh_budgets bgt, pqh_budget_versions bgv

921: p_rows_inserted out nocopy number) is
922: l_budget_start_date date;
923: l_budget_end_date date;
924: cursor c0 is select budget_start_date,budget_end_date
925: from pqh_budgets bgt, pqh_budget_versions bgv
926: where bgv.budget_id = bgt.budget_id
927: and bgv.budget_version_id = p_budget_version_id;
928: cursor c1 is select job_id from per_jobs job, per_job_groups jgr
929: where job.job_group_id = jgr.job_group_id and jgr.internal_name = 'HR_' || job.business_group_id

Line 985: from pqh_budgets bgt, pqh_budget_versions bgv

981: p_rows_inserted out nocopy number) is
982: l_budget_start_date date;
983: l_budget_end_date date;
984: cursor c0 is select budget_start_date,budget_end_date
985: from pqh_budgets bgt, pqh_budget_versions bgv
986: where bgv.budget_id = bgt.budget_id
987: and bgv.budget_version_id = p_budget_version_id;
988: cursor c1 is select position_id,job_id,pos.organization_id organization_id
989: from hr_positions pos,hr_organization_units org

Line 1097: from pqh_budgets bgt, pqh_budget_versions bgv

1093: p_rows_inserted out nocopy number) is
1094: l_budget_start_date date;
1095: l_budget_end_date date;
1096: cursor c0 is select budget_start_date,budget_end_date
1097: from pqh_budgets bgt, pqh_budget_versions bgv
1098: where bgv.budget_id = bgt.budget_id
1099: and bgv.budget_version_id = p_budget_version_id;
1100: cursor c1 is select organization_id
1101: from hr_all_organization_units

Line 1239: from pqh_budget_versions bgv, pqh_budget_details bgd

1235: return l_budget_id;
1236: end get_wkd_budget;
1237: function get_bgd_budget( p_budget_detail_id in number) return number is
1238: cursor c1 is select budget_id
1239: from pqh_budget_versions bgv, pqh_budget_details bgd
1240: where bgd.budget_detail_id = p_budget_detail_id
1241: and bgd.budget_version_id = bgv.budget_version_id ;
1242: l_budget_id number;
1243: begin