eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BDGT_ACTUAL_CMMTMNT_PKG dependencies on PQH_BUDGET_VERSIONS

Line 99: From pqh_budget_versions bvr

95: is
96: --
97: Cursor csr_bdgt is
98: Select bvr.budget_id
99: From pqh_budget_versions bvr
100: Where bvr.budget_version_id = p_budget_version_id;
101: --
102: --
103: l_proc varchar2(72) := g_package || 'Validate_budget';

Line 147: From pqh_budget_details bdt,pqh_budget_versions bvr

143: -- budget version.
144: --
145: Cursor csr_positions_in_bdgt is
146: Select null
147: From pqh_budget_details bdt,pqh_budget_versions bvr
148: Where bvr.budget_version_id = p_budget_version_id
149: AND bvr.budget_version_id = bdt.budget_version_id
150: AND bdt.position_id = p_position_id;
151: --

Line 205: From pqh_budget_details bdt,pqh_budget_versions bvr

201: -- budget version.
202: --
203: Cursor csr_jobs_in_bdgt is
204: Select null
205: From pqh_budget_details bdt,pqh_budget_versions bvr
206: Where bvr.budget_version_id = p_budget_version_id
207: AND bvr.budget_version_id = bdt.budget_version_id
208: AND bdt.job_id = p_job_id;
209: --

Line 269: From pqh_budget_details bdt,pqh_budget_versions bvr

265: -- budget version.
266: --
267: Cursor csr_grades_in_bdgt is
268: Select null
269: From pqh_budget_details bdt,pqh_budget_versions bvr
270: Where bvr.budget_version_id = p_budget_version_id
271: AND bvr.budget_version_id = bdt.budget_version_id
272: AND bdt.grade_id = p_grade_id;
273: --

Line 332: From pqh_budget_details bdt,pqh_budget_versions bvr

328: -- budget version.
329: --
330: Cursor csr_orgs_in_bdgt is
331: Select null
332: From pqh_budget_details bdt,pqh_budget_versions bvr
333: Where bvr.budget_version_id = p_budget_version_id
334: AND bvr.budget_version_id = bdt.budget_version_id
335: AND bdt.organization_id = p_organization_id;
336: --

Line 1785: l_budget_version_id pqh_budget_versions.budget_version_id%type;

1781: l_assign_actuals number := 0;
1782: l_last_payroll_dt per_time_periods.end_date%type := NULL;
1783: --
1784: l_budget_id pqh_budgets.budget_id%type := NULL;
1785: l_budget_version_id pqh_budget_versions.budget_version_id%type;
1786: --
1787:
1788: l_unit_of_measure per_shared_types.system_type_cd%type;
1789: --

Line 1916: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,

