DBA Data[Home] [Help]

APPS.AP_PPA_PKG dependencies on AP_TERMS_LINES

Line 1089: FROM ap_terms_lines

1085: -------------------------------
1086:
1087: SELECT count(*)
1088: INTO p_last_term_ps_pay_num
1089: FROM ap_terms_lines
1090: WHERE term_id = p_term_id;
1091:
1092: ------------------------------------------------
1093: -- get percentage of amt_remaining vs gross_amt

Line 1329: FROM ap_terms_lines

1325: l_debug_info := 'Get calendar for terms lines';
1326: --
1327: SELECT calendar
1328: INTO l_terms_calendar
1329: FROM ap_terms_lines
1330: WHERE term_id = p_term_id
1331: AND sequence_num = p_ps_pay_num;
1332:
1333: l_debug_info := 'Get due date info';

Line 1498: FROM ap_terms t, ap_terms_lines atl

1494: p_discount_percent_2,
1495: p_discount_percent_3,
1496: p_due_amount,
1497: p_due_percent
1498: FROM ap_terms t, ap_terms_lines atl
1499: WHERE t.term_id = atl.term_id
1500: AND atl.term_id = p_term_id
1501: AND atl.sequence_num = p_ps_pay_num;
1502: