APPS.CN_API dependencies on CN_ACC_PERIOD_STATUSES_V

Line 1438: RETURN cn_acc_period_statuses_v.end_date%TYPE IS

1434: --| ---------------------------------------------------------------------=
1435: --| Function Name : next_period
1436: --| ---------------------------------------------------------------------=
1437: FUNCTION next_period (p_end_date DATE, p_org_id NUMBER)
1438: RETURN cn_acc_period_statuses_v.end_date%TYPE IS
1439:
1440: l_next_end_date cn_acc_period_statuses_v.end_date%TYPE;
1441:
1442: BEGIN

Line 1440: l_next_end_date cn_acc_period_statuses_v.end_date%TYPE;

1436: --| ---------------------------------------------------------------------=
1437: FUNCTION next_period (p_end_date DATE, p_org_id NUMBER)
1438: RETURN cn_acc_period_statuses_v.end_date%TYPE IS
1439:
1440: l_next_end_date cn_acc_period_statuses_v.end_date%TYPE;
1441:
1442: BEGIN
1443:
1444: SELECT MAX(end_date)

Line 1446: FROM cn_acc_period_statuses_v

1442: BEGIN
1443:
1444: SELECT MAX(end_date)
1445: INTO l_next_end_date
1446: FROM cn_acc_period_statuses_v
1447: WHERE period_status IN ('F', 'O')
1448: AND org_id = p_org_id;
1449:
1450: IF trunc(l_next_end_date) > trunc(p_end_date) THEN

Line 1454: FROM cn_acc_period_statuses_v

1450: IF trunc(l_next_end_date) > trunc(p_end_date) THEN
1451:
1452: SELECT MIN(end_date)
1453: INTO l_next_end_date
1454: FROM cn_acc_period_statuses_v
1455: WHERE trunc(end_date) >= trunc(p_end_date)
1456: AND period_status IN ('F', 'O')
1457: AND org_id = p_org_id;
1458:

Line 1528: FROM cn_acc_period_statuses_v

1524:
1525: BEGIN
1526: SELECT period_id
1527: INTO l_period_id
1528: FROM cn_acc_period_statuses_v
1529: WHERE period_name = p_period_name
1530: AND org_id = p_org_id;
1531:
1532: RETURN l_period_id;

Line 1550: FROM cn_acc_period_statuses_v

1546:
1547: BEGIN
1548: SELECT period_name
1549: INTO l_period_name
1550: FROM cn_acc_period_statuses_v
1551: WHERE period_id = p_period_id
1552: AND org_id = p_org_id;
1553:
1554: RETURN l_period_name;

Line 1713: FROM cn_acc_period_statuses_v

1709: CURSOR l_last_date_cr IS
1710:
1711: -- fixed query for bug 5075017
1712: SELECT MAX(end_date)
1713: FROM cn_acc_period_statuses_v
1714: WHERE period_status IN ('F', 'O')
1715: AND org_id = p_org_id;
1716:
1717: BEGIN

Line 1766: FROM cn_acc_period_statuses_v

1762: -- --------------------------------------------------------------------------=
1763: FUNCTION get_acc_period_id (p_date DATE, p_org_id NUMBER) RETURN NUMBER IS
1764: CURSOR l_date_period_csr IS
1765: SELECT period_id
1766: FROM cn_acc_period_statuses_v
1767: WHERE p_date BETWEEN start_date AND end_date
1768: AND org_id = p_org_id;
1769:
1770: CURSOR l_null_date_period_csr IS

Line 1772: FROM cn_acc_period_statuses_v

1768: AND org_id = p_org_id;
1769:
1770: CURSOR l_null_date_period_csr IS
1771: SELECT MAX(period_id)
1772: FROM cn_acc_period_statuses_v
1773: WHERE period_status = 'O'
1774: AND org_id = p_org_id;
1775:
1776: l_period_id NUMBER(15);

Line 1816: FROM cn_acc_period_statuses_v

1812: FUNCTION get_acc_period_id_fo (p_date DATE, p_org_id NUMBER) RETURN NUMBER IS
1813:
1814: CURSOR l_date_period_csr IS
1815: SELECT period_id
1816: FROM cn_acc_period_statuses_v
1817: WHERE p_date BETWEEN start_date AND end_date
1818: AND org_id = p_org_id;
1819:
1820: CURSOR l_null_date_period_csr IS

Line 1822: FROM cn_acc_period_statuses_v

1818: AND org_id = p_org_id;
1819:
1820: CURSOR l_null_date_period_csr IS
1821: SELECT MIN(period_id)
1822: FROM cn_acc_period_statuses_v
1823: WHERE period_status = 'O'
1824: AND org_id = p_org_id;
1825:
1826: l_period_id NUMBER(15);