APPS.OKC_ARTICLES_IMPORT_GRP dependencies on FND_LOOKUPS

Line 155: fnd_lookups f

151: SELECT
152: total_rows_processed,total_rows_failed,
153: f.meaning entity_meaning
154: FROM OKC_ART_INT_BATPROCS_ALL a,
155: fnd_lookups f
156: WHERE UPPER(a.entity) = f.lookup_code
157: and f.lookup_type = 'OKC_ARTICLE_IMPORT_ENTITY'
158: and a.batch_process_id = p_batch_procs_id
159: and a.batch_number = p_batch_number

Line 414: FROM fnd_lookups

410: l_import_src_meaning VARCHAR2(1);
411:
412: CURSOR lookup_meaning_csr (cp_code IN VARCHAR2) IS
413: SELECT meaning
414: FROM fnd_lookups
415: WHERE lookup_type = 'OKC_YN' and lookup_code = cp_code;
416:
417: CURSOR import_src_csr IS
418: SELECT import_source

Line 434: fnd_lookups f,fnd_lookups f1,fnd_lookups f2,hr_organization_units hr

430: f.meaning validate_meaning,
431: nvl(f1.meaning,' ') global_flag_meaning,
432: nvl(f2.meaning,' ') status_meaning
433: FROM OKC_ART_INT_BATPROCS_ALL a,
434: fnd_lookups f,fnd_lookups f1,fnd_lookups f2,hr_organization_units hr
435: WHERE a.validate_only_yn = f.lookup_code
436: and f.lookup_type = 'OKC_YN'
437: and a.global_flag = f1.lookup_code (+)
438: and f1.lookup_type (+)= 'OKC_YN'

Line 453: fnd_lookups f

449: SELECT
450: fnd_date.date_to_displaydt( a.start_date, FND_DATE.calendar_aware_alt) start_date,
451: f.meaning validate_meaning,a.fetch_size
452: FROM OKC_ART_INT_BATPROCS_ALL a,
453: fnd_lookups f
454: WHERE a.validate_only_yn = f.lookup_code
455: and f.lookup_type = 'OKC_YN'
456: and a.batch_process_id = p_batch_procs_id
457: and a.batch_number = p_batch_number

Line 1660: FROM fnd_lookups

1656: l_tot_rows_warned NUMBER;
1657:
1658: CURSOR lookup_meaning_csr (cp_code IN VARCHAR2) IS
1659: SELECT meaning
1660: FROM fnd_lookups
1661: WHERE lookup_type = 'OKC_YN' and lookup_code = cp_code;
1662:
1663: CURSOR org_name_csr (cp_org_id IN NUMBER) IS
1664: SELECT NAME

Line 1670: FROM fnd_lookups

1666: WHERE ORGANIZATION_ID = cp_org_id;
1667:
1668: CURSOR entity_meaning_csr (cp_ent_code IN VARCHAR2) IS
1669: SELECT meaning
1670: FROM fnd_lookups
1671: WHERE lookup_type = 'OKC_ARTICLE_IMPORT_ENTITY' and lookup_code = cp_ent_code;
1672: BEGIN
1673: FND_MSG_PUB.initialize;
1674:

Line 1875: FROM fnd_lookups

1871: CURSOR validate_article_type_csr ( cp_article_type IN VARCHAR2,
1872: cp_article_id IN NUMBER,
1873: cp_action IN VARCHAR2) IS
1874: SELECT lookup_code
1875: FROM fnd_lookups
1876: WHERE lookup_type = 'OKC_SUBJECT'
1877: AND lookup_code = cp_article_type
1878: AND start_date_active <= trunc(sysdate)
1879: AND nvl(end_date_active,sysdate+1) >= trunc(sysdate);