APPS.IGS_PR_CLASS_RANK dependencies on DUAL

Line 1559: SELECT LTRIM (TO_CHAR (TO_DATE (cp_rank,'J'),'Jth'),'0') FROM DUAL;

1555: l_formatted_rank VARCHAR2(4000);
1556:
1557: -- cursor to get nth for a number like 84th
1558: CURSOR c_nth (cp_rank VARCHAR2) IS
1559: SELECT LTRIM (TO_CHAR (TO_DATE (cp_rank,'J'),'Jth'),'0') FROM DUAL;
1560: l_nth VARCHAR2(4000);
1561:
1562: BEGIN
1563: Fnd_Msg_Pub.Initialize;