APPS.PQH_BDGT_ACTUAL_CMMTMNT_PKG dependencies on HR_PSF_SHD

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

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

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

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

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

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