APPS.HR_ASSIGNMENT dependencies on HR_PSF_SHD

Line 4799: hr_psf_shd.system_availability_status(budget_unit1_id) unit1,

4795: cursor c0 is
4796: select *
4797: from (
4798: select
4799: hr_psf_shd.system_availability_status(budget_unit1_id) unit1,
4800: hr_psf_shd.system_availability_status(budget_unit2_id) unit2,
4801: hr_psf_shd.system_availability_status(budget_unit3_id) unit3
4802: from pqh_budgets
4803: where p_effective_date between budget_start_date and budget_end_date

Line 4800: hr_psf_shd.system_availability_status(budget_unit2_id) unit2,

4796: select *
4797: from (
4798: select
4799: hr_psf_shd.system_availability_status(budget_unit1_id) unit1,
4800: hr_psf_shd.system_availability_status(budget_unit2_id) unit2,
4801: hr_psf_shd.system_availability_status(budget_unit3_id) unit3
4802: from pqh_budgets
4803: where p_effective_date between budget_start_date and budget_end_date
4804: and position_control_flag = 'Y'

Line 4801: hr_psf_shd.system_availability_status(budget_unit3_id) unit3

4797: from (
4798: select
4799: hr_psf_shd.system_availability_status(budget_unit1_id) unit1,
4800: hr_psf_shd.system_availability_status(budget_unit2_id) unit2,
4801: hr_psf_shd.system_availability_status(budget_unit3_id) unit3
4802: from pqh_budgets
4803: where p_effective_date between budget_start_date and budget_end_date
4804: and position_control_flag = 'Y'
4805: and budgeted_entity_cd = 'POSITION'

Line 4840: and (hr_psf_shd.system_availability_status(budget_unit1_id) = 'MONEY'

4836: and p_effective_date
4837: between ver.date_from and ver.date_to
4838: and p_effective_date
4839: between bgt.budget_start_date and bgt.budget_end_date
4840: and (hr_psf_shd.system_availability_status(budget_unit1_id) = 'MONEY'
4841: or hr_psf_shd.system_availability_status(budget_unit2_id) = 'MONEY'
4842: or hr_psf_shd.system_availability_status(budget_unit3_id) = 'MONEY')
4843: )
4844: group by src.cost_allocation_keyflex_id;

Line 4841: or hr_psf_shd.system_availability_status(budget_unit2_id) = 'MONEY'

4837: between ver.date_from and ver.date_to
4838: and p_effective_date
4839: between bgt.budget_start_date and bgt.budget_end_date
4840: and (hr_psf_shd.system_availability_status(budget_unit1_id) = 'MONEY'
4841: or hr_psf_shd.system_availability_status(budget_unit2_id) = 'MONEY'
4842: or hr_psf_shd.system_availability_status(budget_unit3_id) = 'MONEY')
4843: )
4844: group by src.cost_allocation_keyflex_id;
4845: --

Line 4842: or hr_psf_shd.system_availability_status(budget_unit3_id) = 'MONEY')

4838: and p_effective_date
4839: between bgt.budget_start_date and bgt.budget_end_date
4840: and (hr_psf_shd.system_availability_status(budget_unit1_id) = 'MONEY'
4841: or hr_psf_shd.system_availability_status(budget_unit2_id) = 'MONEY'
4842: or hr_psf_shd.system_availability_status(budget_unit3_id) = 'MONEY')
4843: )
4844: group by src.cost_allocation_keyflex_id;
4845: --
4846: cursor c2(unit1 varchar2, unit2 varchar2, unit3 varchar2) is

Line 4871: and (hr_psf_shd.system_availability_status(budget_unit1_id) = 'MONEY'

4867: and p_effective_date
4868: between ver.date_from and ver.date_to
4869: and p_effective_date
4870: between bgt.budget_start_date and bgt.budget_end_date
4871: and (hr_psf_shd.system_availability_status(budget_unit1_id) = 'MONEY'
4872: or hr_psf_shd.system_availability_status(budget_unit2_id) = 'MONEY'
4873: or hr_psf_shd.system_availability_status(budget_unit3_id) = 'MONEY')
4874: );
4875: --

Line 4872: or hr_psf_shd.system_availability_status(budget_unit2_id) = 'MONEY'

4868: between ver.date_from and ver.date_to
4869: and p_effective_date
4870: between bgt.budget_start_date and bgt.budget_end_date
4871: and (hr_psf_shd.system_availability_status(budget_unit1_id) = 'MONEY'
4872: or hr_psf_shd.system_availability_status(budget_unit2_id) = 'MONEY'
4873: or hr_psf_shd.system_availability_status(budget_unit3_id) = 'MONEY')
4874: );
4875: --
4876: BEGIN

Line 4873: or hr_psf_shd.system_availability_status(budget_unit3_id) = 'MONEY')

4869: and p_effective_date
4870: between bgt.budget_start_date and bgt.budget_end_date
4871: and (hr_psf_shd.system_availability_status(budget_unit1_id) = 'MONEY'
4872: or hr_psf_shd.system_availability_status(budget_unit2_id) = 'MONEY'
4873: or hr_psf_shd.system_availability_status(budget_unit3_id) = 'MONEY')
4874: );
4875: --
4876: BEGIN
4877: hr_utility.set_location('hr_assignment.load_assignment_allocation',1);