APPS.HXC_TER_BUS dependencies on HR_GENERAL

Line 325: ter.start_date AND NVL(ter.end_date, HR_GENERAL.END_OF_TIME )

321: ( p_bg_id IS NULL ) )
322: AND (
323: (
324: ( p_start_date BETWEEN
325: ter.start_date AND NVL(ter.end_date, HR_GENERAL.END_OF_TIME )
326: )
327: OR
328: ( NVL(p_end_date, HR_GENERAL.END_OF_TIME ) BETWEEN
329: ter.start_date AND NVL(ter.end_date, HR_GENERAL.END_OF_TIME )

Line 328: ( NVL(p_end_date, HR_GENERAL.END_OF_TIME ) BETWEEN

324: ( p_start_date BETWEEN
325: ter.start_date AND NVL(ter.end_date, HR_GENERAL.END_OF_TIME )
326: )
327: OR
328: ( NVL(p_end_date, HR_GENERAL.END_OF_TIME ) BETWEEN
329: ter.start_date AND NVL(ter.end_date, HR_GENERAL.END_OF_TIME )
330: )
331: )
332: OR

Line 329: ter.start_date AND NVL(ter.end_date, HR_GENERAL.END_OF_TIME )

325: ter.start_date AND NVL(ter.end_date, HR_GENERAL.END_OF_TIME )
326: )
327: OR
328: ( NVL(p_end_date, HR_GENERAL.END_OF_TIME ) BETWEEN
329: ter.start_date AND NVL(ter.end_date, HR_GENERAL.END_OF_TIME )
330: )
331: )
332: OR
333: ( ter.start_date BETWEEN

Line 334: p_start_date AND NVL(p_end_date, HR_GENERAL.END_OF_TIME )

330: )
331: )
332: OR
333: ( ter.start_date BETWEEN
334: p_start_date AND NVL(p_end_date, HR_GENERAL.END_OF_TIME )
335: )
336: OR
337: ( NVL(ter.end_date, HR_GENERAL.END_OF_TIME ) BETWEEN
338: p_start_date AND NVL(p_end_date, HR_GENERAL.END_OF_TIME )

Line 337: ( NVL(ter.end_date, HR_GENERAL.END_OF_TIME ) BETWEEN

333: ( ter.start_date BETWEEN
334: p_start_date AND NVL(p_end_date, HR_GENERAL.END_OF_TIME )
335: )
336: OR
337: ( NVL(ter.end_date, HR_GENERAL.END_OF_TIME ) BETWEEN
338: p_start_date AND NVL(p_end_date, HR_GENERAL.END_OF_TIME )
339: )
340:
341: );

Line 338: p_start_date AND NVL(p_end_date, HR_GENERAL.END_OF_TIME )

334: p_start_date AND NVL(p_end_date, HR_GENERAL.END_OF_TIME )
335: )
336: OR
337: ( NVL(ter.end_date, HR_GENERAL.END_OF_TIME ) BETWEEN
338: p_start_date AND NVL(p_end_date, HR_GENERAL.END_OF_TIME )
339: )
340:
341: );
342: --

Line 679: ter.start_date AND NVL(ter.end_date, HR_GENERAL.END_OF_TIME );

675: OR
676: ( p_bg_id IS NULL ) )
677: AND
678: p_start_date BETWEEN
679: ter.start_date AND NVL(ter.end_date, HR_GENERAL.END_OF_TIME );
680: --
681: l_bad_start_date varchar2(5) := NULL;
682: --
683: BEGIN

Line 707: IF p_start_date > NVL(p_end_date, HR_GENERAL.END_OF_TIME )

703: end if;
704: --
705: -- check that date from is not greater than end_date
706: --
707: IF p_start_date > NVL(p_end_date, HR_GENERAL.END_OF_TIME )
708: THEN
709: --
710: hr_utility.set_message(809, 'HXC_0057_DAR_FROM_MORE_THAN_TO');
711: hr_utility.raise_error;

Line 781: ter.start_date AND NVL(ter.end_date, HR_GENERAL.END_OF_TIME );

777: OR
778: ( p_bg_id IS NULL ) )
779: AND
780: p_end_date BETWEEN
781: ter.start_date AND NVL(ter.end_date, HR_GENERAL.END_OF_TIME );
782: --
783: l_bad_end_date varchar2(5) := NULL;
784: --
785: BEGIN

Line 795: IF NVL(p_end_date, HR_GENERAL.END_OF_TIME ) < p_start_date

791: end if;
792: --
793: -- check that date to is not less than date from
794: --
795: IF NVL(p_end_date, HR_GENERAL.END_OF_TIME ) < p_start_date
796: THEN
797: --
798: hr_utility.set_message(809, 'HXC_0059_DAR_TO_LESS_THAN_FROM');
799: hr_utility.raise_error;