APPS.AP_CREATE_PAY_SCHEDS_PKG dependencies on AP_OTHER_PERIODS

Line 50: l_debug_info := 'Get due_date from ap_other_periods';

46:
47: IF (p_calendar IS NOT NULL) THEN
48: BEGIN
49: -- bug2639133 added truncate function
50: l_debug_info := 'Get due_date from ap_other_periods';
51: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
52: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
53: END IF;
54:

Line 57: FROM ap_other_periods aop

53: END IF;
54:
55: SELECT due_date
56: INTO l_due_date
57: FROM ap_other_periods aop
58: WHERE aop.period_type = p_calendar
59: AND aop.module = 'PAYMENT TERMS'
60: AND TRUNC(P_Terms_Date) BETWEEN start_date AND end_date;
61: EXCEPTION

Line 165: l_due_date ap_other_periods.due_date%TYPE;

161: l_sign_due_amount ap_terms_lines.due_amount%TYPE;
162: l_sign_remaining_amount ap_terms_lines.due_amount%TYPE;
163: l_calendar ap_terms_lines.calendar%TYPE;
164: l_terms_calendar ap_terms_lines.calendar%TYPE;
165: l_due_date ap_other_periods.due_date%TYPE;
166: l_invoice_sign NUMBER;
167: l_pay_sched_total NUMBER := 0; -- 4537932
168: l_inv_curr_sched_total NUMBER;
169: l_remaining_amount ap_payment_schedules.amount_remaining%TYPE;

Line 1220: l_due_date ap_other_periods.due_date%TYPE; -- for payment terms

1216: l_sign_due_amount ap_terms_lines.due_amount%TYPE;
1217: l_sign_remaining_amount ap_terms_lines.due_amount%TYPE;
1218: l_calendar ap_terms_lines.calendar%TYPE; -- for payment terms
1219: l_terms_calendar ap_terms_lines.calendar%TYPE; -- for payment terms
1220: l_due_date ap_other_periods.due_date%TYPE; -- for payment terms
1221: l_invoice_sign NUMBER;
1222: l_pay_sched_total NUMBER;
1223: l_inv_curr_sched_total NUMBER;
1224: l_remaining_amount ap_payment_schedules.amount_remaining%TYPE;