APPS.HXT_UTIL dependencies on STANDARD

Line 645: , p_standard_start OUT NOCOPY NUMBER

641: , p_work_id IN OUT NOCOPY NUMBER
642: , p_rotation_id IN NUMBER
643: , p_osp_id OUT NOCOPY NUMBER
644: , p_sdf_id OUT NOCOPY NUMBER
645: , p_standard_start OUT NOCOPY NUMBER
646: , p_standard_stop OUT NOCOPY NUMBER
647: , p_early_start OUT NOCOPY NUMBER
648: , p_late_stop OUT NOCOPY NUMBER
649: , p_hours OUT NOCOPY NUMBER --SIR212

Line 646: , p_standard_stop OUT NOCOPY NUMBER

642: , p_rotation_id IN NUMBER
643: , p_osp_id OUT NOCOPY NUMBER
644: , p_sdf_id OUT NOCOPY NUMBER
645: , p_standard_start OUT NOCOPY NUMBER
646: , p_standard_stop OUT NOCOPY NUMBER
647: , p_early_start OUT NOCOPY NUMBER
648: , p_late_stop OUT NOCOPY NUMBER
649: , p_hours OUT NOCOPY NUMBER --SIR212
650: , p_error OUT NOCOPY NUMBER) IS

Line 689: sht.standard_start,

685: --ORACLE END IF;
686: -- Get shift diff and off-shift premiums
687: SELECT wsh.off_shift_prem_id,
688: wsh.shift_diff_ovrrd_id,
689: sht.standard_start,
690: sht.standard_stop,
691: sht.early_start,
692: sht.late_stop,
693: sht.hours

Line 690: sht.standard_stop,

686: -- Get shift diff and off-shift premiums
687: SELECT wsh.off_shift_prem_id,
688: wsh.shift_diff_ovrrd_id,
689: sht.standard_start,
690: sht.standard_stop,
691: sht.early_start,
692: sht.late_stop,
693: sht.hours
694: INTO p_osp_id,

Line 696: p_standard_start,

692: sht.late_stop,
693: sht.hours
694: INTO p_osp_id,
695: p_sdf_id,
696: p_standard_start,
697: p_standard_stop,
698: p_early_start,
699: p_late_stop,
700: p_hours

Line 697: p_standard_stop,

693: sht.hours
694: INTO p_osp_id,
695: p_sdf_id,
696: p_standard_start,
697: p_standard_stop,
698: p_early_start,
699: p_late_stop,
700: p_hours
701: FROM hxt_shifts sht,