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_MGMT_RPT_PKG dependencies on HR_GENERAL

Line 897: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

893: bgt.budget_unit2_id = p_unit_of_measure_id or
894: bgt.budget_unit3_id = p_unit_of_measure_id)
895: AND bdt.position_id = p_position_id
896: AND bgt.budgeted_entity_cd = 'POSITION'
897: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
898: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
899: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
900:
901: BEGIN

Line 931: l_business_group_id := hr_general.get_business_group_id;

927: l_total_amt := l_total_amt + l_curr_ver_tot;
928: --
929: else
930: --
931: l_business_group_id := hr_general.get_business_group_id;
932: --
933: OPEN csr_bdgt_positions(l_business_group_id);
934: LOOP
935: FETCH csr_bdgt_positions INTO l_budget_version_id,l_budget_id;

Line 1063: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

1059: bgt.budget_unit2_id = p_unit_of_measure_id or
1060: bgt.budget_unit3_id = p_unit_of_measure_id)
1061: AND bgt.budgeted_entity_cd = p_budgeted_entity_cd
1062: AND bdt.job_id = p_job_id
1063: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
1064: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
1065: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
1066: CURSOR csr_bdgts_grade(p_business_group_id number) IS
1067: SELECT

Line 1083: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

1079: bgt.budget_unit2_id = p_unit_of_measure_id or
1080: bgt.budget_unit3_id = p_unit_of_measure_id)
1081: AND bgt.budgeted_entity_cd = p_budgeted_entity_cd
1082: AND bdt.grade_id = p_grade_id
1083: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
1084: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
1085: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
1086: CURSOR csr_bdgts_org(p_business_group_id number) IS
1087: SELECT

Line 1103: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

1099: bgt.budget_unit2_id = p_unit_of_measure_id or
1100: bgt.budget_unit3_id = p_unit_of_measure_id)
1101: AND bgt.budgeted_entity_cd = p_budgeted_entity_cd
1102: AND bdt.organization_id = p_organization_id
1103: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
1104: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
1105: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
1106: procedure proc_job is
1107: BEGIN

Line 1184: l_business_group_id := hr_general.get_business_group_id;

1180: BEGIN
1181: hr_utility.set_location('Entering: '||l_proc, 5);
1182: --
1183: l_budget_measurement_type := get_budget_measurement_type(p_unit_of_measure_id);
1184: l_business_group_id := hr_general.get_business_group_id;
1185: if (p_budget_version_id is not null) then
1186: l_budget_version_id := p_budget_version_id;
1187: l_currency_code := get_currency_cd(p_budget_version_id);
1188: If p_budgeted_entity_cd = 'JOB' Then

Line 1399: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

1395: bgt.budget_unit2_id = p_unit_of_measure_id or
1396: bgt.budget_unit3_id = p_unit_of_measure_id)
1397: AND bgt.budgeted_entity_cd = p_budgeted_entity_cd
1398: AND bdt.job_id = p_job_id
1399: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
1400: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
1401: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
1402:
1403: CURSOR csr_bdgts_grade(p_business_group_id number) IS

Line 1420: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

1416: bgt.budget_unit2_id = p_unit_of_measure_id or
1417: bgt.budget_unit3_id = p_unit_of_measure_id)
1418: AND bgt.budgeted_entity_cd = p_budgeted_entity_cd
1419: AND bdt.grade_id = p_grade_id
1420: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
1421: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
1422: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
1423:
1424: CURSOR csr_bdgts_org(p_business_group_id number) IS

Line 1441: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

1437: bgt.budget_unit2_id = p_unit_of_measure_id or
1438: bgt.budget_unit3_id = p_unit_of_measure_id)
1439: AND bgt.budgeted_entity_cd = p_budgeted_entity_cd
1440: AND bdt.organization_id = p_organization_id
1441: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
1442: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
1443: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
1444:
1445: procedure proc1 is

Line 1473: l_business_group_id := hr_general.get_business_group_id;

