APPS.JA_CN_PS_FA_EXP_PKG dependencies on FND_LOOKUP_VALUES

Line 328: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;

324: lv_period_from VARCHAR2(100);
325: lv_period_to VARCHAR2(100);
326:
327: ln_reqid_gle NUMBER;
328: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
329: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
330: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
331:
332: lv_error_flag VARCHAR2(1);

Line 329: lv_gle_req_status fnd_lookup_values.meaning%TYPE;

325: lv_period_to VARCHAR2(100);
326:
327: ln_reqid_gle NUMBER;
328: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
329: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
330: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
331:
332: lv_error_flag VARCHAR2(1);
333: ln_waiting_interval NUMBER := 10;

Line 330: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;

326:
327: ln_reqid_gle NUMBER;
328: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
329: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
330: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
331:
332: lv_error_flag VARCHAR2(1);
333: ln_waiting_interval NUMBER := 10;
334: lv_dev_phase VARCHAR2(100);

Line 479: FROM fnd_lookup_values

475: THEN
476: --To get lookup code for current status
477: SELECT lookup_code
478: INTO lv_gle_req_status_code
479: FROM fnd_lookup_values
480: WHERE lookup_type = 'CP_STATUS_CODE'
481: AND view_application_id = 0
482: AND security_group_id = 0
483: AND meaning = lv_gle_req_status