APPS.PSP_GENERAL dependencies on PSP_LOOKUPS

Line 1540: FROM PSP_LOOKUPS

1536: FUNCTION get_status_description (p_status_code IN VARCHAR2) RETURN VARCHAR2 IS
1537: /***** Modified the following cursor for R12 performance fixes (bug 4507892)
1538: CURSOR status_description_cur IS
1539: SELECT MEANING
1540: FROM PSP_LOOKUPS
1541: WHERE lookup_code = p_status_code
1542: AND lookup_type = 'PSP_STATUS';
1543: End of comment for R12 performance fixes (bug 4507892) *****/
1544: -- New cursor defn. for bug fix 4507892

Line 1552: l_status_description psp_lookups.meaning%TYPE;

1548: WHERE lookup_type = 'PSP_STATUS'
1549: AND lookup_code = p_status_code
1550: AND language = USERENV('LANG');
1551:
1552: l_status_description psp_lookups.meaning%TYPE;
1553:
1554: BEGIN
1555: OPEN status_description_cur;
1556: FETCH status_description_cur INTO l_status_description;

Line 1569: FROM PSP_LOOKUPS

1565: FUNCTION get_error_description (p_error_code IN VARCHAR2) RETURN VARCHAR2 IS
1566: /***** Modified the following cursor for R12 performance fixes (bug 4507892)
1567: CURSOR error_description_cur IS
1568: SELECT MEANING
1569: FROM PSP_LOOKUPS
1570: WHERE lookup_code = p_error_code
1571: AND lookup_type = 'PSP_ERROR_CODE';
1572: End of comment for R12 performace fixes (bug 4507892) *****/
1573:

Line 1582: l_error_description psp_lookups.meaning%TYPE;

1578: WHERE lookup_type = 'PSP_ERROR_CODE'
1579: AND lookup_code = p_error_code
1580: AND language = USERENV('LANG');
1581:
1582: l_error_description psp_lookups.meaning%TYPE;
1583:
1584: BEGIN
1585: OPEN error_description_cur;
1586: FETCH error_description_cur INTO l_error_description;