DBA Data[Home] [Help]

APPS.PQH_COMMITMENT_PKG dependencies on HR_ALL_POSITIONS_F

Line 268: From hr_all_positions_f_tl

264: is
265: --
266: Cursor csr_pos(l_position_id in number) is
267: Select name
268: From hr_all_positions_f_tl
269: Where position_id = l_position_id
270: and language = userenv('LANG');
271: --
272: Cursor csr_org(l_org_id in number) is

Line 344: -- VALIDATE IF THIS IS A VALID POSITION IN HR_ALL_POSITIONS_F

340: If p_budgeted_entity_cd ='POSITION' then
341:
342: If p_entity_id IS NOT NULL then
343: --
344: -- VALIDATE IF THIS IS A VALID POSITION IN HR_ALL_POSITIONS_F
345: --
346: Open csr_pos(p_entity_id);
347: --
348: Fetch csr_pos into p_entity_name;

Line 2847: l_position_name hr_all_positions_f.name%type := NULL;

2843: IS
2844: --
2845: l_proc varchar2(72) := g_package||'calculate_money_cmmtmnts';
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;