DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_UTILS dependencies on PA_ASSIGNMENT_APPROVAL_PUB

Line 575: IF p_apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted THEN

571: BEGIN
572:
573: l_today_date := TRUNC (sysdate);
574:
575: IF p_apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted THEN
576: l_lookup_code := 'PENDING';
577: ELSIF ( l_today_date <= p_start_date) AND (l_today_date >= (p_start_date - p_num_of_weeks*7)) THEN
578: l_lookup_code := 'ROLL_ON';
579: ELSIF (l_today_date <= p_end_date) AND (l_today_date >= (p_end_date - p_num_of_weeks*7)) THEN

Line 616: IF p_apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted THEN

612: BEGIN
613:
614: l_today_date := TRUNC(sysdate);
615:
616: IF p_apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted THEN
617: l_date := p_start_date;
618: ELSIF (l_today_date <= p_start_date) AND (l_today_date >= (p_start_date - p_num_of_weeks*7)) THEN
619: l_date := p_start_date;
620: ELSIF (l_today_date <= p_end_date) AND (l_today_date >= (p_end_date - p_num_of_weeks*7)) THEN