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 1934: l_position_name hr_all_positions_f.name%type := NULL;

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

Line 2106: From hr_all_positions_f

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

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

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

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

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

Line 4095: hr_all_positions_f pos,

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