1469: l_budget_version_id := p_budget_version_id;
1470: l_currency_code := get_currency_cd(p_budget_version_id);
1471: proc1;
1472: else
1473: l_business_group_id := hr_general.get_business_group_id;
1474: If p_budgeted_entity_cd = 'JOB' Then
1475: OPEN csr_bdgts_job(l_business_group_id);
1476: LOOP
1477: FETCH csr_bdgts_job INTO l_budget_version_id,l_currency_code;

Line 1725: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

1721: bgt.budget_unit2_id = p_unit_of_measure_id or
1722: bgt.budget_unit3_id = p_unit_of_measure_id)
1723: AND bdt.job_id = p_job_id
1724: AND bgt.budgeted_entity_cd = 'JOB'
1725: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
1726: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
1727: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
1728: procedure proc1 is
1729: begin

Line 1756: l_business_group_id := hr_general.get_business_group_id;

1752: l_currency_code := get_currency_cd(p_budget_version_id);
1753: proc1;
1754: else
1755: --
1756: l_business_group_id := hr_general.get_business_group_id;
1757: --
1758: OPEN csr_bdgt_jobs;
1759: LOOP
1760: FETCH csr_bdgt_jobs INTO l_budget_version_id,l_currency_code;

Line 1964: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

1960: bgt.budget_unit2_id = p_unit_of_measure_id or
1961: bgt.budget_unit3_id = p_unit_of_measure_id)
1962: AND bdt.grade_id = p_grade_id
1963: AND bgt.budgeted_entity_cd = 'GRADE'
1964: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
1965: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
1966: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
1967: procedure proc1 is
1968: begin

Line 1995: l_business_group_id := hr_general.get_business_group_id;

1991: l_currency_code := get_currency_cd(p_budget_version_id);
1992: proc1;
1993: else
1994: --
1995: l_business_group_id := hr_general.get_business_group_id;
1996: --
1997: OPEN csr_bdgt_grades;
1998: LOOP
1999: FETCH csr_bdgt_grades INTO l_budget_version_id,l_currency_code;

Line 2198: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

2194: bgt.budget_unit2_id = p_unit_of_measure_id or
2195: bgt.budget_unit3_id = p_unit_of_measure_id)
2196: AND bdt.organization_id = p_organization_id
2197: AND bgt.budgeted_entity_cd = 'ORGANIZATION'
2198: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
2199: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
2200: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
2201: procedure proc1 is
2202: BEGIN

Line 2229: l_business_group_id := hr_general.get_business_group_id;

2225: l_currency_code := get_currency_cd(p_budget_version_id);
2226: proc1;
2227: else
2228: --
2229: l_business_group_id := hr_general.get_business_group_id;
2230: --
2231: OPEN csr_bdgt_orgs;
2232: LOOP
2233: FETCH csr_bdgt_orgs INTO l_budget_version_id,l_currency_code;

Line 2341: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

2337: bgt.budget_unit3_id = p_unit_of_measure_id)
2338: AND bdt.position_id = p_position_id
2339: AND bel.element_type_id = p_element_type_id
2340: AND bgt.budgeted_entity_cd = 'POSITION'
2341: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
2342: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
2343: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
2344: procedure proc1 is
2345: BEGIN

Line 2379: l_business_group_id := hr_general.get_business_group_id;

2375: l_currency_code := get_currency_cd(p_budget_version_id);
2376: proc1;
2377: else
2378: --
2379: l_business_group_id := hr_general.get_business_group_id;
2380: --
2381: OPEN csr_bdgt_positions;
2382: LOOP
2383: FETCH csr_bdgt_positions INTO l_budget_version_id,l_currency_code;

Line 2460: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

2456: bgt.budget_unit3_id = p_unit_of_measure_id)
2457: AND bdt.job_id = p_job_id
2458: AND bel.element_type_id = p_element_type_id
2459: AND bgt.budgeted_entity_cd = 'JOB'
2460: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
2461: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
2462: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
2463: procedure proc1 is
2464: BEGIN

Line 2497: l_business_group_id := hr_general.get_business_group_id;

2493: l_currency_code := get_currency_cd(p_budget_version_id);
2494: proc1;
2495: else
2496: --
2497: l_business_group_id := hr_general.get_business_group_id;
2498: --
2499: OPEN csr_bdgt_jobs;
2500: LOOP
2501: FETCH csr_bdgt_jobs INTO l_budget_version_id,l_currency_code;

