APPS.PQH_BDGT_ACTUAL_CMMTMNT_PKG dependencies on HR_PSF_SHD

Line 3829: and ( hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = p_unit_of_measure

3825: and budgeted_entity_cd = p_budget_entity
3826: and business_group_id = p_business_group_id -- Line added Bug Fix : 2432715
3827: and (p_start_date <= budget_end_date
3828: and p_end_date >= budget_start_date)
3829: and ( hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = p_unit_of_measure
3830: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = p_unit_of_measure
3831: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = p_unit_of_measure);
3832: --
3833: -- Cursors to fetch assignments

Line 3830: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = p_unit_of_measure

3826: and business_group_id = p_business_group_id -- Line added Bug Fix : 2432715
3827: and (p_start_date <= budget_end_date
3828: and p_end_date >= budget_start_date)
3829: and ( hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = p_unit_of_measure
3830: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = p_unit_of_measure
3831: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = p_unit_of_measure);
3832: --
3833: -- Cursors to fetch assignments
3834: --

Line 3831: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = p_unit_of_measure);

3827: and (p_start_date <= budget_end_date
3828: and p_end_date >= budget_start_date)
3829: and ( hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = p_unit_of_measure
3830: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = p_unit_of_measure
3831: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = p_unit_of_measure);
3832: --
3833: -- Cursors to fetch assignments
3834: --
3835: cursor csr_position_assg is