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 1069: ARPT_SQL_FUNC_UTIL.get_claim_amount(l_claim_id) = 0)

1065: p_called_from => 'TRADE_MANAGEMENT');
1066: END IF;
1067:
1068: IF (p_customer_trx_id IS NOT NULL AND
1069: ARPT_SQL_FUNC_UTIL.get_claim_amount(l_claim_id) = 0)
1070: THEN
1071: BEGIN
1072: UPDATE ar_payment_schedules
1073: SET active_claim_flag = 'N'