APPS.AP_RECURRING_INVOICES_PKG dependencies on AP_OTHER_PERIODS

Line 1608: FROM ap_other_periods

1604: ---------------------------------------------
1605: debug_info := 'Get the current period_num and period_year';
1606: SELECT period_num, period_year
1607: INTO C_current_period_num, C_period_year
1608: FROM ap_other_periods
1609: WHERE period_name = P_current_period_name
1610: AND module = 'RECURRING PAYMENTS'
1611: AND period_type = P_period_type;
1612:

Line 1620: FROM ap_other_periods

1616: BEGIN
1617: debug_info := 'Get next period_num';
1618: SELECT min(period_num)
1619: INTO C_next_period_num
1620: FROM ap_other_periods
1621: WHERE period_year = C_period_year
1622: AND to_number(period_num) > C_current_period_num
1623: AND module = 'RECURRING PAYMENTS'
1624: AND period_type = P_period_type;

Line 1638: FROM ap_other_periods

1634: BEGIN
1635: debug_info := 'Get next year period_num';
1636: SELECT min(period_num), C_period_year + 1
1637: INTO C_next_period_num, C_period_year
1638: FROM ap_other_periods
1639: WHERE period_year = C_period_year + 1
1640: AND module = 'RECURRING PAYMENTS'
1641: AND period_type = P_period_type;
1642: EXCEPTION

Line 1665: FROM ap_other_periods

1661: ----------------------------------------------------------
1662: debug_info := 'Get next period name';
1663: SELECT period_name
1664: INTO P_next_period_name
1665: FROM ap_other_periods
1666: WHERE period_year = C_period_year
1667: AND period_num = C_next_period_num
1668: AND period_type = P_period_type
1669: AND module = 'RECURRING PAYMENTS';