Line 2577: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

2573: bgt.budget_unit3_id = p_unit_of_measure_id)
2574: AND bdt.grade_id = p_grade_id
2575: AND bel.element_type_id = p_element_type_id
2576: AND bgt.budgeted_entity_cd = 'GRADE'
2577: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
2578: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
2579: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
2580: procedure proc1 is
2581: BEGIN

Line 2614: l_business_group_id := hr_general.get_business_group_id;

2610: l_currency_code := get_currency_cd(p_budget_version_id);
2611: proc1;
2612: else
2613: --
2614: l_business_group_id := hr_general.get_business_group_id;
2615: --
2616: OPEN csr_bdgt_grades;
2617: LOOP
2618: FETCH csr_bdgt_grades INTO l_budget_version_id,l_currency_code;

Line 2693: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

2689: bgt.budget_unit3_id = p_unit_of_measure_id)
2690: AND bdt.organization_id = p_organization_id
2691: AND bel.element_type_id = p_element_type_id
2692: AND bgt.budgeted_entity_cd = 'ORGANIZATION'
2693: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
2694: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
2695: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
2696:
2697: procedure proc1 is

Line 2731: l_business_group_id := hr_general.get_business_group_id;

2727: l_currency_code := get_currency_cd(p_budget_version_id);
2728: proc1;
2729: else
2730: --
2731: l_business_group_id := hr_general.get_business_group_id;
2732: --
2733: OPEN csr_bdgt_orgs;
2734: LOOP
2735: FETCH csr_bdgt_orgs INTO l_budget_version_id,l_currency_code;

Line 2793: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

2789: bgt.budget_unit3_id = p_unit_of_measure_id)
2790: AND bdt.position_id = p_position_id
2791: AND bst.dflt_budget_set_id = p_budget_set_id
2792: AND bgt.budgeted_entity_cd = 'POSITION'
2793: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
2794: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
2795: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
2796:
2797: CURSOR csr_bgt_elements IS

Line 2828: l_business_group_id := hr_general.get_business_group_id;

2824: l_budget_version_id := p_budget_version_id;
2825: proc1;
2826: else
2827: --
2828: l_business_group_id := hr_general.get_business_group_id;
2829: --
2830: OPEN csr_bdgt_positions;
2831: LOOP
2832: FETCH csr_bdgt_positions INTO l_budget_version_id;

Line 2896: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

2892: bgt.budget_unit2_id = p_unit_of_measure_id or
2893: bgt.budget_unit3_id = p_unit_of_measure_id)
2894: AND bdt.organization_id = p_organization_id
2895: AND bgt.budgeted_entity_cd = 'POSITION'
2896: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
2897: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
2898: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
2899: procedure proc1 is
2900: BEGIN

Line 2926: l_business_group_id := hr_general.get_business_group_id;

2922: hr_utility.set_location('Entering: '||l_proc, 5);
2923:
2924: --
2925: l_budget_measurement_type := get_budget_measurement_type(p_unit_of_measure_id);
2926: l_business_group_id := hr_general.get_business_group_id;
2927:
2928: OPEN csr_bdgt_positions(l_business_group_id);
2929: LOOP
2930: FETCH csr_bdgt_positions INTO l_budget_version_id, l_position_id,l_currency_code;

Line 2986: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

2982: bgt.budget_unit2_id = p_unit_of_measure_id or
2983: bgt.budget_unit3_id = p_unit_of_measure_id)
2984: AND bdt.organization_id = p_organization_id
2985: AND bgt.budgeted_entity_cd = 'POSITION'
2986: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
2987: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
2988: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
2989: procedure proc1 is
2990: BEGIN

Line 3017: l_business_group_id := hr_general.get_business_group_id;

3013: hr_utility.set_location('Entering: '||l_proc, 5);
3014:
3015: --
3016: l_budget_measurement_type := get_budget_measurement_type(p_unit_of_measure_id);
3017: l_business_group_id := hr_general.get_business_group_id;
3018:
3019: OPEN csr_bdgt_positions(l_business_group_id);
3020: LOOP
3021: FETCH csr_bdgt_positions INTO l_budget_version_id, l_position_id,l_currency_code;

