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

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

Line 2340: l_position_id pqh_budget_details.position_id%type;

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

Line 2573: p_entity_id IN pqh_budget_details.position_id%TYPE,

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

Line 3187: l_position_id pqh_budget_details.position_id%type;

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

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

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

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

3342: IS
3343: --
3344: l_entity_actuals number;
3345: l_budget_actuals number;
3346: l_position_id pqh_budget_details.position_id%type;
3347: l_job_id pqh_budget_details.position_id%type;
3348: l_grade_id pqh_budget_details.position_id%type;
3349: l_organization_id pqh_budget_details.position_id%type;
3350: --

Line 3347: l_job_id pqh_budget_details.position_id%type;

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

Line 3348: l_grade_id pqh_budget_details.position_id%type;

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

Line 3349: l_organization_id pqh_budget_details.position_id%type;

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

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

3565: IS
3566: --
3567: l_entity_commitment number;
3568: l_budget_commitment number;
3569: l_position_id pqh_budget_details.position_id%type;
3570: l_job_id pqh_budget_details.position_id%type;
3571: l_grade_id pqh_budget_details.position_id%type;
3572: l_organization_id pqh_budget_details.position_id%type;
3573: --

Line 3570: l_job_id pqh_budget_details.position_id%type;

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

Line 3571: l_grade_id pqh_budget_details.position_id%type;

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

Line 3572: l_organization_id pqh_budget_details.position_id%type;

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

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

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