APPS.PQH_APPLY_BUDGET dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 2064: l_organization_name hr_all_organization_units_tl.name%TYPE;

2060: l_proc varchar2(72) := g_package||'set_wks_log_context';
2061: l_worksheet_details_rec pqh_worksheet_details%ROWTYPE;
2062: l_position_name hr_positions.name%TYPE;
2063: l_job_name per_jobs.name%TYPE;
2064: l_organization_name hr_all_organization_units_tl.name%TYPE;
2065: l_grade_name per_grades.name%TYPE;
2066:
2067: CURSOR csr_wks_detail_rec IS
2068: SELECT *

Line 3095: cursor c4 is select name from hr_all_organization_units_tl

3091: from pqh_budgets
3092: where budget_id = l_budget_id;
3093: cursor c3 is select name from pqh_transaction_categories
3094: where transaction_category_id = l_tran_cat_id;
3095: cursor c4 is select name from hr_all_organization_units_tl
3096: where organization_id = l_organization_id
3097: and language = userenv('LANG');
3098: BEGIN
3099: hr_utility.set_location('inside build_wks_notice '||l_proc,10);