Line 3072: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

3068: AND (bgt.budget_unit1_id = p_unit_of_measure_id or
3069: bgt.budget_unit2_id = p_unit_of_measure_id or
3070: bgt.budget_unit3_id = p_unit_of_measure_id)
3071: AND bgt.budgeted_entity_cd = 'POSITION'
3072: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
3073: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
3074: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
3075:
3076: BEGIN

Line 3156: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

3152: AND (bgt.budget_unit1_id = p_unit_of_measure_id or
3153: bgt.budget_unit2_id = p_unit_of_measure_id or
3154: bgt.budget_unit3_id = p_unit_of_measure_id)
3155: AND bgt.budgeted_entity_cd = 'POSITION'
3156: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
3157: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
3158: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
3159:
3160: BEGIN

Line 3243: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

3239: AND (bgt.budget_unit1_id = p_unit_of_measure_id or
3240: bgt.budget_unit2_id = p_unit_of_measure_id or
3241: bgt.budget_unit3_id = p_unit_of_measure_id)
3242: AND bgt.budgeted_entity_cd = 'POSITION'
3243: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
3244: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
3245: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
3246:
3247: BEGIN

Line 3251: l_business_group_id := hr_general.get_business_group_id;

3247: BEGIN
3248: hr_utility.set_location('Entering: '||l_proc, 5);
3249: --
3250: l_budget_measurement_type := get_budget_measurement_type(p_unit_of_measure_id);
3251: l_business_group_id := hr_general.get_business_group_id;
3252:
3253: OPEN csr_bdgt_positions(l_business_group_id);
3254: LOOP
3255: FETCH csr_bdgt_positions INTO l_budget_version_id, l_position_id,l_currency_code;

Line 3339: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

3335: AND (bgt.budget_unit1_id = p_unit_of_measure_id or
3336: bgt.budget_unit2_id = p_unit_of_measure_id or
3337: bgt.budget_unit3_id = p_unit_of_measure_id)
3338: AND bgt.budgeted_entity_cd = 'JOB'
3339: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
3340: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
3341: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
3342:
3343: BEGIN

Line 3347: l_business_group_id := hr_general.get_business_group_id;

3343: BEGIN
3344: hr_utility.set_location('Entering: '||l_proc, 5);
3345: --
3346: l_budget_measurement_type := get_budget_measurement_type(p_unit_of_measure_id);
3347: l_business_group_id := hr_general.get_business_group_id;
3348:
3349: OPEN csr_bdgt_jobs(l_business_group_id);
3350: LOOP
3351: FETCH csr_bdgt_jobs INTO l_budget_version_id, l_job_id,l_currency_code;

Line 3435: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

3431: AND (bgt.budget_unit1_id = p_unit_of_measure_id or
3432: bgt.budget_unit2_id = p_unit_of_measure_id or
3433: bgt.budget_unit3_id = p_unit_of_measure_id)
3434: AND bgt.budgeted_entity_cd = 'GRADE'
3435: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
3436: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
3437: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
3438:
3439: BEGIN

Line 3443: l_business_group_id := hr_general.get_business_group_id;

3439: BEGIN
3440: hr_utility.set_location('Entering: '||l_proc, 5);
3441: --
3442: l_budget_measurement_type := get_budget_measurement_type(p_unit_of_measure_id);
3443: l_business_group_id := hr_general.get_business_group_id;
3444:
3445: OPEN csr_bdgt_grades(l_business_group_id);
3446: LOOP
3447: FETCH csr_bdgt_grades INTO l_budget_version_id, l_grade_id,l_currency_code;

Line 3531: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

3527: AND (bgt.budget_unit1_id = p_unit_of_measure_id or
3528: bgt.budget_unit2_id = p_unit_of_measure_id or
3529: bgt.budget_unit3_id = p_unit_of_measure_id)
3530: AND bgt.budgeted_entity_cd = 'ORGANIZATION'
3531: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
3532: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
3533: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
3534:
3535: BEGIN

Line 3539: l_business_group_id := hr_general.get_business_group_id;

