APPS.OKS_ENT_UTIL_PVT dependencies on FND_LOOKUPS

Line 513: FND_LOOKUPS SBR

509: CURSOR l_notes_csr IS
510: SELECT REN.TEXT
511: FROM OKC_K_ARTICLES_B KAR,
512: OKC_K_ARTICLES_TL REN,
513: FND_LOOKUPS SBR
514: WHERE KAR.ID = REN.ID
515: AND REN.SOURCE_LANG = USERENV('LANG')
516: AND KAR.CHR_ID = p_hdr_id
517: AND KAR.CAT_TYPE = 'NSD'

Line 1055: fnd_lookups fd

1051: Select fd.meaning
1052: from okc_k_lines_b kl,
1053: okc_rule_groups_b rg,
1054: okc_rules_b rl,
1055: fnd_lookups fd
1056: where kl.id = rg.cle_id
1057: and kl.lse_id in(2,15,20)
1058: and rg.id = rl.rgp_id
1059: and rl.rule_information1 = fd.lookup_code

Line 1072: l_cov_name FND_LOOKUPS.MEANING%TYPE;

1068: oks_cov_types_v covtyp
1069: where okscle.coverage_type = covtyp.code
1070: and okscle.cle_id = p_line_id;
1071:
1072: l_cov_name FND_LOOKUPS.MEANING%TYPE;
1073:
1074: BEGIN
1075:
1076: OPEN l_cov_csr;

Line 1088: FROM FND_LOOKUPS

1084: FUNCTION get_billrate(p_rate_code IN VARCHAR2) Return Varchar2
1085: IS
1086: CURSOR l_billratemng_csr IS
1087: SELECT MEANING
1088: FROM FND_LOOKUPS
1089: WHERE LOOKUP_TYPE='OKS_BILLING_RATE'
1090: AND LOOKUP_CODE = p_rate_code;
1091:
1092: l_rate_mng varchar2(30);