APPS.PJI_UTILS dependencies on PJI_LOOKUPS

Line 1572: FROM pji_lookups

1568: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1569:
1570: SELECT lookup_code , RPAD(MEANING,45,' ')||': ' BULK COLLECT
1571: INTO prof_opt_tbl,prof_val_tbl
1572: FROM pji_lookups
1573: WHERE lookup_type = 'PJI_CHK_BIS_PARAMS'
1574: and lookup_code in ( 'BIS_PR_CURR',
1575: 'BIS_PR_RATE',
1576: 'BIS_SE_CURR',

Line 1742: FROM pji_lookups

1738: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1739:
1740: SELECT lookup_code , RPAD(MEANING,45,' ')||': ' BULK COLLECT
1741: INTO prof_opt_tbl,prof_val_tbl
1742: FROM pji_lookups
1743: WHERE lookup_type = 'PJI_CHK_PJP_SET_PARAMS'
1744: and lookup_code in ( 'PJP_SE_GLO_CURR',
1745: 'PJP_TXN_CURR',
1746: 'PJP_PLN_AMT_ALC',

Line 1936: FROM pji_lookups

1932: l_meaning varchar2(100);
1933: BEGIN
1934: IF p_lookup_code is not null then
1935: SELECT meaning into l_meaning
1936: FROM pji_lookups
1937: WHERE lookup_type = p_lookup_type
1938: and lookup_code = p_lookup_code;
1939: return l_meaning;
1940: else