3535: BEGIN
3536: hr_utility.set_location('Entering: '||l_proc, 5);
3537: --
3538: l_budget_measurement_type := get_budget_measurement_type(p_unit_of_measure_id);
3539: l_business_group_id := hr_general.get_business_group_id;
3540:
3541: OPEN csr_bdgt_orgs(l_business_group_id);
3542: LOOP
3543: FETCH csr_bdgt_orgs INTO l_budget_version_id, l_organization_id,l_currency_code;

Line 3636: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

3632: bgt.budget_unit2_id = p_unit_of_measure_id or
3633: bgt.budget_unit3_id = p_unit_of_measure_id)
3634: AND bel.element_type_id = p_element_type_id
3635: AND bgt.budgeted_entity_cd = 'POSITION'
3636: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
3637: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
3638: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
3639:
3640: BEGIN

Line 3644: l_business_group_id := hr_general.get_business_group_id;

3640: BEGIN
3641: hr_utility.set_location('Entering: '||l_proc, 5);
3642: --
3643: l_budget_measurement_type := get_budget_measurement_type(p_unit_of_measure_id);
3644: l_business_group_id := hr_general.get_business_group_id;
3645:
3646: OPEN csr_bdgt_positions(l_business_group_id);
3647: LOOP
3648: FETCH csr_bdgt_positions INTO l_budget_version_id, l_position_id,l_currency_code;

Line 3744: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

3740: bgt.budget_unit2_id = p_unit_of_measure_id or
3741: bgt.budget_unit3_id = p_unit_of_measure_id)
3742: AND bel.element_type_id = p_element_type_id
3743: AND bgt.budgeted_entity_cd = 'JOB'
3744: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
3745: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
3746: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
3747:
3748: BEGIN

Line 3752: l_business_group_id := hr_general.get_business_group_id;

3748: BEGIN
3749: hr_utility.set_location('Entering: '||l_proc, 5);
3750: --
3751: l_budget_measurement_type := get_budget_measurement_type(p_unit_of_measure_id);
3752: l_business_group_id := hr_general.get_business_group_id;
3753: OPEN csr_bdgt_jobs(l_business_group_id);
3754: LOOP
3755: FETCH csr_bdgt_jobs INTO l_budget_version_id, l_job_id,l_currency_code;
3756: EXIT WHEN csr_bdgt_jobs%NOTFOUND;

Line 3851: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

3847: bgt.budget_unit2_id = p_unit_of_measure_id or
3848: bgt.budget_unit3_id = p_unit_of_measure_id)
3849: AND bel.element_type_id = p_element_type_id
3850: AND bgt.budgeted_entity_cd = 'GRADE'
3851: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
3852: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
3853: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
3854:
3855: BEGIN

Line 3859: l_business_group_id := hr_general.get_business_group_id;

3855: BEGIN
3856: hr_utility.set_location('Entering: '||l_proc, 5);
3857: --
3858: l_budget_measurement_type := get_budget_measurement_type(p_unit_of_measure_id);
3859: l_business_group_id := hr_general.get_business_group_id;
3860:
3861: OPEN csr_bdgt_grades(l_business_group_id);
3862: LOOP
3863: FETCH csr_bdgt_grades INTO l_budget_version_id, l_grade_id,l_currency_code;

Line 3958: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to

3954: bgt.budget_unit2_id = p_unit_of_measure_id or
3955: bgt.budget_unit3_id = p_unit_of_measure_id)
3956: AND bel.element_type_id = p_element_type_id
3957: AND bgt.budgeted_entity_cd = 'ORGANIZATION'
3958: AND hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
3959: AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
3960: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
3961:
3962: BEGIN

Line 3966: l_business_group_id := hr_general.get_business_group_id;

3962: BEGIN
3963: hr_utility.set_location('Entering: '||l_proc, 5);
3964: --
3965: l_budget_measurement_type := get_budget_measurement_type(p_unit_of_measure_id);
3966: l_business_group_id := hr_general.get_business_group_id;
3967:
3968: OPEN csr_bdgt_orgs(l_business_group_id);
3969: LOOP
3970: FETCH csr_bdgt_orgs INTO l_budget_version_id, l_organization_id,l_currency_code;