DBA Data[Home] [Help]

APPS.HZ_PARTY_USG_ASSIGNMENT_PVT dependencies on HZ_PARTY_USAGE_RULES

Line 1455: FROM hz_party_usage_rules

1451:
1452: -- load rules
1453: CURSOR c_exist_exclusive_rules IS
1454: SELECT null
1455: FROM hz_party_usage_rules
1456: WHERE (party_usage_rule_type = 'EXCLUSIVE' OR
1457: party_usage_rule_type = 'CANNOT_COEXIST')
1458: AND trunc(sysdate) between
1459: effective_start_date AND effective_end_date

Line 1466: FROM hz_party_usage_rules

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