APPS.AP_RECURRING_INVOICES_PKG dependencies on AP_OTHER_PERIODS

Line 1632: FROM ap_other_periods

1628: ---------------------------------------------
1629: debug_info := 'Get the current period_num and period_year';
1630: SELECT period_num, period_year
1631: INTO C_current_period_num, C_period_year
1632: FROM ap_other_periods
1633: WHERE period_name = P_current_period_name
1634: AND module = 'RECURRING PAYMENTS'
1635: AND period_type = P_period_type;
1636:

Line 1644: FROM ap_other_periods

1640: BEGIN
1641: debug_info := 'Get next period_num';
1642: SELECT min(period_num)
1643: INTO C_next_period_num
1644: FROM ap_other_periods
1645: WHERE period_year = C_period_year
1646: AND to_number(period_num) > C_current_period_num
1647: AND module = 'RECURRING PAYMENTS'
1648: AND period_type = P_period_type;

Line 1662: FROM ap_other_periods

1658: BEGIN
1659: debug_info := 'Get next year period_num';
1660: SELECT min(period_num), C_period_year + 1
1661: INTO C_next_period_num, C_period_year
1662: FROM ap_other_periods
1663: WHERE period_year = C_period_year + 1
1664: AND module = 'RECURRING PAYMENTS'
1665: AND period_type = P_period_type;
1666: EXCEPTION

Line 1689: FROM ap_other_periods

1685: ----------------------------------------------------------
1686: debug_info := 'Get next period name';
1687: SELECT period_name
1688: INTO P_next_period_name
1689: FROM ap_other_periods
1690: WHERE period_year = C_period_year
1691: AND period_num = C_next_period_num
1692: AND period_type = P_period_type
1693: AND module = 'RECURRING PAYMENTS';