1912: -- It is called from get budget commitment and get budget actuals
1913: --
1914: PROCEDURE get_pos_money_amounts
1915: (
1916: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
1917: p_position_id IN per_positions.position_id%TYPE,
1918: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1919: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1920: p_actual_amount OUT NOCOPY number,

Line 2319: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,

2315: -- It is called from get budget commitment and get budget actuals
2316: --
2317: Function get_pos_actual_and_cmmtmnt
2318: (
2319: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
2320: p_position_id IN per_positions.position_id%TYPE,
2321: p_element_type_id IN number default NULL,
2322: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2323: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 2571: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,

2567: -- It is called from get budget commitment and get budget actuals
2568: --
2569: Function get_ent_actual_and_cmmtmnt
2570: (
2571: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
2572: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
2573: p_entity_id IN pqh_budget_details.position_id%TYPE,
2574: p_element_type_id IN number default NULL,
2575: p_start_date IN pqh_budgets.budget_start_date%TYPE,

Line 3194: From pqh_budget_details bdt,pqh_budget_versions bvr

3190: l_unit_of_measure per_shared_types.system_type_cd%type;
3191: --
3192: Cursor csr_positions_in_bdgt is
3193: Select Position_id
3194: From pqh_budget_details bdt,pqh_budget_versions bvr
3195: Where bvr.budget_version_id = p_budget_version_id
3196: AND bvr.budget_version_id = bdt.budget_version_id
3197: AND bdt.position_id IS NOT NULL;
3198: --

Line 3271: From pqh_budget_details bdt,pqh_budget_versions bvr

3267: --
3268:
3269: Cursor csr_positions_in_bdgt is
3270: Select Position_id
3271: From pqh_budget_details bdt,pqh_budget_versions bvr
3272: Where bvr.budget_version_id = p_budget_version_id
3273: AND bvr.budget_version_id = bdt.budget_version_id
3274: AND bdt.position_id IS NOT NULL;
3275: --

Line 3357: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr

3353: --
3354:
3355: Cursor csr_positions_in_bdgt is
3356: Select Position_id
3357: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr
3358: Where bvr.budget_id = bgt.budget_id
3359: AND bvr.budget_version_id = p_budget_version_id
3360: AND bvr.budget_version_id = bdt.budget_version_id
3361: AND bgt.budgeted_entity_cd = 'POSITION';

Line 3365: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr

3361: AND bgt.budgeted_entity_cd = 'POSITION';
3362: --
3363: Cursor csr_jobs_in_bdgt is
3364: Select job_id
3365: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr
3366: Where bvr.budget_id = bgt.budget_id
3367: AND bvr.budget_version_id = p_budget_version_id
3368: AND bvr.budget_version_id = bdt.budget_version_id
3369: AND bgt.budgeted_entity_cd = 'JOB';

Line 3373: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr

3369: AND bgt.budgeted_entity_cd = 'JOB';
3370: --
3371: Cursor csr_grades_in_bdgt is
3372: Select grade_id
3373: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr
3374: Where bvr.budget_id = bgt.budget_id
3375: AND bvr.budget_version_id = p_budget_version_id
3376: AND bvr.budget_version_id = bdt.budget_version_id
3377: AND bgt.budgeted_entity_cd = 'GRADE';

Line 3381: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr

3377: AND bgt.budgeted_entity_cd = 'GRADE';
3378: --
3379: Cursor csr_orgs_in_bdgt is
3380: Select organization_id
3381: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr
3382: Where bvr.budget_id = bgt.budget_id
3383: AND bvr.budget_version_id = p_budget_version_id
3384: AND bvr.budget_version_id = bdt.budget_version_id
3385: AND bgt.budgeted_entity_cd = 'ORGANIZATION';

Line 3580: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr

3576: --
3577:
3578: Cursor csr_positions_in_bdgt is
3579: Select Position_id
3580: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr
3581: Where bvr.budget_id = bgt.budget_id
3582: AND bvr.budget_version_id = p_budget_version_id
3583: AND bvr.budget_version_id = bdt.budget_version_id
3584: AND bgt.budgeted_entity_cd = 'POSITION';

Line 3588: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr

3584: AND bgt.budgeted_entity_cd = 'POSITION';
3585: --
3586: Cursor csr_jobs_in_bdgt is
3587: Select job_id
3588: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr
3589: Where bvr.budget_id = bgt.budget_id
3590: AND bvr.budget_version_id = p_budget_version_id
3591: AND bvr.budget_version_id = bdt.budget_version_id
3592: AND bgt.budgeted_entity_cd = 'JOB';

Line 3596: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr

3592: AND bgt.budgeted_entity_cd = 'JOB';
3593: --
3594: Cursor csr_grades_in_bdgt is
3595: Select grade_id
3596: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr
3597: Where bvr.budget_id = bgt.budget_id
3598: AND bvr.budget_version_id = p_budget_version_id
3599: AND bvr.budget_version_id = bdt.budget_version_id
3600: AND bgt.budgeted_entity_cd = 'GRADE';

Line 3604: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr

3600: AND bgt.budgeted_entity_cd = 'GRADE';
3601: --
3602: Cursor csr_orgs_in_bdgt is
3603: Select organization_id
3604: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr
3605: Where bvr.budget_id = bgt.budget_id
3606: AND bvr.budget_version_id = p_budget_version_id
3607: AND bvr.budget_version_id = bdt.budget_version_id
3608: AND bgt.budgeted_entity_cd = 'ORGANIZATION';

Line 3818: from pqh_budgets bgt, pqh_budget_versions ver

3814: -- Single or multiple controlled budgets
3815: --
3816: cursor c_budgets is
3817: select bgt.budget_id, budget_version_id, budget_start_date, budget_end_date
3818: from pqh_budgets bgt, pqh_budget_versions ver
3819: where bgt.budget_id = ver.budget_id
3820: and (p_effective_date between date_from and date_to)
3821: and position_control_flag = 'Y'
3822: and budgeted_entity_cd = p_budget_entity