APPS.ARP_DEDUCTION_COVER dependencies on ARPT_SQL_FUNC_UTIL

Line 121: IF (ARPT_SQL_FUNC_UTIL.get_claim_amount(l_claim_id) = 0) THEN

117: | 2) Update payment schedule record |
118: +---------------------------------------------------------------------*/
119:
120: IF (l_payment_schedule_id > 0) THEN
121: IF (ARPT_SQL_FUNC_UTIL.get_claim_amount(l_claim_id) = 0) THEN
122: l_active_claim_flag := 'N';
123: ELSE
124: l_active_claim_flag := 'Y';
125: END IF;

Line 1103: ARPT_SQL_FUNC_UTIL.get_claim_amount(l_claim_id) = 0)

1099: p_called_from => 'TRADE_MANAGEMENT');
1100: END IF;
1101:
1102: IF (p_customer_trx_id IS NOT NULL AND
1103: ARPT_SQL_FUNC_UTIL.get_claim_amount(l_claim_id) = 0)
1104: THEN
1105: BEGIN
1106: UPDATE ar_payment_schedules
1107: SET active_claim_flag = 'N'