APPS.OKL_IPY_PVT dependencies on FND_LOOKUPS

Line 1052: FROM FND_LOOKUPS

1048: l_dummy_var VARCHAR2(1) := '?' ;
1049: l_system_date DATE := SYSDATE ;
1050: CURSOR l_ipf_csr IS
1051: SELECT 'x'
1052: FROM FND_LOOKUPS
1053: WHERE LOOKUP_code = p_ipyv_rec.ipf_code
1054: AND LOOKUP_TYPE = G_FND_LOOKUP_PAYMENT_FREQ
1055: AND l_system_date BETWEEN NVL(start_date_active,l_system_date)
1056: AND NVL(end_date_active,l_system_date);

Line 1079: 'FND_LOOKUPS');

1075: 'Payment Frequency',
1076: g_child_table_token ,
1077: 'OKL_INS_POLICIES_V' ,
1078: g_parent_table_token ,
1079: 'FND_LOOKUPS');
1080: x_return_status := OKC_API.G_RET_STS_ERROR;
1081: END IF;
1082: END IF;
1083: EXCEPTION

Line 1413: FROM FND_LOOKUPS

1409: l_dummy_var VARCHAR2(1) := '?' ;
1410: l_system_date DATE := SYSDATE ;
1411: CURSOR l_ipe_csr IS
1412: SELECT 'x'
1413: FROM FND_LOOKUPS
1414: WHERE LOOKUP_CODE = p_ipyv_rec.ipe_code
1415: AND LOOKUP_TYPE = G_FND_LOOKUP_INS_POLICY_TYPE
1416: AND l_system_date BETWEEN NVL(start_date_active,l_system_date)
1417: AND NVL(end_date_active,l_system_date);

Line 1440: 'FND_LOOKUPS');

1436: 'Policy Type',
1437: g_child_table_token ,
1438: 'OKL_INS_POLICIES_V' ,
1439: g_parent_table_token ,
1440: 'FND_LOOKUPS');
1441: x_return_status := OKC_API.G_RET_STS_ERROR;
1442: END IF;
1443: END IF;
1444: EXCEPTION

Line 1465: FROM FND_LOOKUPS

1461: l_dummy_var VARCHAR2(1) := '?' ;
1462: l_system_date DATE := SYSDATE ;
1463: CURSOR l_crx_csr IS
1464: SELECT 'x'
1465: FROM FND_LOOKUPS
1466: WHERE LOOKUP_CODE = p_ipyv_rec.crx_code
1467: AND LOOKUP_TYPE = G_FND_LOOKUP_INS_CANCEL_REASON
1468: AND l_system_date BETWEEN NVL(start_date_active,l_system_date)
1469: AND NVL(end_date_active,l_system_date);

Line 1487: 'FND_LOOKUPS');

1483: 'Cancellation Reason',
1484: g_child_table_token ,
1485: 'OKL_INS_POLICIES_V' ,
1486: g_parent_table_token ,
1487: 'FND_LOOKUPS');
1488: x_return_status := OKC_API.G_RET_STS_ERROR;
1489: END IF;
1490: END IF;
1491: EXCEPTION

Line 1512: FROM FND_LOOKUPS

1508: l_dummy_var VARCHAR2(1) := '?' ;
1509: l_system_date DATE := SYSDATE ;
1510: CURSOR l_iss_csr IS
1511: SELECT 'x'
1512: FROM FND_LOOKUPS
1513: WHERE LOOKUP_code = p_ipyv_rec.iss_code
1514: AND LOOKUP_TYPE = G_FND_LOOKUP_INS_STATUS
1515: AND l_system_date BETWEEN NVL(start_date_active,l_system_date)
1516: AND NVL(end_date_active,l_system_date);

Line 1539: 'FND_LOOKUPS');

1535: 'Status',
1536: g_child_table_token ,
1537: 'OKL_INS_POLICIES_V' ,
1538: g_parent_table_token ,
1539: 'FND_LOOKUPS');
1540: x_return_status := OKC_API.G_RET_STS_ERROR;
1541: END IF;
1542: END IF;
1543: EXCEPTION

Line 1707: FROM FND_LOOKUPS

1703: l_dummy_var VARCHAR2(1) := '?' ;
1704: l_system_date DATE := SYSDATE ;
1705: CURSOR l_ipy_csr IS
1706: SELECT 'x'
1707: FROM FND_LOOKUPS
1708: WHERE LOOKUP_code = p_ipyv_rec.ipy_type
1709: AND LOOKUP_TYPE = G_FND_LOOKUP_POLICY_TYPE;
1710: BEGIN
1711: -- initialize return status

Line 1747: 'FND_LOOKUPS');

1743: 'Policy Type',
1744: g_child_table_token ,
1745: 'OKL_INS_POLICIES_V' ,
1746: g_parent_table_token ,
1747: 'FND_LOOKUPS');
1748: WHEN OTHERS THEN
1749: -- store SQL error message on message stack for caller
1750: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
1751: -- notify caller of an UNEXPECTED error