APPS.PQH_BDGT_ACTUAL_CMMTMNT_PKG dependencies on HR_ALL_POSITIONS_F

Line 138: From hr_all_positions_f

134: is
135: --
136: Cursor csr_pos is
137: Select null
138: From hr_all_positions_f
139: Where position_id = p_position_id;
140: --
141: --
142: -- The foll cursor checks if the passed position is present in the passed

Line 161: -- validate if the position is in hr_all_positions_f

157: --
158: hr_utility.set_location('Entering :'||l_proc,5);
159: --
160: --
161: -- validate if the position is in hr_all_positions_f
162: --
163: Open csr_pos;
164: Fetch csr_pos into l_dummy;
165: If csr_pos%notfound then

Line 670: l_business_group_id hr_all_positions_f.business_group_id%type;

666: p_period_end_dt in date,
667: p_unit_of_measure in varchar2)
668: RETURN number is
669: --
670: l_business_group_id hr_all_positions_f.business_group_id%type;
671: l_pbv number;
672: --
673: Cursor csr_pos is
674: Select psf.business_group_id

Line 675: from hr_all_positions_f psf

671: l_pbv number;
672: --
673: Cursor csr_pos is
674: Select psf.business_group_id
675: from hr_all_positions_f psf
676: Where psf.position_id = p_position_id
677: and rownum < 2;
678: --
679: l_proc varchar2(72) := g_package||'get_pos_budget_values';

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

1933: AND ASSG.effective_end_date >= p_start_date
1934: AND ASSG.effective_start_date <= p_end_date;
1935: --
1936: l_position_id pqh_budget_details.position_id%type;
1937: l_position_name hr_all_positions_f.name%type := NULL;
1938: l_assignment_id per_all_assignments_f.assignment_id%type;
1939: l_last_actuals_date per_time_periods.end_date%type;
1940: --
1941: l_budget_id pqh_budgets.budget_id%type := NULL;

Line 2109: From hr_all_positions_f

2105: l_proc varchar2(60) := g_package||'get_actual_hours';
2106:
2107: Cursor c_pos_freq(p_position_id number) Is
2108: Select frequency , working_hours
2109: From hr_all_positions_f
2110: Where p_effective_date between effective_start_date and effective_end_date
2111: And position_id = p_position_id;
2112:
2113: --frequency, workinig_hours of organization

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

2340: AND ASSG.effective_start_date <= p_end_date
2341: AND ASSG.assignment_id <> p_ex_assignment_id;
2342: --
2343: l_position_id pqh_budget_details.position_id%type;
2344: l_position_name hr_all_positions_f.name%type := NULL;
2345: l_assignment_id per_all_assignments_f.assignment_id%type;
2346: l_last_actuals_date per_time_periods.end_date%type;
2347: --
2348: l_budget_id pqh_budgets.budget_id%type := NULL;

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

3864: and assg.effective_end_date >= p_start_date
3865: and assg.effective_start_date <= p_end_date;
3866: --
3867: l_position_id pqh_budget_details.position_id%type;
3868: l_position_name hr_all_positions_f.name%type := NULL;
3869: l_assignment_id per_all_assignments_f.assignment_id%type;
3870: l_last_actuals_date per_time_periods.end_date%type;
3871: --
3872: l_budget_id pqh_budgets.budget_id%type := NULL;

Line 4098: hr_all_positions_f pos,

4094: --
4095: cursor curs1(p_position_id number, p_actuals_start_date date) is
4096: select classification_id
4097: from pay_element_classifications,
4098: hr_all_positions_f pos,
4099: HR_ORGANIZATION_INFORMATION O3
4100: where classification_name in ('Earnings', 'Employer Liabilities')
4101: and legislation_code = O3.ORG_INFORMATION9
4102: and pos.position_id = p_position_id