APPS.HR_ASSIGNMENT dependencies on HR_PSF_SHD

Line 4759: hr_psf_shd.system_availability_status(budget_unit1_id) unit1,

4755: cursor c0 is
4756: select *
4757: from (
4758: select
4759: hr_psf_shd.system_availability_status(budget_unit1_id) unit1,
4760: hr_psf_shd.system_availability_status(budget_unit2_id) unit2,
4761: hr_psf_shd.system_availability_status(budget_unit3_id) unit3
4762: from pqh_budgets
4763: where p_effective_date between budget_start_date and budget_end_date

Line 4760: hr_psf_shd.system_availability_status(budget_unit2_id) unit2,

4756: select *
4757: from (
4758: select
4759: hr_psf_shd.system_availability_status(budget_unit1_id) unit1,
4760: hr_psf_shd.system_availability_status(budget_unit2_id) unit2,
4761: hr_psf_shd.system_availability_status(budget_unit3_id) unit3
4762: from pqh_budgets
4763: where p_effective_date between budget_start_date and budget_end_date
4764: and position_control_flag = 'Y'

Line 4761: hr_psf_shd.system_availability_status(budget_unit3_id) unit3

4757: from (
4758: select
4759: hr_psf_shd.system_availability_status(budget_unit1_id) unit1,
4760: hr_psf_shd.system_availability_status(budget_unit2_id) unit2,
4761: hr_psf_shd.system_availability_status(budget_unit3_id) unit3
4762: from pqh_budgets
4763: where p_effective_date between budget_start_date and budget_end_date
4764: and position_control_flag = 'Y'
4765: and budgeted_entity_cd = 'POSITION'

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

4796: and p_effective_date
4797: between ver.date_from and ver.date_to
4798: and p_effective_date
4799: between bgt.budget_start_date and bgt.budget_end_date
4800: and (hr_psf_shd.system_availability_status(budget_unit1_id) = 'MONEY'
4801: or hr_psf_shd.system_availability_status(budget_unit2_id) = 'MONEY'
4802: or hr_psf_shd.system_availability_status(budget_unit3_id) = 'MONEY')
4803: )
4804: group by src.cost_allocation_keyflex_id;

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

4797: between ver.date_from and ver.date_to
4798: and p_effective_date
4799: between bgt.budget_start_date and bgt.budget_end_date
4800: and (hr_psf_shd.system_availability_status(budget_unit1_id) = 'MONEY'
4801: or hr_psf_shd.system_availability_status(budget_unit2_id) = 'MONEY'
4802: or hr_psf_shd.system_availability_status(budget_unit3_id) = 'MONEY')
4803: )
4804: group by src.cost_allocation_keyflex_id;
4805: --

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

4798: and p_effective_date
4799: between bgt.budget_start_date and bgt.budget_end_date
4800: and (hr_psf_shd.system_availability_status(budget_unit1_id) = 'MONEY'
4801: or hr_psf_shd.system_availability_status(budget_unit2_id) = 'MONEY'
4802: or hr_psf_shd.system_availability_status(budget_unit3_id) = 'MONEY')
4803: )
4804: group by src.cost_allocation_keyflex_id;
4805: --
4806: cursor c2(unit1 varchar2, unit2 varchar2, unit3 varchar2) is

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

4827: and p_effective_date
4828: between ver.date_from and ver.date_to
4829: and p_effective_date
4830: between bgt.budget_start_date and bgt.budget_end_date
4831: and (hr_psf_shd.system_availability_status(budget_unit1_id) = 'MONEY'
4832: or hr_psf_shd.system_availability_status(budget_unit2_id) = 'MONEY'
4833: or hr_psf_shd.system_availability_status(budget_unit3_id) = 'MONEY')
4834: );
4835: --

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

4828: between ver.date_from and ver.date_to
4829: and p_effective_date
4830: between bgt.budget_start_date and bgt.budget_end_date
4831: and (hr_psf_shd.system_availability_status(budget_unit1_id) = 'MONEY'
4832: or hr_psf_shd.system_availability_status(budget_unit2_id) = 'MONEY'
4833: or hr_psf_shd.system_availability_status(budget_unit3_id) = 'MONEY')
4834: );
4835: --
4836: BEGIN

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

4829: and p_effective_date
4830: between bgt.budget_start_date and bgt.budget_end_date
4831: and (hr_psf_shd.system_availability_status(budget_unit1_id) = 'MONEY'
4832: or hr_psf_shd.system_availability_status(budget_unit2_id) = 'MONEY'
4833: or hr_psf_shd.system_availability_status(budget_unit3_id) = 'MONEY')
4834: );
4835: --
4836: BEGIN
4837: hr_utility.set_location('hr_assignment.load_assignment_allocation',1);