APPS.CN_API dependencies on CN_ACC_PERIOD_STATUSES_V

Line 1460: RETURN cn_acc_period_statuses_v.end_date%TYPE IS

1456: --| ---------------------------------------------------------------------=
1457: --| Function Name : next_period
1458: --| ---------------------------------------------------------------------=
1459: FUNCTION next_period (p_end_date DATE, p_org_id NUMBER)
1460: RETURN cn_acc_period_statuses_v.end_date%TYPE IS
1461:
1462: l_next_end_date cn_acc_period_statuses_v.end_date%TYPE;
1463:
1464: BEGIN

Line 1462: l_next_end_date cn_acc_period_statuses_v.end_date%TYPE;

1458: --| ---------------------------------------------------------------------=
1459: FUNCTION next_period (p_end_date DATE, p_org_id NUMBER)
1460: RETURN cn_acc_period_statuses_v.end_date%TYPE IS
1461:
1462: l_next_end_date cn_acc_period_statuses_v.end_date%TYPE;
1463:
1464: BEGIN
1465:
1466: SELECT MAX(end_date)

Line 1468: FROM cn_acc_period_statuses_v

1464: BEGIN
1465:
1466: SELECT MAX(end_date)
1467: INTO l_next_end_date
1468: FROM cn_acc_period_statuses_v
1469: WHERE period_status IN ('F', 'O')
1470: AND org_id = p_org_id;
1471:
1472: IF trunc(l_next_end_date) > trunc(p_end_date) THEN

Line 1476: FROM cn_acc_period_statuses_v

1472: IF trunc(l_next_end_date) > trunc(p_end_date) THEN
1473:
1474: SELECT MIN(end_date)
1475: INTO l_next_end_date
1476: FROM cn_acc_period_statuses_v
1477: WHERE trunc(end_date) >= trunc(p_end_date)
1478: AND period_status IN ('F', 'O')
1479: AND org_id = p_org_id;
1480:

Line 1550: FROM cn_acc_period_statuses_v

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

Line 1572: FROM cn_acc_period_statuses_v

1568:
1569: BEGIN
1570: SELECT period_name
1571: INTO l_period_name
1572: FROM cn_acc_period_statuses_v
1573: WHERE period_id = p_period_id
1574: AND org_id = p_org_id;
1575:
1576: RETURN l_period_name;

Line 1735: FROM cn_acc_period_statuses_v

1731: CURSOR l_last_date_cr IS
1732:
1733: -- fixed query for bug 5075017
1734: SELECT MAX(end_date)
1735: FROM cn_acc_period_statuses_v
1736: WHERE period_status IN ('F', 'O')
1737: AND org_id = p_org_id;
1738:
1739: BEGIN

Line 1788: FROM cn_acc_period_statuses_v

1784: -- --------------------------------------------------------------------------=
1785: FUNCTION get_acc_period_id (p_date DATE, p_org_id NUMBER) RETURN NUMBER IS
1786: CURSOR l_date_period_csr IS
1787: SELECT period_id
1788: FROM cn_acc_period_statuses_v
1789: WHERE p_date BETWEEN start_date AND end_date
1790: AND org_id = p_org_id;
1791:
1792: CURSOR l_null_date_period_csr IS

Line 1794: FROM cn_acc_period_statuses_v

1790: AND org_id = p_org_id;
1791:
1792: CURSOR l_null_date_period_csr IS
1793: SELECT MAX(period_id)
1794: FROM cn_acc_period_statuses_v
1795: WHERE period_status = 'O'
1796: AND org_id = p_org_id;
1797:
1798: l_period_id NUMBER(15);

Line 1838: FROM cn_acc_period_statuses_v

1834: FUNCTION get_acc_period_id_fo (p_date DATE, p_org_id NUMBER) RETURN NUMBER IS
1835:
1836: CURSOR l_date_period_csr IS
1837: SELECT period_id
1838: FROM cn_acc_period_statuses_v
1839: WHERE p_date BETWEEN start_date AND end_date
1840: AND org_id = p_org_id;
1841:
1842: CURSOR l_null_date_period_csr IS

Line 1844: FROM cn_acc_period_statuses_v

1840: AND org_id = p_org_id;
1841:
1842: CURSOR l_null_date_period_csr IS
1843: SELECT MIN(period_id)
1844: FROM cn_acc_period_statuses_v
1845: WHERE period_status = 'O'
1846: AND org_id = p_org_id;
1847:
1848: l_period_id NUMBER(15);