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.

[Home] [Help]

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 1788: l_budget_version_id pqh_budget_versions.budget_version_id%type;

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

Line 1919: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,

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

Line 2322: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,

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

Line 2574: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,

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

Line 3197: From pqh_budget_details bdt,pqh_budget_versions bvr

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

Line 3274: From pqh_budget_details bdt,pqh_budget_versions bvr

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3821: from pqh_budgets bgt, pqh_budget_versions ver

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