APPS.PJI_UTILS dependencies on PJI_LOOKUPS

Line 1711: FROM pji_lookups

1707: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1708:
1709: SELECT lookup_code , RPAD(MEANING,45,' ')||': ' BULK COLLECT
1710: INTO prof_opt_tbl,prof_val_tbl
1711: FROM pji_lookups
1712: WHERE lookup_type = 'PJI_CHK_BIS_PARAMS'
1713: and lookup_code in ( 'BIS_PR_CURR',
1714: 'BIS_PR_RATE',
1715: 'BIS_SE_CURR',

Line 1761: FROM pji_lookups

1757: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1758:
1759: SELECT lookup_code , RPAD(MEANING,45,' ')||': ' BULK COLLECT
1760: INTO prof_opt_tbl,prof_val_tbl
1761: FROM pji_lookups
1762: WHERE lookup_type = 'PJI_CHK_PJP_SET_PARAMS'
1763: and lookup_code in ( 'PJI_EXTRACTION_BATCH_SIZE','PJI_DEF_RPT_CUR_TYPE','PJI_DEF_RPT_CAL_TYPE');
1764:
1765: FOR I IN 1..prof_opt_tbl.COUNT LOOP

Line 1911: FROM pji_lookups

1907: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1908:
1909: SELECT lookup_code , RPAD(MEANING,45,' ')||': ' BULK COLLECT
1910: INTO prof_opt_tbl,prof_val_tbl
1911: FROM pji_lookups
1912: WHERE lookup_type = 'PJI_CHK_PJP_SET_PARAMS'
1913: and lookup_code in ( 'PJP_SE_GLO_CURR',
1914: 'PJP_TXN_CURR',
1915: 'PJP_PLN_AMT_ALC',

Line 2105: FROM pji_lookups

2101: l_meaning varchar2(100);
2102: BEGIN
2103: IF p_lookup_code is not null then
2104: SELECT meaning into l_meaning
2105: FROM pji_lookups
2106: WHERE lookup_type = p_lookup_type
2107: and lookup_code = p_lookup_code;
2108: return l_meaning;
2109: else