DBA Data[Home] [Help]

APPS.PAY_NL_EOY_PKG dependencies on FND_NEW_MESSAGES

Line 1089: TYPE exception_info IS TABLE OF FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE INDEX BY BINARY_INTEGER;

1085: --12608988 Start
1086: exceptions_count number :=0;
1087: l_last_assignment_id number :=0;
1088: l_max_assignment_end_date DATE :=TO_DATE('01/01/0001','DD/MM/YYYY');
1089: TYPE exception_info IS TABLE OF FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE INDEX BY BINARY_INTEGER;
1090: tab_exceptions exception_info;
1091:
1092: CURSOR csr_get_asg_max_end_date(p_asg_id IN NUMBER) IS
1093: SELECT max (asg.effective_end_date) max_end_date