APPS.OKS_BRL_PVT dependencies on FND_LOOKUPS

Line 468: from FND_LOOKUPS

464: p_credit_option IN VARCHAR2) IS
465: l_dummy_var VARCHAR2(1) := '?';
466: Cursor l_fndv_csr Is
467: select 'x'
468: from FND_LOOKUPS
469: where lookup_code = p_credit_option
470: and lookup_type = 'OKS_CREDIT_AMOUNT'
471: and sysdate between nvl(start_date_active,sysdate)
472: and nvl(end_date_active,sysdate)

Line 499: -- Validate from the LookUp FND_LOOKUPS Where lookup_type IS OKS_CREDIT_AMOUNT --

495:
496: ELSE
497:
498: ---------------------------------------------------------------------------------
499: -- Validate from the LookUp FND_LOOKUPS Where lookup_type IS OKS_CREDIT_AMOUNT --
500: ---------------------------------------------------------------------------------
501:
502: Open l_fndv_csr;
503: Fetch l_fndv_csr Into l_dummy_var;

Line 584: from FND_LOOKUPS

580: p_termination_reason_code IN VARCHAR2) IS
581: l_dummy_var VARCHAR2(1) := '?';
582: Cursor l_fndv_csr Is
583: select 'x'
584: from FND_LOOKUPS
585: where lookup_code = p_termination_reason_code
586: and lookup_type = 'OKC_TERMINATION_REASON'
587: and sysdate between nvl(start_date_active,sysdate)
588: and nvl(end_date_active,sysdate)

Line 615: -- Validate from the LookUp FND_LOOKUPS Where lookup_type IS TERMINATION_REASON_CODE --

611:
612: ELSE
613:
614: ---------------------------------------------------------------------------------------
615: -- Validate from the LookUp FND_LOOKUPS Where lookup_type IS TERMINATION_REASON_CODE --
616: ---------------------------------------------------------------------------------------
617:
618: Open l_fndv_csr;
619: Fetch l_fndv_csr Into l_dummy_var;

Line 702: from FND_LOOKUPS

698: p_transfer_option_code IN VARCHAR2) IS
699: l_dummy_var VARCHAR2(1) := '?';
700: Cursor l_fndv_csr Is
701: select 'x'
702: from FND_LOOKUPS
703: where lookup_code = p_transfer_option_code
704: and lookup_type = 'OKS_TRANSFER_RULES'
705: and sysdate between nvl(start_date_active,sysdate)
706: and nvl(end_date_active,sysdate)

Line 733: -- Validate from the LookUp FND_LOOKUPS Where lookup_type IS OKS_TRANSFER_RULES --

729:
730: ELSE
731:
732: ----------------------------------------------------------------------------------
733: -- Validate from the LookUp FND_LOOKUPS Where lookup_type IS OKS_TRANSFER_RULES --
734: ----------------------------------------------------------------------------------
735:
736: Open l_fndv_csr;
737: Fetch l_fndv_csr Into l_dummy_var;