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_DETAILS

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 1936: l_position_id pqh_budget_details.position_id%type;

1932: Where ASSG.position_id = p_position_id
1933: AND ASSG.effective_end_date >= p_start_date
1934: AND ASSG.effective_start_date <= p_end_date;
1935: --
1936: l_position_id pqh_budget_details.position_id%type;
1937: l_position_name hr_all_positions_f.name%type := NULL;
1938: l_assignment_id per_all_assignments_f.assignment_id%type;
1939: l_last_actuals_date per_time_periods.end_date%type;
1940: --

Line 2343: l_position_id pqh_budget_details.position_id%type;

2339: AND ASSG.effective_end_date >= p_start_date
2340: AND ASSG.effective_start_date <= p_end_date
2341: AND ASSG.assignment_id <> p_ex_assignment_id;
2342: --
2343: l_position_id pqh_budget_details.position_id%type;
2344: l_position_name hr_all_positions_f.name%type := NULL;
2345: l_assignment_id per_all_assignments_f.assignment_id%type;
2346: l_last_actuals_date per_time_periods.end_date%type;
2347: --

Line 2576: p_entity_id IN pqh_budget_details.position_id%TYPE,

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,
2579: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2580: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 3190: l_position_id pqh_budget_details.position_id%type;

3186: RETURN NUMBER IS
3187: --
3188: l_position_actuals number;
3189: l_budget_actuals number;
3190: l_position_id pqh_budget_details.position_id%type;
3191: --
3192: l_budget_id pqh_budgets.budget_id%type := NULL;
3193: l_unit_of_measure per_shared_types.system_type_cd%type;
3194: --

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 3266: l_position_id pqh_budget_details.position_id%type;

3262: IS
3263: --
3264: l_position_commitment number;
3265: l_budget_commitment number;
3266: l_position_id pqh_budget_details.position_id%type;
3267: --
3268: l_budget_id pqh_budgets.budget_id%type := NULL;
3269: l_unit_of_measure per_shared_types.system_type_cd%type;
3270: --

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 3349: l_position_id pqh_budget_details.position_id%type;

3345: IS
3346: --
3347: l_entity_actuals number;
3348: l_budget_actuals number;
3349: l_position_id pqh_budget_details.position_id%type;
3350: l_job_id pqh_budget_details.position_id%type;
3351: l_grade_id pqh_budget_details.position_id%type;
3352: l_organization_id pqh_budget_details.position_id%type;
3353: --

Line 3350: l_job_id pqh_budget_details.position_id%type;

3346: --
3347: l_entity_actuals number;
3348: l_budget_actuals number;
3349: l_position_id pqh_budget_details.position_id%type;
3350: l_job_id pqh_budget_details.position_id%type;
3351: l_grade_id pqh_budget_details.position_id%type;
3352: l_organization_id pqh_budget_details.position_id%type;
3353: --
3354: l_budget_id pqh_budgets.budget_id%type := NULL;

Line 3351: l_grade_id pqh_budget_details.position_id%type;

3347: l_entity_actuals number;
3348: l_budget_actuals number;
3349: l_position_id pqh_budget_details.position_id%type;
3350: l_job_id pqh_budget_details.position_id%type;
3351: l_grade_id pqh_budget_details.position_id%type;
3352: l_organization_id pqh_budget_details.position_id%type;
3353: --
3354: l_budget_id pqh_budgets.budget_id%type := NULL;
3355: l_unit_of_measure per_shared_types.system_type_cd%type;

Line 3352: l_organization_id pqh_budget_details.position_id%type;

3348: l_budget_actuals number;
3349: l_position_id pqh_budget_details.position_id%type;
3350: l_job_id pqh_budget_details.position_id%type;
3351: l_grade_id pqh_budget_details.position_id%type;
3352: l_organization_id pqh_budget_details.position_id%type;
3353: --
3354: l_budget_id pqh_budgets.budget_id%type := NULL;
3355: l_unit_of_measure per_shared_types.system_type_cd%type;
3356: --

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 3572: l_position_id pqh_budget_details.position_id%type;

3568: IS
3569: --
3570: l_entity_commitment number;
3571: l_budget_commitment number;
3572: l_position_id pqh_budget_details.position_id%type;
3573: l_job_id pqh_budget_details.position_id%type;
3574: l_grade_id pqh_budget_details.position_id%type;
3575: l_organization_id pqh_budget_details.position_id%type;
3576: --

Line 3573: l_job_id pqh_budget_details.position_id%type;

3569: --
3570: l_entity_commitment number;
3571: l_budget_commitment number;
3572: l_position_id pqh_budget_details.position_id%type;
3573: l_job_id pqh_budget_details.position_id%type;
3574: l_grade_id pqh_budget_details.position_id%type;
3575: l_organization_id pqh_budget_details.position_id%type;
3576: --
3577: l_budget_id pqh_budgets.budget_id%type := NULL;

Line 3574: l_grade_id pqh_budget_details.position_id%type;

3570: l_entity_commitment number;
3571: l_budget_commitment number;
3572: l_position_id pqh_budget_details.position_id%type;
3573: l_job_id pqh_budget_details.position_id%type;
3574: l_grade_id pqh_budget_details.position_id%type;
3575: l_organization_id pqh_budget_details.position_id%type;
3576: --
3577: l_budget_id pqh_budgets.budget_id%type := NULL;
3578: l_unit_of_measure per_shared_types.system_type_cd%type;

Line 3575: l_organization_id pqh_budget_details.position_id%type;

3571: l_budget_commitment number;
3572: l_position_id pqh_budget_details.position_id%type;
3573: l_job_id pqh_budget_details.position_id%type;
3574: l_grade_id pqh_budget_details.position_id%type;
3575: l_organization_id pqh_budget_details.position_id%type;
3576: --
3577: l_budget_id pqh_budgets.budget_id%type := NULL;
3578: l_unit_of_measure per_shared_types.system_type_cd%type;
3579: --

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 3867: l_position_id pqh_budget_details.position_id%type;

3863: and p_grade_id = assg.grade_id
3864: and assg.effective_end_date >= p_start_date
3865: and assg.effective_start_date <= p_end_date;
3866: --
3867: l_position_id pqh_budget_details.position_id%type;
3868: l_position_name hr_all_positions_f.name%type := NULL;
3869: l_assignment_id per_all_assignments_f.assignment_id%type;
3870: l_last_actuals_date per_time_periods.end_date%type;
3871: --