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 867: from pqh_budgets bgt, pqh_budget_versions bgv

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

Line 929: from pqh_budgets bgt, pqh_budget_versions bgv

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

Line 989: from pqh_budgets bgt, pqh_budget_versions bgv

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

Line 1102: from pqh_budgets bgt, pqh_budget_versions bgv

1098: p_rows_inserted out nocopy number) is
1099: l_budget_start_date date;
1100: l_budget_end_date date;
1101: cursor c0 is select budget_start_date,budget_end_date
1102: from pqh_budgets bgt, pqh_budget_versions bgv
1103: where bgv.budget_id = bgt.budget_id
1104: and bgv.budget_version_id = p_budget_version_id;
1105: cursor c1 is select organization_id
1106: from hr_all_organization_units

Line 1244: from pqh_budget_versions bgv, pqh_budget_details bgd

1240: return l_budget_id;
1241: end get_wkd_budget;
1242: function get_bgd_budget( p_budget_detail_id in number) return number is
1243: cursor c1 is select budget_id
1244: from pqh_budget_versions bgv, pqh_budget_details bgd
1245: where bgd.budget_detail_id = p_budget_detail_id
1246: and bgd.budget_version_id = bgv.budget_version_id ;
1247: l_budget_id number;
1248: begin