DBA Data[Home] [Help]

APPS.HZ_PARTY_USG_ASSIGNMENT_PVT dependencies on HZ_PARTY_USAGE_RULES

Line 1459: FROM hz_party_usage_rules

1455:
1456: -- load rules
1457: CURSOR c_exist_exclusive_rules IS
1458: SELECT null
1459: FROM hz_party_usage_rules
1460: WHERE (party_usage_rule_type = 'EXCLUSIVE' OR
1461: party_usage_rule_type = 'CANNOT_COEXIST')
1462: AND trunc(sysdate) between
1463: effective_start_date AND effective_end_date

Line 1470: FROM hz_party_usage_rules

1466: CURSOR c_party_usage_rules IS
1467: SELECT party_usage_rule_type||'##'||
1468: party_usage_code||'##'||
1469: related_party_usage_code
1470: FROM hz_party_usage_rules
1471: WHERE trunc(sysdate) between
1472: effective_start_date AND effective_end_date;
1473:
1474: -- load created by module