APPS.HXT_UTIL dependencies on STANDARD

Line 649: , p_standard_start OUT NOCOPY NUMBER

645: , p_work_id IN OUT NOCOPY NUMBER
646: , p_rotation_id IN NUMBER
647: , p_osp_id OUT NOCOPY NUMBER
648: , p_sdf_id OUT NOCOPY NUMBER
649: , p_standard_start OUT NOCOPY NUMBER
650: , p_standard_stop OUT NOCOPY NUMBER
651: , p_early_start OUT NOCOPY NUMBER
652: , p_late_stop OUT NOCOPY NUMBER
653: , p_hours OUT NOCOPY NUMBER --SIR212

Line 650: , p_standard_stop OUT NOCOPY NUMBER

646: , p_rotation_id IN NUMBER
647: , p_osp_id OUT NOCOPY NUMBER
648: , p_sdf_id OUT NOCOPY NUMBER
649: , p_standard_start OUT NOCOPY NUMBER
650: , p_standard_stop OUT NOCOPY NUMBER
651: , p_early_start OUT NOCOPY NUMBER
652: , p_late_stop OUT NOCOPY NUMBER
653: , p_hours OUT NOCOPY NUMBER --SIR212
654: , p_error OUT NOCOPY NUMBER) IS

Line 693: sht.standard_start,

689: --ORACLE END IF;
690: -- Get shift diff and off-shift premiums
691: SELECT wsh.off_shift_prem_id,
692: wsh.shift_diff_ovrrd_id,
693: sht.standard_start,
694: sht.standard_stop,
695: sht.early_start,
696: sht.late_stop,
697: sht.hours

Line 694: sht.standard_stop,

690: -- Get shift diff and off-shift premiums
691: SELECT wsh.off_shift_prem_id,
692: wsh.shift_diff_ovrrd_id,
693: sht.standard_start,
694: sht.standard_stop,
695: sht.early_start,
696: sht.late_stop,
697: sht.hours
698: INTO p_osp_id,

Line 700: p_standard_start,

696: sht.late_stop,
697: sht.hours
698: INTO p_osp_id,
699: p_sdf_id,
700: p_standard_start,
701: p_standard_stop,
702: p_early_start,
703: p_late_stop,
704: p_hours

Line 701: p_standard_stop,

697: sht.hours
698: INTO p_osp_id,
699: p_sdf_id,
700: p_standard_start,
701: p_standard_stop,
702: p_early_start,
703: p_late_stop,
704: p_hours
705: FROM hxt_shifts sht,