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_COMMITMENT_PKG dependencies on PQH_BUDGETS

Line 176: From pqh_budgets bgt

172: --
173: Cursor csr_bdgt is
174: Select bgt.budget_id,budget_name,period_set_name ,budgeted_entity_cd,
175: budget_start_date,budget_end_date
176: From pqh_budgets bgt
177: Where bgt.budget_id in (Select bvr.budget_id
178: From pqh_budget_versions bvr
179: Where bvr.budget_version_id = p_budget_version_id);
180: --

Line 195: -- VALIDATE IF THIS IS A VALID BUDGET IN PQH_BUDGETS

191: Begin
192: --
193: hr_utility.set_location('Entering :'||l_proc,5);
194: --
195: -- VALIDATE IF THIS IS A VALID BUDGET IN PQH_BUDGETS
196: --
197: Open csr_bdgt;
198: --
199: Fetch csr_bdgt into p_budget_id,p_budget_name,p_period_set_name,l_budgeted_entity_cd,

Line 2136: From PQH_BUDGETS BGT

2132: --This cursor checks if Budget is a position controll or not
2133: --
2134: Cursor csr_posctrl_budget_chk IS
2135: Select 1
2136: From PQH_BUDGETS BGT
2137: Where BGT.BUDGET_ID =p_budget_id And
2138: BGT.POSITION_CONTROL_FLAG ='Y';
2139: /* BGT.budgeted_entity_cd='POSITION' And LD Integration is not limited for Position Control Budgets only
2140: BGT.transfer_to_grants_flags ='Y' And We will Check for ecumbrance even when Budget is not

Line 2850: l_budget_id pqh_budgets.budget_id%type := NULL;

2846: --
2847: l_position_name hr_all_positions_f.name%type := NULL;
2848: l_entity_name pqh_cmmtmnt_entities_v.entity_name%type := NULL;
2849: --
2850: l_budget_id pqh_budgets.budget_id%type := NULL;
2851: l_budget_name pqh_budgets.budget_name%type := NULL;
2852: l_period_set_name pqh_budgets.period_set_name%type := NULL;
2853: l_budget_cal_freq pay_calendars.actual_period_type%type;
2854: l_budget_start_date date;

Line 2851: l_budget_name pqh_budgets.budget_name%type := NULL;

2847: l_position_name hr_all_positions_f.name%type := NULL;
2848: l_entity_name pqh_cmmtmnt_entities_v.entity_name%type := NULL;
2849: --
2850: l_budget_id pqh_budgets.budget_id%type := NULL;
2851: l_budget_name pqh_budgets.budget_name%type := NULL;
2852: l_period_set_name pqh_budgets.period_set_name%type := NULL;
2853: l_budget_cal_freq pay_calendars.actual_period_type%type;
2854: l_budget_start_date date;
2855: l_budget_end_date date;

Line 2852: l_period_set_name pqh_budgets.period_set_name%type := NULL;

2848: l_entity_name pqh_cmmtmnt_entities_v.entity_name%type := NULL;
2849: --
2850: l_budget_id pqh_budgets.budget_id%type := NULL;
2851: l_budget_name pqh_budgets.budget_name%type := NULL;
2852: l_period_set_name pqh_budgets.period_set_name%type := NULL;
2853: l_budget_cal_freq pay_calendars.actual_period_type%type;
2854: l_budget_start_date date;
2855: l_budget_end_date date;
2856: l_cmmtmnt_start_dt date;

Line 2867: From pqh_budgets

2863: cnt number(15);
2864: --
2865: Cursor csrGetBudgetName(l_bdgt_id in number) Is
2866: Select budget_name
2867: From pqh_budgets
2868: Where budget_id = l_bdgt_id;
2869:
2870: --
2871: l_status number(15);

Line 3685: From PQH_BUDGETS bdgts,per_shared_types shtyps

3681: -- Control Budget (position - money) as of the effective date for the current BG
3682: Cursor csr_get_ctrl_bdgt IS
3683: Select bdgts.budget_id,budget_name,period_set_name ,
3684: budget_start_date,budget_end_date
3685: From PQH_BUDGETS bdgts,per_shared_types shtyps
3686: where p_effective_date between budget_start_date and budget_end_date
3687: and position_control_flag ='Y'
3688: and budgeted_entity_cd ='POSITION'
3689: and shtyps.shared_type_id = bdgts.budget_unit1_id

Line 3753: From pqh_budgets

3749: and p_effective_date between piv.effective_start_date and piv.effective_end_date;
3750: --
3751: Cursor csrGetBudgetName(l_bdgt_id in number) Is
3752: Select budget_name
3753: From pqh_budgets
3754: Where budget_id = l_bdgt_id;
3755:
3756: --
3757: l_formula_id Number;

Line 3760: l_budget_id pqh_budgets.budget_id%type := NULL;

3756: --
3757: l_formula_id Number;
3758: l_salary_basis_flag varchar2(10);
3759: l_dflt_elmnt_frequency varchar2(30);
3760: l_budget_id pqh_budgets.budget_id%type := NULL;
3761: l_budget_name pqh_budgets.budget_name%type := NULL;
3762: l_period_set_name pqh_budgets.period_set_name%type := NULL;
3763: l_budget_cal_freq pay_calendars.actual_period_type%type;
3764: l_budget_start_date date;

Line 3761: l_budget_name pqh_budgets.budget_name%type := NULL;

3757: l_formula_id Number;
3758: l_salary_basis_flag varchar2(10);
3759: l_dflt_elmnt_frequency varchar2(30);
3760: l_budget_id pqh_budgets.budget_id%type := NULL;
3761: l_budget_name pqh_budgets.budget_name%type := NULL;
3762: l_period_set_name pqh_budgets.period_set_name%type := NULL;
3763: l_budget_cal_freq pay_calendars.actual_period_type%type;
3764: l_budget_start_date date;
3765: l_budget_end_date date;

Line 3762: l_period_set_name pqh_budgets.period_set_name%type := NULL;

3758: l_salary_basis_flag varchar2(10);
3759: l_dflt_elmnt_frequency varchar2(30);
3760: l_budget_id pqh_budgets.budget_id%type := NULL;
3761: l_budget_name pqh_budgets.budget_name%type := NULL;
3762: l_period_set_name pqh_budgets.period_set_name%type := NULL;
3763: l_budget_cal_freq pay_calendars.actual_period_type%type;
3764: l_budget_start_date date;
3765: l_budget_end_date date;
3766: l_cmmtmnt_start_dt date;