APPS.PJI_AUDIT_RPT dependencies on PJI_LOOKUPS

Line 72: FROM pji_lookups

68: l_cnt_set_up_err := l_cnt_set_up_err + 1;
69:
70: SELECT meaning
71: INTO l_period_set_name_tkn
72: FROM pji_lookups
73: WHERE lookup_type = 'PJI_CHK_BIS_PARAMS'
74: and lookup_code = 'BIS_ENT_CAL';
75:
76: l_bis_param_name_tbl.EXTEND;

Line 85: FROM pji_lookups

81: l_cnt_set_up_err := l_cnt_set_up_err + 1;
82:
83: SELECT meaning
84: INTO l_global_st_date_tkn
85: FROM pji_lookups
86: WHERE lookup_type = 'PJI_CHK_BIS_PARAMS'
87: and lookup_code = 'BIS_GLO_ST_DT';
88:
89: l_bis_param_name_tbl.EXTEND;

Line 98: FROM pji_lookups

94: l_cnt_set_up_err := l_cnt_set_up_err + 1;
95:
96: SELECT meaning
97: INTO l_period_type_tkn
98: FROM pji_lookups
99: WHERE lookup_type = 'PJI_CHK_BIS_PARAMS'
100: and lookup_code = 'BIS_PD_TYPE';
101:
102: l_bis_param_name_tbl.EXTEND;

Line 111: FROM pji_lookups

107: l_cnt_set_up_err := l_cnt_set_up_err + 1;
108:
109: SELECT meaning
110: INTO l_currency_code_tkn
111: FROM pji_lookups
112: WHERE lookup_type = 'PJI_CHK_BIS_PARAMS'
113: and lookup_code = 'BIS_PR_CURR';
114:
115: l_bis_param_name_tbl.EXTEND;

Line 124: FROM pji_lookups

120: l_cnt_set_up_err := l_cnt_set_up_err + 1;
121:
122: SELECT meaning
123: INTO l_rate_type_tkn
124: FROM pji_lookups
125: WHERE lookup_type = 'PJI_CHK_BIS_PARAMS'
126: and lookup_code = 'BIS_PR_RATE';
127:
128: l_bis_param_name_tbl.EXTEND;

Line 137: FROM pji_lookups

133: l_cnt_set_up_err := l_cnt_set_up_err + 1;
134:
135: SELECT meaning
136: INTO l_start_dt_of_week_tkn
137: FROM pji_lookups
138: WHERE lookup_type = 'PJI_CHK_BIS_PARAMS'
139: and lookup_code = 'BIS_ST_DT_WK';
140:
141: l_bis_param_name_tbl.EXTEND;

Line 210: FROM pji_lookups

206: l_cnt_set_up_err := l_cnt_set_up_err + 1;
207:
208: SELECT meaning
209: INTO l_org_structure_id_tkn
210: FROM pji_lookups
211: WHERE lookup_type = 'PJI_CHK_PJI_SET_PARAMS'
212: and lookup_code = 'ORG_STRUC';
213:
214: l_pji_param_name_tbl.EXTEND;

Line 223: FROM pji_lookups

219: l_cnt_set_up_err := l_cnt_set_up_err + 1;
220:
221: SELECT meaning
222: INTO l_org_structure_ver_tkn
223: FROM pji_lookups
224: WHERE lookup_type = 'PJI_CHK_PJI_SET_PARAMS'
225: and lookup_code = 'ORG_ST_VER';
226:
227: l_pji_param_name_tbl.EXTEND;

Line 672: FROM pji_lookups

668: l_cnt_set_up_err := l_cnt_set_up_err + 1;
669:
670: SELECT meaning
671: INTO l_pji_security_prof_tkn
672: FROM pji_lookups
673: WHERE lookup_type = 'PJI_CHK_SECURITY_PARAMS'
674: and lookup_code = 'PJI_ORG_PROF';
675:
676: l_sec_prof_param_name_tbl.EXTEND;

Line 685: FROM pji_lookups

681: l_cnt_set_up_err := l_cnt_set_up_err + 1;
682:
683: SELECT meaning
684: INTO l_mo_security_prof_tkn
685: FROM pji_lookups
686: WHERE lookup_type = 'PJI_CHK_SECURITY_PARAMS'
687: and lookup_code = 'PJI_MO_PROF';
688:
689: l_sec_prof_param_name_tbl.EXTEND;