APPS.HR_GBBAL dependencies on FND_DATE

Line 522: ,fnd_date.canonical_to_date('4712/12/31'))

518: IS
519: l_event_from_date date;
520: BEGIN
521: select nvl(min(P.effective_start_date)
522: ,fnd_date.canonical_to_date('4712/12/31'))
523: into l_event_from_date
524: from per_people_f p, /* should this be all ? */
525: per_assignments_f ass
526: where p.per_information2 = 'Y'

Line 640: l_period_from_date DATE := FND_DATE.CANONICAL_TO_DATE('0001/01/01');

636: l_balance NUMBER;
637: l_balance1 NUMBER;
638: l_assignment_id NUMBER;
639: l_balance_type_id NUMBER;
640: l_period_from_date DATE := FND_DATE.CANONICAL_TO_DATE('0001/01/01');
641: l_event_from_date DATE := FND_DATE.CANONICAL_TO_DATE('0001/01/01');
642: l_to_date DATE;
643: l_regular_payment_date DATE;
644: l_action_sequence NUMBER;

Line 641: l_event_from_date DATE := FND_DATE.CANONICAL_TO_DATE('0001/01/01');

637: l_balance1 NUMBER;
638: l_assignment_id NUMBER;
639: l_balance_type_id NUMBER;
640: l_period_from_date DATE := FND_DATE.CANONICAL_TO_DATE('0001/01/01');
641: l_event_from_date DATE := FND_DATE.CANONICAL_TO_DATE('0001/01/01');
642: l_to_date DATE;
643: l_regular_payment_date DATE;
644: l_action_sequence NUMBER;
645: l_business_group_id NUMBER;